/// <summary>delete import history /// /// </summary> private void DeleteBy_DeleteCheck() { if (DSP_MSG("Q102", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")) { tmie = new T_MakerInport_Entity(); InportSEQ = string.Empty; foreach (DataGridViewRow row in dgvImportRireki.Rows) { if (Convert.ToBoolean(row.Cells["chk3"].Value) == true) { if (InportSEQ != string.Empty) { InportSEQ += ","; } InportSEQ += row.Cells["colInportSEQ"].Value.ToString(); } } tmie.InportSEQ = InportSEQ; tmie.InsertOperator = loginInfo.OperatorCode; tmie.InsertDateTime = System.DateTime.Now.ToString(); psks0103ibl.PSKS0103I_DELETE(tmie); InportRireki_Select(); } }
public bool PSKS0103I_DELETE(T_MakerInport_Entity tmie) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@InportSEQ", tmie.InportSEQ); dic.Add("@InsertOperator", tmie.InsertOperator); dic.Add("@InsertDateTime", tmie.InsertDateTime); return(InsertUpdateDeleteData(dic, "PSKS0103I_DELETE")); }
public bool ImportProcess(T_MakerInport_Entity tmie, string insertDateTime) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@DataSourseMakerCD", tmie.DataSourseMakerCD); dic.Add("@InportFile", tmie.InportFile); dic.Add("@PatternCD", tmie.PatternCD); dic.Add("@InsertOperator", tmie.InsertOperator); dic.Add("@InsertDateTime", insertDateTime); dic.Add("@XML", tmie.xml); return(InsertUpdateDeleteData(dic, "PSKS01013I_ImportProcess")); }
public bool PSKS0103I_DELETE(T_MakerInport_Entity tmie) { return(psks0103idl.PSKS0103I_DELETE(tmie)); }
private bool InportProcesses(T_MakerZaiko_Entity tmze, string patternCD, DataTable dtPattern, string insertDateTime)//取込処理 { try { string noukiFlag = "0"; DataRow[] drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 1"); int colIndex = Convert.ToInt32(drs[0]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "JANCD"; drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 2"); int i = 0; foreach (DataRow dr in drs) { colIndex = Convert.ToInt32(drs[i]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "P" + ++i; } while (i < 5) { DataColumn dc = new DataColumn(); dc.DefaultValue = 0; dc.ColumnName = "P" + ++i; tmze.dt1.Columns.Add(dc); } i = 0; drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 3"); foreach (DataRow dr in drs) { colIndex = Convert.ToInt32(drs[i]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "M" + ++i; } while (i < 5) { DataColumn dc = new DataColumn(); dc.DefaultValue = 0; dc.ColumnName = "M" + ++i; tmze.dt1.Columns.Add(dc); } tmze.dt1.Columns.Add("ZaikoSuTotal"); drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 9 or Convert(ItemProperty, 'System.Int32') = 10"); if (drs.Count() > 0) { colIndex = Convert.ToInt32(drs[0]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "Nouki"; if (drs[0]["Convert(ItemProperty, 'System.Int32')"].ToString().Equals("9")) { noukiFlag = "1"; } } else { tmze.dt1.Columns.Add("Nouki"); } ArrayList arrcol = new ArrayList(); foreach (DataColumn dc in tmze.dt1.Columns) { if (!(dc.ColumnName.Equals("JANCD") || dc.ColumnName.Equals("P1") || dc.ColumnName.Equals("P2") || dc.ColumnName.Equals("P3") || dc.ColumnName.Equals("P4") || dc.ColumnName.Equals("P5") || dc.ColumnName.Equals("M1") || dc.ColumnName.Equals("M2") || dc.ColumnName.Equals("M3") || dc.ColumnName.Equals("M4") || dc.ColumnName.Equals("M5") || dc.ColumnName.Equals("ZaikoSuTotal") || dc.ColumnName.Equals("Nouki"))) { arrcol.Add(dc); } } foreach (DataColumn dc in arrcol) { tmze.dt1.Columns.Remove(dc); } tmze.dt1.AcceptChanges(); tmze.dt1.Columns.Add("HenkanNouki"); tmze.dt1.Columns.Add("ErrorKBN"); tmze.dt1.Columns.Add("ErrorText"); DataColumn dc1 = new DataColumn(); dc1.DefaultValue = 0; dc1.ColumnName = "SEQ"; tmze.dt1.Columns.Add(dc1); tmie = new T_MakerInport_Entity(); tmie.DataSourseMakerCD = tmze.MakerCD; tmie.InportFile = tmze.ImportFileName; tmie.InsertOperator = tmze.InsertOperator; tmie.PatternCD = patternCD; tmie.xml = DataTableToXml(tmze.dt1); return(psks0103idl.Import(tmie, insertDateTime, noukiFlag)); } catch (Exception) { return(false); } }