private string GetZidTemp(DataTable data, int index) { if (string.IsNullOrEmpty(zid_temp)) { zid_temp = IDChange.ChangeZIDFromWS2ZID(data.Rows[index]["ZID"].ToString()); } return(zid_temp); }
//protected virtual string InsertSql(string pch, DataTable data, string tableName) //{ // StringBuilder sbCmdText = new StringBuilder(); // if (data.Columns.Count > 0) // { // IList<string> dbColumns = new List<string>(); // foreach (DataColumn dc in data.Columns) // { // dbColumns.Add(dc.ColumnName); // } // sbCmdText.AppendFormat("INSERT INTO {0}(", tableName); // sbCmdText.Append(string.Join(",", dbColumns)); // sbCmdText.Append(",PCH,SPFHID,LPBH) VALUES ("); // sbCmdText.Append(":" + string.Join(",:", dbColumns)); // sbCmdText.AppendFormat(",'{0}',:SPFHID,:LPBH)", pch); // } // return sbCmdText.ToString(); //} private string GetHidTemp(DataTable data, int index) { if (string.IsNullOrEmpty(hid_temp)) { hid_temp = IDChange.ChangeHIDFromWS2HID(data.Rows[index]["HID"].ToString()); } return(hid_temp); }