再开一帖子

                            sql = @"insert into contact(contactName,nickName,address,city,state,crossStreets,postalCode,otRestaurantId,otNeighborhood,otCuisine,otPrice,colorCode,version,sharedContactId,enteredBy,entryDate)

                    values(@contactName,@nickName,@address,@city,@state,@crossStreets,@postalCode,@otRestaurantId,@otNeighborhood,@otCuisine,@otPrice,@colorCode,@version,@sharedContactId,@enteredBy,getDate());

                    select @@nestlevel,scope_identity()";

                            cmd = new SqlCommand(sql, siteconnc);

                            cmd.Transaction = sqlTran;

                            cmd.Parameters.AddWithValue("@contactName", row["primaryName"]);

                            cmd.Parameters.AddWithValue("@nickName", row["phoneNumber"]);

                            cmd.Parameters.AddWithValue("@address", row["address"]);

                            cmd.Parameters.AddWithValue("@city", row["city"]);

                            cmd.Parameters.AddWithValue("@state", row["state"]);

                            cmd.Parameters.AddWithValue("@crossStreets", row["crossStreet"]);

                            cmd.Parameters.AddWithValue("@postalCode", row["postalCode"]);

                            cmd.Parameters.AddWithValue("@otRestaurantId", row["openTableId"]);

                            cmd.Parameters.AddWithValue("@otNeighborhood", row["neighborhood"]);

                            cmd.Parameters.AddWithValue("@otCuisine", row["cuisine"]);

                            cmd.Parameters.AddWithValue("@otPrice", row["otprice"]);

                            cmd.Parameters.AddWithValue("@colorCode", "normal");

                            cmd.Parameters.AddWithValue("@version", 1);

                            cmd.Parameters.AddWithValue("@sharedContactId", row["contactId"]);

                            cmd.Parameters.AddWithValue("@enteredBy", "Gold Key Solutions");

                            string contactId = cmd.ExecuteScalar().ToString();