public DataTable GetStockbyMinmax(string s1, string s2, string s3) { try { DataTable dtResult; string sql = string.Empty; SQLiteParam param = new SQLiteParam(3) { CommandText = StoreProcedure.Instance.GetScript("GetStockByMinMax_Status") }; param.ParamStringFixedLength(0, "@strS1", s1); param.ParamStringFixedLength(1, "@strS2", s2); param.ParamStringFixedLength(2, "@strS3", s3); dtResult = GlobalSqliteDB.Instance.DataAc.GetDataTable(param); return(dtResult); } catch (Exception ex) { throw ex; } }
public string UpdateProgramGroup(ProgramGroup procGroup, int userid) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(7) { CommandText = StoreProcedure.Instance.GetScript("ProgramGroupUpdate") }; param.ParamStringFixedLength(0, "@PROG_TYPE_NAME", procGroup.PROG_TYPE_NAME); param.ParamInt32(1, "@ORDER_BY", procGroup.ORDER_BY); param.ParamStringFixedLength(2, "@ICON", procGroup.ICON); param.ParamStringFixedLength(3, "@DESCRIPTION", procGroup.DESCRIPTION); param.ParamStringFixedLength(4, "@PROG_TYPE_RESOURCE", procGroup.PROG_TYPE_RESOURCE); param.ParamStringFixedLength(5, "@IS_ACTIVE", (procGroup.IS_ACTIVE ? "Y" : "N")); param.ParamInt32(6, "@PROG_TYPE_ID", procGroup.PROG_TYPE_ID); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public void InsertStockByMinMax(List <StockByMinMax> lstStockByMinMax, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_MINMAX"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByMinMax SQLiteInsert in lstStockByMinMax) { param = new SQLiteParam(20) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByMinMax") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_SEQ_NO", SQLiteInsert.PRODUCT_SEQ_NO); param.ParamStringFixedLength(5, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamStringFixedLength(6, "@PRODUCT_TYPE_ID", SQLiteInsert.PRODUCT_TYPE_ID); param.ParamStringFixedLength(7, "@PRODUCT_TYPE_NAME", SQLiteInsert.PRODUCT_TYPE_NAME); param.ParamInt32(8, "@BOX_QTY", SQLiteInsert.BOX_QTY); param.ParamInt32(9, "@STOCK_PCS", SQLiteInsert.STOCK_PCS); param.ParamInt32(10, "@STOCK_BOX", SQLiteInsert.STOCK_BOX); param.ParamStringFixedLength(11, "@STATUS_RUNNING_MC", SQLiteInsert.STATUS_RUNNING_MC); param.ParamInt32(12, "@PICK_PENDING", SQLiteInsert.PICK_PENDING); param.ParamInt32(13, "@EXPECTED_DELAY", SQLiteInsert.EXPECTED_DELAY); param.ParamInt32(14, "@FORECAST", SQLiteInsert.FORECAST); param.ParamInt32(15, "@MIN_BOX", SQLiteInsert.MIN_BOX); param.ParamInt32(16, "@MAX_BOX", SQLiteInsert.MAX_BOX); param.ParamStringFixedLength(17, "@STATUS", SQLiteInsert.STATUS); param.ParamInt32(18, "@FLAG", flag); param.ParamDateTime(19, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public int UserInsert(string empid, string empname, string userlogin, string password, string remark) { try { string sql = "INSERT INTO M_USER (EMPLOYEE_ID, EMPLOYEE_NAME, USER_LOGIN, USER_PASS, USER_REMARK) " + "VALUES (@EMPLOYEE_ID, @EMPLOYEE_NAME, @USER_LOGIN, @USER_PASS, @USER_REMARK);"; SQLiteParam param = new SQLiteParam(5) { CommandText = sql }; param.ParamStringFixedLength(0, "@EMPLOYEE_ID", empid); param.ParamStringFixedLength(1, "@EMPLOYEE_NAME", empname); param.ParamStringFixedLength(2, "@USER_LOGIN", userlogin); param.ParamStringFixedLength(3, "@USER_PASS", password); param.ParamStringFixedLength(4, "@USER_REMARK", remark); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); return(rowAfect); } catch (Exception ex) { throw ex; } }
public string UserChangePassword(string newPass, int userid) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(2) { CommandText = StoreProcedure.Instance.GetScript("UserChangePassword") }; param.ParamStringFixedLength(0, "@USER_PASS", newPass); param.ParamInt32(1, "@USER_ID", userid); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public void InsertStockByCustomer(List <StockByCustomer> lstStockByCustomer, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_CUSTOMER"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByCustomer SQLiteInsert in lstStockByCustomer) { param = new SQLiteParam(12) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByCustomer") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamStringFixedLength(5, "@PRODUCT_TYPE_ID", SQLiteInsert.PRODUCT_TYPE_ID); param.ParamStringFixedLength(6, "@PRODUCT_TYPE_NAME", SQLiteInsert.PRODUCT_TYPE_NAME); param.ParamInt32(7, "@BOX_QTY", SQLiteInsert.BOX_QTY); param.ParamInt32(8, "@QTY", SQLiteInsert.QTY); param.ParamInt32(9, "@NO_OF_BOX", SQLiteInsert.NO_OF_BOX); param.ParamInt32(10, "@FLAG", flag); param.ParamDateTime(11, "@lastupdate", lastupdate); //if (stkUpload.N_USER_DATE.HasValue) // param.ParamDate(9, "@N_USER_DATE", stkUpload.N_USER_DATE.Value); //else // param.ParamNull(9, "@N_USER_DATE"); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public void InsertDeliveryBoardDetail(List <DeliveryBoardDetail> lstDeliveryBoardDetail, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM DELIVERY_DETAIL"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (DeliveryBoardDetail SQLiteInsert in lstDeliveryBoardDetail) { param = new SQLiteParam(16) { CommandText = StoreProcedure.Instance.GetScript("InsertDeliveryBoardDetail") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@WH_ID", SQLiteInsert.WH_ID); param.ParamDateTime(2, "@ETD_DATE", SQLiteInsert.ETD_DATE); param.ParamStringFixedLength(3, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(4, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamInt32(5, "@QTY", SQLiteInsert.QTY); param.ParamStringFixedLength(6, "@UNIT", SQLiteInsert.UNIT); param.ParamInt32(7, "@NO_OF_BOX", SQLiteInsert.NO_OF_BOX); param.ParamInt32(8, "@FREE_STOCK", SQLiteInsert.FREE_STOCK); param.ParamInt32(9, "@ASSIGN_QTY", SQLiteInsert.ASSIGN_QTY); param.ParamInt32(10, "@PICKED_QTY", SQLiteInsert.PICKED_QTY); param.ParamInt32(11, "@LOADED_QTY", SQLiteInsert.LOADED_QTY); param.ParamStringFixedLength(12, "@STATUS", SQLiteInsert.STATUS); param.ParamStringFixedLength(13, "@REMARK", SQLiteInsert.REMARK); param.ParamInt32(14, "@FLAG", flag); param.ParamDateTime(15, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public string UpdateUser(User user) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(7) { CommandText = StoreProcedure.Instance.GetScript("UserUpdate") }; param.ParamStringFixedLength(0, "@EMPLOYEE_ID", user.EMPLOYEE_ID); param.ParamStringFixedLength(1, "@EMPLOYEE_NAME", user.EMPLOYEE_NAME); param.ParamStringFixedLength(2, "@USER_LOGIN", user.USER_LOGIN); param.ParamStringFixedLength(3, "@USER_PASS", user.USER_PASS); param.ParamStringFixedLength(4, "@USER_REMARK", user.USER_REMARK); param.ParamStringFixedLength(5, "@IS_ACTIVE", (user.IS_ACTIVE ? "Y" : "N")); param.ParamInt32(6, "@USER_ID", user.USER_ID); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public string InsertProgramGroup(ref ProgramGroup procGroup) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(6) { CommandText = StoreProcedure.Instance.GetScript("ProgramGroupInsert") }; param.ParamStringFixedLength(0, "@PROG_TYPE_NAME", procGroup.PROG_TYPE_NAME); param.ParamInt32(1, "@ORDER_BY", procGroup.ORDER_BY); param.ParamStringFixedLength(2, "@ICON", procGroup.ICON); param.ParamStringFixedLength(3, "@DESCRIPTION", procGroup.DESCRIPTION); param.ParamStringFixedLength(4, "@PROG_TYPE_RESOURCE", procGroup.PROG_TYPE_RESOURCE); param.ParamStringFixedLength(5, "@IS_ACTIVE", (procGroup.IS_ACTIVE ? "Y" : "N")); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); object resultid = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT SEQ FROM sqlite_sequence WHERE NAME = 'M_PROGRAM_TYPE'"); if (resultid != null) { procGroup.PROG_TYPE_ID = Convert.ToInt32(resultid); } result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public DataTable GetDeliveryDTL(string party, DateTime date, string wh, string status) { try { SQLiteParam param; if (status.ToLower() == "delay") { param = new SQLiteParam(3) { CommandText = StoreProcedure.Instance.GetScript("GetDeliveryBoardDetail_Delay") }; param.ParamStringFixedLength(0, "@strWH_ID", wh); param.ParamStringFixedLength(1, "@strPARTY_ID", party); param.ParamDateTime(2, "@strETD_DATE", date); } else { param = new SQLiteParam(3) { CommandText = StoreProcedure.Instance.GetScript("GetDeliveryBoardDetail") }; param.ParamStringFixedLength(0, "@strWH_ID", wh); param.ParamStringFixedLength(1, "@strPARTY_ID", party); param.ParamDateTime(2, "@strETD_DATE", date); } DataTable dtResult = GlobalSqliteDB.Instance.DataAc.GetDataTable(param); return(dtResult); } catch (Exception ex) { throw ex; } }
public void InsertDeliveryBoard(List <DeliveryBoard> lstDeliveryBoard, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM DELIVERY_BOARD"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (DeliveryBoard SQLiteInsert in lstDeliveryBoard) { param = new SQLiteParam(9) { CommandText = StoreProcedure.Instance.GetScript("InsertDeliveryBoard") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); param.ParamStringFixedLength(2, "@WH_ID", SQLiteInsert.WH_ID); param.ParamDateTime(3, "@ETD_DATE", SQLiteInsert.ETD_DATE); param.ParamStringFixedLength(4, "@ETD_TIME", SQLiteInsert.ETD_TIME); param.ParamStringFixedLength(5, "@STATUS", SQLiteInsert.STATUS); param.ParamStringFixedLength(6, "@RESPONSIBLE", SQLiteInsert.RESPONSIBLE); param.ParamInt32(7, "@FLAG", flag); param.ParamDateTime(8, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public string InsertProgram(ref M_Program proc) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(8) { CommandText = StoreProcedure.Instance.GetScript("ProgramInsert") }; param.ParamStringFixedLength(0, "@PROG_NAME", proc.PROG_NAME); param.ParamStringFixedLength(1, "@PROG_KEY", proc.PROG_KEY); param.ParamInt32(2, "@PROG_TYPE_ID", proc.PROG_GROUP.PROG_TYPE_ID); if (proc.ORDER_BY.HasValue) { param.ParamInt32(3, "@ORDER_BY", proc.ORDER_BY.Value); } else { param.ParamNull(3, "@ORDER_BY"); } param.ParamStringFixedLength(4, "@ICON", proc.ICON); param.ParamStringFixedLength(5, "@DESCRIPTION", proc.DESCRIPTION); param.ParamStringFixedLength(6, "@PROG_RESOURCE", proc.PROG_RESOURCE); param.ParamStringFixedLength(7, "@IS_ACTIVE", (proc.IS_ACTIVE ? "Y" : "N")); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); object resultid = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT SEQ FROM sqlite_sequence WHERE NAME = 'M_PROGRAM'"); if (resultid != null) { proc.PROG_ID = Convert.ToInt32(resultid); } result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public void UpdateDeliveryBoardDetail() { try { SQLiteParam param = new SQLiteParam(1) { CommandText = StoreProcedure.Instance.GetScript("UpdateDeliveryBoardDetail") }; param.ParamStringFixedLength(0, "@FLAG", "1"); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public string UpdateProgram(M_Program proc) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(9) { CommandText = StoreProcedure.Instance.GetScript("ProgramUpdate") }; param.ParamStringFixedLength(0, "@PROG_NAME", proc.PROG_NAME); param.ParamStringFixedLength(1, "@PROG_KEY", proc.PROG_KEY); param.ParamInt32(2, "@PROG_TYPE_ID", proc.PROG_GROUP.PROG_TYPE_ID); if (proc.ORDER_BY.HasValue) { param.ParamInt32(3, "@ORDER_BY", proc.ORDER_BY.Value); } else { param.ParamNull(3, "@ORDER_BY"); } param.ParamStringFixedLength(4, "@ICON", proc.ICON); param.ParamStringFixedLength(5, "@DESCRIPTION", proc.DESCRIPTION); param.ParamStringFixedLength(6, "@PROG_RESOURCE", proc.PROG_RESOURCE); param.ParamStringFixedLength(7, "@IS_ACTIVE", (proc.IS_ACTIVE ? "Y" : "N")); param.ParamInt32(8, "@PROG_ID", proc.PROG_ID); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public string InsertUser(ref User user) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(6) { CommandText = StoreProcedure.Instance.GetScript("UserInsert") }; param.ParamStringFixedLength(0, "@EMPLOYEE_ID", user.EMPLOYEE_ID); param.ParamStringFixedLength(1, "@EMPLOYEE_NAME", user.EMPLOYEE_NAME); param.ParamStringFixedLength(2, "@USER_LOGIN", user.USER_LOGIN); param.ParamStringFixedLength(3, "@USER_PASS", user.USER_PASS); param.ParamStringFixedLength(4, "@USER_REMARK", user.USER_REMARK); param.ParamStringFixedLength(5, "@IS_ACTIVE", (user.IS_ACTIVE ? "Y" : "N")); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); if (GlobalSqliteDB.Instance.DataAc.LastException != null) { throw GlobalSqliteDB.Instance.DataAc.LastException; } object resultid = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT SEQ FROM sqlite_sequence WHERE NAME = 'M_USER'"); if (resultid != null) { user.USER_ID = Convert.ToInt32(resultid); } result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public void InsertStockByMachine(List <StockByMachine> lstStockByMachine, DateTime lastupdate) { int flag = 0; try { object result = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT IFNULL(MIN(FLAG), 1) + 1 FROM STOCK_BY_MACHINE"); flag = Convert.ToInt32(result, NumberFormatInfo.CurrentInfo); List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (StockByMachine SQLiteInsert in lstStockByMachine) { param = new SQLiteParam(18) { CommandText = StoreProcedure.Instance.GetScript("InsertStockByMachine") }; param.ParamStringFixedLength(0, "@PARTY_ID", SQLiteInsert.PARTY_ID); param.ParamStringFixedLength(1, "@PARTY_NAME", SQLiteInsert.PARTY_NAME); if (SQLiteInsert.START_DATE.HasValue) { param.ParamDateTime(2, "@START_DATE", SQLiteInsert.START_DATE.Value); } else { param.ParamNull(2, "@START_DATE"); } if (SQLiteInsert.END_DATE.HasValue) { param.ParamDateTime(3, "@END_DATE", SQLiteInsert.END_DATE.Value); } else { param.ParamNull(3, "@END_DATE"); } param.ParamStringFixedLength(4, "@STATUS", SQLiteInsert.STATUS); param.ParamInt32(5, "@PLAN_QTY", SQLiteInsert.PLAN_QTY); param.ParamStringFixedLength(6, "@PRODUCT_TYPE", SQLiteInsert.PRODUCT_TYPE); param.ParamStringFixedLength(7, "@PROD_TYPE_S", SQLiteInsert.PROD_TYPE_S); param.ParamStringFixedLength(8, "@PRODUCT_NO", SQLiteInsert.PRODUCT_NO); param.ParamStringFixedLength(9, "@PRODUCT_NAME", SQLiteInsert.PRODUCT_NAME); param.ParamInt32(10, "@STOCK_PCS", SQLiteInsert.STOCK_PCS); param.ParamInt32(11, "@STOCK_BOX", SQLiteInsert.STOCK_BOX); param.ParamStringFixedLength(12, "@MC_NO", SQLiteInsert.MC_NO); param.ParamStringFixedLength(13, "@MACHINE_NAME", SQLiteInsert.MACHINE_NAME); param.ParamInt32(14, "@MIN_BOX", SQLiteInsert.MIN_BOX); param.ParamInt32(15, "@MAX_BOX", SQLiteInsert.MAX_BOX); param.ParamInt32(16, "@FLAG", flag); param.ParamDateTime(17, "@lastupdate", lastupdate); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); if (GlobalSqliteDB.Instance.LastException != null) { throw GlobalSqliteDB.Instance.LastException; } } catch (Exception ex) { throw ex; } }
public void UpdateUserProgram(List <UserProgram> lstUserProg, int userid) { try { List <SQLiteParam> lstParam = new List <SQLiteParam>(); SQLiteParam param = null; foreach (UserProgram userProg in lstUserProg) { param = new SQLiteParam(12) { CommandText = StoreProcedure.Instance.GetScript("UserProgramUpdate") }; param.ParamStringFixedLength(0, "@IS_ACCESS", (userProg.IS_ACCESS ? "Y" : "N")); param.ParamStringFixedLength(1, "@IS_INSERT", (userProg.IS_INSERT ? "Y" : "N")); param.ParamStringFixedLength(2, "@IS_UPDATE", (userProg.IS_UPDATE ? "Y" : "N")); param.ParamStringFixedLength(3, "@IS_DELETE", (userProg.IS_DELETE ? "Y" : "N")); param.ParamStringFixedLength(4, "@IS_PRINT", (userProg.IS_PRINT ? "Y" : "N")); param.ParamStringFixedLength(5, "@CUSTOM1", userProg.CUSTOM1); param.ParamStringFixedLength(6, "@IS_CUSTOM1", (userProg.IS_CUSTOM1 ? "Y" : "N")); param.ParamStringFixedLength(7, "@CUSTOM2", userProg.CUSTOM2); param.ParamStringFixedLength(8, "@IS_CUSTOM2", (userProg.IS_CUSTOM2 ? "Y" : "N")); param.ParamStringFixedLength(9, "@CUSTOM3", userProg.CUSTOM3); param.ParamStringFixedLength(10, "@IS_CUSTOM3", (userProg.IS_CUSTOM3 ? "Y" : "N")); param.ParamInt32(11, "@USER_PROG_ID", userProg.USER_PROG_ID); lstParam.Add(param); } if (lstParam.Count <= 0) { return; } int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(lstParam); } catch (Exception ex) { throw ex; } }