public void insertWLLB(string typeSN, string typeName, string typeType, string typeMem) { //string str = "SELECT MAX(typeID) FROM MSType"; string s1 = "SELECT SYSINT FROM HG_SYSINS where SYSNAME = 'MSType'"; DataTable dt = DBHelper.GetDataSet(CommandType.Text, s1); int s = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1; IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "INSERT INTO MSType(typeID,typeSN,typeName,typeType,typeMem,isDelete) VALUES(@typeID,@typeSN,@typeName,@typeType,@typeMem,'0')"; Parameter[] paras = { new Parameter("@typeID", s.ToString()), new Parameter("@typeSN", typeSN), new Parameter("@typeName", typeName), new Parameter("@typeType", typeType), new Parameter("@typeMem", typeMem) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); string sql1 = "UPDATE HG_SYSINS SET SYSINT=@SYSINT WHERE upper(SYSNAME)='MSType'"; Parameter[] paras1 = { new Parameter("@SYSINT", s.ToString()) }; objDAL.ExecuteNonQuery(CommandType.Text, sql1, paras1); objDAL.Close(); }
public void INSERT_CRM_ZDADD(string ADDNAME, string ADDMEMO) { string sql1 = "SELECT SYSINT FROM HG_SYSINS where SYSNAME = 'CRM_ZDADD'"; DataTable dt = DBHelper.GetDataSet(CommandType.Text, sql1); int s = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1; IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "INSERT INTO CRM_ZDADD(ADDID,ADDNAME,ADDMEMO) VALUES (@ADDID,@ADDNAME,@ADDMEMO)"; Parameter[] paras = { new Parameter("@ADDID", s.ToString()), new Parameter("@ADDNAME", ADDNAME), new Parameter("@ADDMEMO", ADDMEMO) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); string sql2 = "UPDATE HG_SYSINS SET SYSINT=@SYSINT WHERE upper(SYSNAME)='CRM_ZDADD'"; Parameter[] paras1 = { new Parameter("@SYSINT", s.ToString()) }; objDAL.ExecuteNonQuery(CommandType.Text, sql2, paras1); objDAL.Close(); }
public void insertCKDMX(string ChuKDID, string materialID, string mtNumber, string mtUnit, string mtPrice, string mtTotal, string PlaceID, string MXMemo, string mtBuyPrice, string mtBuyTotal) { string str = "SELECT SYSINT FROM HG_SYSINS where SYSNAME = 'MSChuKMX'"; DataTable dt = DBHelper.GetDataSet(CommandType.Text, str); IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = " insert into MSChuKMX(ChuKMXID,ChuKDID,materialID,mtNumber,mtUnit ,mtPrice,mtTotal,PlaceID,MXMemo,mtBuyPrice,mtBuyTotal) values (@ChuKMXID,@ChuKDID,@materialID,@mtNumber,@mtUnit, @mtPrice,@mtTotal,@PlaceID,@MXMemo,@mtBuyPrice,@mtBuyTotal)"; Parameter[] paras = { new Parameter("@ChuKMXID", (Convert.ToInt32(dt.Rows[0][0].ToString()) + 1).ToString()), new Parameter("@ChuKDID", ChuKDID), new Parameter("@materialID", materialID), new Parameter("@mtNumber", mtNumber), new Parameter("@mtUnit", mtUnit), new Parameter("@mtPrice", mtPrice), new Parameter("@mtTotal", mtTotal), new Parameter("@PlaceID", PlaceID), new Parameter("@MXMemo", MXMemo), new Parameter("@mtBuyPrice", mtBuyPrice), new Parameter("@mtBuyTotal", mtBuyTotal) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); string sql1 = "UPDATE HG_SYSINS SET SYSINT=@SYSINT WHERE upper(SYSNAME)='MSChuKMX'"; Parameter[] paras1 = { new Parameter("@SYSINT", (Convert.ToInt32(dt.Rows[0][0].ToString()) + 1).ToString()), }; objDAL.ExecuteNonQuery(CommandType.Text, sql1, paras1); objDAL.Close(); }
public void insertCRM_ZDXM(string ZDXMID, string ZDID, string ZDVER, string XMTPYEID, string XMTYPE, string XMDATE, string XMTIME, string XMADD, string XMNUM, string ISCONFIG, string ISDELETE, string ISEND, string XMMEMO) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "insert into CRM_ZDXM(ZDXMID,ZDID,ZDVER,XMTPYEID,XMTYPE,XMDATE,XMTIME,XMADD,XMNUM,ISCONFIG,ISDELETE,ISEND,XMMEMO) values (@ZDXMID,@ZDID,@ZDVER,@XMTPYEID,@XMTYPE,@XMDATE,@XMTIME,@XMADD,@XMNUM,@ISCONFIG,@ISDELETE,@ISEND,@XMMEMO)"; Parameter[] paras = { new Parameter("@ZDXMID", ZDXMID), new Parameter("@ZDID", ZDID), new Parameter("@ZDVER", ZDVER), new Parameter("@XMTPYEID", XMTPYEID), new Parameter("@XMTYPE", XMTYPE), new Parameter("@XMDATE", XMDATE), new Parameter("@XMTIME", XMTIME), new Parameter("@XMADD", XMADD), new Parameter("@XMNUM", XMNUM), new Parameter("@ISCONFIG", ISCONFIG), new Parameter("@ISDELETE", ISDELETE), new Parameter("@ISEND", ISEND), new Parameter("@XMMEMO", XMMEMO) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void insertCRM_ZD(string ZDID, string ZDVER, string ZDSTATUS, string ISACTIVE, string ISUPDATE, string DEPTNAME, string STAFFNAME, string STAFFMOBLE, string fillID, string fillName, string fillTime, string ZDMEMO) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "insert into CRM_ZD(ZDID,ZDVER,ZDSTATUS,ISACTIVE,ISUPDATE,DEPTNAME,STAFFNAME,STAFFMOBLE,fillID,fillName,fillTime,ZDMEMO) values (@ZDID,@ZDVER,@ZDSTATUS,@ISACTIVE,@ISUPDATE,@DEPTNAME,@STAFFNAME,@STAFFMOBLE,@fillID,@fillName,@fillTime,@ZDMEMO)"; Parameter[] paras = { new Parameter("@ZDID", ZDID), new Parameter("@ZDVER", ZDVER), new Parameter("@ZDSTATUS", ZDSTATUS), new Parameter("@ISACTIVE", ISACTIVE), new Parameter("@ISUPDATE", ISUPDATE), new Parameter("@DEPTNAME", DEPTNAME), new Parameter("@STAFFNAME", STAFFNAME), new Parameter("@STAFFMOBLE", STAFFMOBLE), new Parameter("@fillID", fillID), new Parameter("@fillName", fillName), new Parameter("@fillTime", fillTime), new Parameter("@ZDMEMO", ZDMEMO) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATE_MSCLIENT(string ClSN, string ClName, string ClMan, string ClAddress, string ClPost, string ClTel, string ClFax, string ClEMail, string ClMemo, string isBuy, string isSale, string CBANK, string CBANKNO, string ClientID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE MSClient SET ClSN=@ClSN,ClName=@ClName,ClMan=@ClMan,ClAddress=@ClAddress,ClPost=@ClPost,ClTel=@ClTel,ClFax=@ClFax,ClEMail=@ClEMail,ClMemo=@ClMemo,isBuy=@isBuy,isSale=@isSale,CBANK=@CBANK,CBANKNO=@CBANKNO where ClientID=@ClientID"; Parameter[] paras = { new Parameter("@ClientID", ClientID), new Parameter("@ClSN", ClSN), new Parameter("@ClName", ClName), new Parameter("@ClMan", ClMan), new Parameter("@ClAddress", ClAddress), new Parameter("@ClPost", ClPost), new Parameter("@ClTel", ClTel), new Parameter("@ClFax", ClFax), new Parameter("@ClEMail", ClEMail), new Parameter("@ClMemo", ClMemo), new Parameter("@isBuy", isBuy), new Parameter("@isSale", isSale), new Parameter("@CBANK", CBANK), new Parameter("@CBANKNO", CBANKNO) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void INSERT_CRM_ZDLXR(string LXR, string LXDH, string LXDES) { string sql1 = "SELECT SYSINT FROM HG_SYSINS where SYSNAME = 'CRM_ZDLXR'"; DataTable dt = DBHelper.GetDataSet(CommandType.Text, sql1); int s = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1; IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "INSERT INTO CRM_ZDLXR(LXRID,LXR,LXDH,LXDES) VALUES (@LXRID,@LXR,@LXDH,@LXDES)"; Parameter[] paras = { new Parameter("@LXRID", s.ToString()), new Parameter("@LXR", LXR), new Parameter("@LXDH", LXDH), new Parameter("@LXDES", LXDES) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); string sql2 = "UPDATE HG_SYSINS SET SYSINT=@SYSINT WHERE upper(SYSNAME)='CRM_ZDLXR'"; Parameter[] paras1 = { new Parameter("@SYSINT", s.ToString()) }; objDAL.ExecuteNonQuery(CommandType.Text, sql2, paras1); objDAL.Close(); }
public void INSERT_FK_FKINFO(MODLEFKINFO modleFKINFO) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "insert into FK_FKINFO(FKNO,TM,FKNAME,FKSEX,FKMZ,FKCSRQ,FKZJLXRI,FKZJLX,FKZJHM,FKADD,FKDW,FKCPH,FKZH,FKZLX,FKZLXRI,XDH,FXH,SFBM,SFNAME,SFGH,SFRYDH,FKLFSY,FKLFSYMX,FKSUM,FKISHAVESSWP,FKSSWP,JRMWRI,JRMW,LFTIME,ISLK,GSDMRI,GSDM,GSDMMS,JRDJR,JRDJRRI,ISDELETE,FRI,BZ,LFRQ)"; sql = sql + " values(@FKNO,@TM,@FKNAME,@FKSEX,@FKMZ,@FKCSRQ,@FKZJLXRI,@FKZJLX,@FKZJHM,@FKADD,@FKDW,@FKCPH,@FKZH,@FKZLX,@FKZLXRI,@XDH,@FXH,@SFBM,@SFNAME,@SFGH,@SFRYDH,@FKLFSY,@FKLFSYMX,@FKSUM,@FKISHAVESSWP,@FKSSWP,@JRMWRI,@JRMW,GETDATE(),@ISLK,@GSDMRI,@GSDM,@GSDMMS,@JRDJR,@JRDJRRI,@ISDELETE,@FRI,@BZ,CONVERT(varchar(100), GETDATE(), 23))"; Parameter[] paras = { new Parameter("@FKNO", modleFKINFO.FKNO), new Parameter("@TM", modleFKINFO.TM), new Parameter("@FKNAME", modleFKINFO.FKNAME), new Parameter("@FKSEX", modleFKINFO.FKSEX), new Parameter("@FKMZ", modleFKINFO.FKMZ), new Parameter("@FKCSRQ", modleFKINFO.FKCSRQ), new Parameter("@FKZJLXRI", modleFKINFO.FKZJLXRI), new Parameter("@FKZJLX", modleFKINFO.FKZJLX), new Parameter("@FKZJHM", modleFKINFO.FKZJHM), new Parameter("@FKADD", modleFKINFO.FKADD), new Parameter("@FKDW", modleFKINFO.FKDW), new Parameter("@FKCPH", modleFKINFO.FKCPH), new Parameter("@FKZH", modleFKINFO.FKZH), new Parameter("@FKZLX", modleFKINFO.FKZLX), new Parameter("@FKZLXRI", modleFKINFO.FKZLXRI), new Parameter("@XDH", modleFKINFO.XDH), new Parameter("@FXH", modleFKINFO.FXH), new Parameter("@SFBM", modleFKINFO.SFBM), new Parameter("@SFNAME", modleFKINFO.SFNAME), new Parameter("@SFGH", modleFKINFO.SFGH), new Parameter("@SFRYDH", modleFKINFO.SFRYDH), new Parameter("@FKLFSY", modleFKINFO.FKLFSY), new Parameter("@FKLFSYMX", modleFKINFO.FKLFSYMX), new Parameter("@FKSUM", modleFKINFO.FKSUM), new Parameter("@FKISHAVESSWP", modleFKINFO.FKISHAVESSWP), new Parameter("@FKSSWP", modleFKINFO.FKSSWP), new Parameter("@JRMWRI", modleFKINFO.JRMWRI), new Parameter("@JRMW", modleFKINFO.JRMW), new Parameter("@LFTIME", modleFKINFO.LFTIME), new Parameter("@ISLK", modleFKINFO.ISLK), new Parameter("@GSDMRI", modleFKINFO.GSDMRI), new Parameter("@GSDM", modleFKINFO.GSDM), new Parameter("@GSDMMS", modleFKINFO.GSDMMS), new Parameter("@JRDJR", modleFKINFO.JRDJR), new Parameter("@JRDJRRI", modleFKINFO.JRDJRRI), new Parameter("@ISDELETE", modleFKINFO.ISDELETE), new Parameter("@FRI", modleFKINFO.FRI), new Parameter("@BZ", modleFKINFO.BZ), new Parameter("@LFRQ", modleFKINFO.LFRQ) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_FK_LXRINFO() { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "delete from FK_LXRINFO"; Parameter[] paras = { }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_CRM_ZDRIGHT(string STAFFID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "delete from CRM_ZDRIGHT where STAFFID=@STAFFID"; Parameter[] paras = { new Parameter("@STAFFID", STAFFID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_CRM_ZD(string ZDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "DELETE FROM CRM_ZD WHERE ZDID=@ZDID"; Parameter[] paras = { new Parameter("@ZDID", ZDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATE_CaiGFP_HDTH(string CaiGFPID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update CaiGFP set nStatus='2',PayID='-1',isPay='0',isRePay='0',RePayID='-1',RePayTime=getdate() where CaiGFPID=@CaiGFPID"; Parameter[] paras = { new Parameter("@CaiGFPID", CaiGFPID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATE_CaiGFP(string CaiGFPID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE CaiGFP SET nStatus='1' WHERE CaiGFPID=@CaiGFPID"; Parameter[] paras = { new Parameter("@CaiGFPID", CaiGFPID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_MSDayUse(string DayUseID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "DELETE FROM MSDayUse WHERE DayUseID=@DayUseID"; Parameter[] paras = { new Parameter("@DayUseID", DayUseID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETECK(string StockID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE MSStock SET isDelete='1' WHERE StockID=@StockID"; Parameter[] paras = { new Parameter("@StockID", StockID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_MSCLIENT(string ClientID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE MSClient SET isDelete=1 WHERE ClientID=@ClientID"; Parameter[] paras = { new Parameter("@ClientID", ClientID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETEWL(string materialID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE MSMaterial SET isDelete='1' WHERE materialID=@materialID"; Parameter[] paras = { new Parameter("@materialID", materialID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETECKD(string ChuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "DELETE FROM MSChuKD WHERE ChuKDID=@ChuKDID"; Parameter[] paras = { new Parameter("@ChuKDID", ChuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_FK_FKINFO(string RI) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update FK_FKINFO set ISDELETE=1 where RI=@RI"; Parameter[] paras = { new Parameter("@RI", RI) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATEMSMaterial(string ChuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE MSMaterial SET mtSalePrice=MSChuKMX.mtPrice FROM MSChuKMX WHERE MSMaterial.materialID = MSChuKMX.materialID AND MSChuKMX.ChuKDID = @ChuKDID"; Parameter[] paras = { new Parameter("@ChuKDID", ChuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATEMSRuKD(string RuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update MSRuKD set RuKTotal=(select sum(mtTotal) from MSRuKMX where RuKDID=@RuKDID) where RuKDID=@RuKDID"; Parameter[] paras = { new Parameter("@RuKDID", RuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETERKDMX(string RuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "DELETE FROM MSRuKMX WHERE RuKDID=@RuKDID"; Parameter[] paras = { new Parameter("@RuKDID", RuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void DELETE_CRM_ZDADD(string ADDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "DELETE from CRM_ZDADD where ADDID=@ADDID"; Parameter[] paras = { new Parameter("@ADDID", ADDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void INSERT_CRM_ZDRIGHT(string STAFFID, string XMTPYEID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "INSERT INTO CRM_ZDRIGHT(STAFFID,XMTPYEID) VALUES (@STAFFID,@XMTPYEID)"; Parameter[] paras = { new Parameter("@STAFFID", STAFFID), new Parameter("@XMTPYEID", XMTPYEID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void Insert_FK_IMAGE(string FKRI, byte[] FKIMAGE) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "insert into FK_IMAGE (FKRI,FKIMAGE) values(@FKRI,@FKIMAGE)"; Parameter[] paras = { new Parameter("@FKRI", FKRI), new Parameter("@FKIMAGE", FKIMAGE) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void INSERTFaPRuKD(string CaiGFPID, string RuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "insert into FaPRuKD(CaiGFPID,RuKDID) values(@CaiGFPID,@RuKDID)"; Parameter[] paras = { new Parameter("@CaiGFPID", CaiGFPID), new Parameter("@RuKDID", RuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATETJTH(string nStatus, string ChuKDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update MSChuKD set nStatus=@nStatus where ChuKDID=@ChuKDID"; Parameter[] paras = { new Parameter("@nStatus", nStatus), new Parameter("@ChuKDID", ChuKDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATE_CaiGFPYZ_RKBD(string RKBD, string RI) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "UPDATE CaiGFPYZ SET RKBD = RKBD +' '+@RKBD WHERE RI = @RI"; Parameter[] paras = { new Parameter("@RKBD", RKBD), new Parameter("@RI", RI) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATEMSStock(string RuKNO, string StockID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update MSStock set RuKNO=@RuKNO where StockID=@StockID"; Parameter[] paras = { new Parameter("@RuKNO", RuKNO), new Parameter("@StockID", StockID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }
public void UPDATE_CRM_ZD(string ZDSTATUS, string ZDID) { IDAL objDAL = DALFactory.GetDBO(); objDAL.Open(); string sql = "update CRM_ZD set ZDSTATUS=@ZDSTATUS WHERE ZDID=@ZDID"; Parameter[] paras = { new Parameter("@ZDSTATUS", ZDSTATUS), new Parameter("@ZDID", ZDID) }; objDAL.ExecuteNonQuery(CommandType.Text, sql, paras); objDAL.Close(); }