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();
}
