public virtual int Update(string ID, string EMP_ID, DateTime ORDED_DATE, string CUSTOMER_ID, string ORDER_CR_HR, string STS_ST_CLS, string STS_ST_SER, string SURFACE_CD, decimal ORD_THK, decimal ORD_WTH, string ORD_EDGE, decimal ORD_WGT, decimal BASE_PRICE, decimal EFFECT_PRICE, decimal BIDD_PRICE, string CONTRACT_NO, string ORD_USAGE, string ORD_STAT, string END_USER, int QUANTITY, string DELIVERY_TIME, string REMARK)
{
var sql = "UPDATE ORDERED SET EMP_ID=@EMP_ID, ORDED_DATE=@ORDED_DATE,CUSTOMER_ID=@CUSTOMER_ID,ORDER_CR_HR=@ORDER_CR_HR,STS_ST_CLS=@STS_ST_CLS,STS_ST_SER=@STS_ST_SER,SURFACE_CD=@SURFACE_CD,ORD_THK=@ORD_THK,ORD_WTH=@ORD_WTH,ORD_EDGE=@ORD_EDGE,ORD_WGT=@ORD_WGT,BASE_PRICE=@BASE_PRICE,EFFECT_PRICE=@EFFECT_PRICE,BIDD_PRICE=@BIDD_PRICE,CONTRACT_NO=@CONTRACT_NO,ORD_USAGE=@ORD_USAGE,ORD_STAT=@ORD_STAT,END_USER=@END_USER,QUANTITY=@QUANTITY,DELIVERY_TIME=@DELIVERY_TIME,REMARK=@REMARK WHERE ID=@ID";
return(DBManager <ORDERED> .Execute(sql, new
{
ID = ID,
EMP_ID = EMP_ID,
ORDED_DATE = ORDED_DATE,
CUSTOMER_ID = CUSTOMER_ID,
ORDER_CR_HR = ORDER_CR_HR,
STS_ST_CLS = STS_ST_CLS,
STS_ST_SER = STS_ST_SER,
SURFACE_CD = SURFACE_CD,
ORD_THK = ORD_THK,
ORD_WTH = ORD_WTH,
ORD_EDGE = ORD_EDGE,
ORD_WGT = ORD_WGT,
BASE_PRICE = BASE_PRICE,
EFFECT_PRICE = EFFECT_PRICE,
BIDD_PRICE = BIDD_PRICE,
CONTRACT_NO = CONTRACT_NO,
ORD_USAGE = ORD_USAGE,
ORD_STAT = ORD_STAT,
QUANTITY = QUANTITY,
END_USER = END_USER,
REMARK = REMARK,
DELIVERY_TIME = DELIVERY_TIME
}));
}
public virtual int Insert(string EMP_ID, DateTime ORDED_DATE, string CUSTOMER_ID, string ORDER_CR_HR, string STS_ST_CLS, string STS_ST_SER,
string SURFACE_CD, decimal ORD_THK, decimal ORD_WTH, string ORD_EDGE, decimal ORD_WGT, decimal BASE_PRICE, decimal EFFECT_PRICE,
decimal BIDD_PRICE, string CONTRACT_NO, string ORD_USAGE, string ORD_STAT, string END_USER, int QUANTITY, string DELIVERY_TIME, string REMARK)
{
var id = this.GenerateId();
var sql = "INSERT INTO ORDERED(ID,EMP_ID,ORDED_DATE,CUSTOMER_ID,ORDER_CR_HR,STS_ST_CLS,STS_ST_SER,SURFACE_CD,ORD_THK,ORD_WTH,ORD_EDGE,ORD_WGT,BASE_PRICE,EFFECT_PRICE,BIDD_PRICE,CONTRACT_NO,ORD_USAGE,ORD_STAT,END_USER,QUANTITY,DELIVERY_TIME,REMARK,CREATE_AT) VALUES(@ID,@EMP_ID,@ORDED_DATE,@CUSTOMER_ID,@ORDER_CR_HR,@STS_ST_CLS,@STS_ST_SER,@SURFACE_CD,@ORD_THK,@ORD_WTH,@ORD_EDGE,@ORD_WGT,@BASE_PRICE,@EFFECT_PRICE,@BIDD_PRICE,@CONTRACT_NO,@ORD_USAGE,@ORD_STAT,@END_USER,@QUANTITY,@DELIVERY_TIME,@REMARK, GETDATE())";
return(DBManager <ORDERED> .Execute(sql, new
{
ID = id,
EMP_ID = EMP_ID,
ORDED_DATE = ORDED_DATE,
CUSTOMER_ID = CUSTOMER_ID,
ORDER_CR_HR = ORDER_CR_HR,
STS_ST_CLS = STS_ST_CLS,
STS_ST_SER = STS_ST_SER,
SURFACE_CD = SURFACE_CD,
ORD_THK = ORD_THK,
ORD_WTH = ORD_WTH,
ORD_EDGE = ORD_EDGE,
ORD_WGT = ORD_WGT,
BASE_PRICE = BASE_PRICE,
EFFECT_PRICE = EFFECT_PRICE,
BIDD_PRICE = BIDD_PRICE,
CONTRACT_NO = CONTRACT_NO,
ORD_USAGE = ORD_USAGE,
ORD_STAT = ORD_STAT,
END_USER = END_USER,
QUANTITY = QUANTITY,
DELIVERY_TIME = DELIVERY_TIME,
REMARK = REMARK
}));
}
public int ResetPassword(string EMP_ID)
{
var password = this.Encode("123456");
var sql = "UPDATE EMPLOYEE SET PASSWORD=@PASSWORD WHERE EMP_ID=@EMP_ID";
return(DBManager <EMPLOYEE> .Execute(sql, new { EMP_ID = EMP_ID, PASSWORD = password }));
}
public virtual int Update(string CUS_ID, string ID)
{
var sql = "UPDATE CUSTOMER SET PERSON=@ID WHERE ID=@CUS_ID";
return(DBManager <CUSTOMER> .Execute(sql, new
{
ID = ID,
CUS_ID = CUS_ID
}));
}
public virtual int Delete(int ID = 0)
{
var sql = "DELETE FROM STD_CODE ";
if (ID == 0)
{
return(DBManager <STD_CODE> .Execute(sql));
}
sql += " WHERE ID=@ID ";
return(DBManager <STD_CODE> .Execute(sql, new { ID = ID }));
}
public virtual int Update(string EMP_ID, string VISIT_PLAN_MONTH, int VISIT_TARGET)
{
var sql = "UPDATE EMP_VISIT SET EMP_ID=@EMP_ID,VISIT_PLAN_MONTH=@VISIT_PLAN_MONTH,VISIT_TARGET=@VISIT_TARGET WHERE EMP_ID=@EMP_ID AND VISIT_PLAN_MONTH=@VISIT_PLAN_MONTH";
return(DBManager <EMP_VISIT> .Execute(sql, new
{
EMP_ID = EMP_ID,
VISIT_PLAN_MONTH = VISIT_PLAN_MONTH,
VISIT_TARGET = VISIT_TARGET
}));
}
public int Insert(string CUS_ID, string END_USER_ID, string NAME)
{
var sql = "INSERT INTO END_USER(CUS_ID, END_USER_ID,NAME) VALUES(@CUS_ID, @END_USER_ID,@NAME)";
return(DBManager <END_USER> .Execute(sql, new
{
CUS_ID = CUS_ID,
END_USER_ID = END_USER_ID,
NAME = NAME
}));
}
public virtual int Delete(string ID = "")
{
var sql = "DELETE FROM CONTACT ";
if (string.IsNullOrWhiteSpace(ID))
{
return(DBManager <CONTACT> .Execute(sql));
}
sql += " WHERE ID=@ID ";
return(DBManager <CONTACT> .Execute(sql, new { ID = ID }));
}
public virtual int Delete(int ID = 0)
{
var sql = "DELETE FROM EMP_VISIT ";
if (ID == 0)
{
return(DBManager <EMP_VISIT> .Execute(sql));
}
sql += " WHERE ID=@ID ";
return(DBManager <EMP_VISIT> .Execute(sql, new { ID = ID }));
}
public virtual int DeleteList(string ID, List <string> CUS)
{
var str = "(";
foreach (var item in CUS)
{
str += "'" + item + "',";
}
var output = str.Remove(str.Length - 1, 1) + ")";
var sql = "DELETE FROM EMP_CUST WHERE EMP_ID=@ID AND CUST_ID IN " + output;
return(DBManager <EMP_CUST> .Execute(sql, new { ID = ID }));
}
public virtual int Update(string EMP_ID, string EMP_NAME, string EMP_DEPT, string EMP_EMAIL, string EMP_MOBILE, int ROLE)
{
var sql = "UPDATE EMPLOYEE SET EMP_ID=@EMP_ID,EMP_NAME=@EMP_NAME,EMP_DEPT=@EMP_DEPT,EMP_EMAIL=@EMP_EMAIL,EMP_MOBILE=@EMP_MOBILE,ROLE=@ROLE WHERE EMP_ID=@EMP_ID";
return(DBManager <EMPLOYEE> .Execute(sql, new
{
EMP_ID = EMP_ID,
EMP_NAME = EMP_NAME,
EMP_DEPT = EMP_DEPT,
EMP_EMAIL = EMP_EMAIL,
EMP_MOBILE = EMP_MOBILE,
ROLE = ROLE
}));
}
public virtual int Update(string ID, string NAME, string DOB, string POSITION, string MOBILE, string EMAIL, string SEX)
{
var sql = "UPDATE CONTACT SET NAME=@NAME,DOB=@DOB,POSITION=@POSITION,MOBILE=@MOBILE,EMAIL=@EMAIL,SEX=@SEX WHERE ID=@ID";
return(DBManager <CUSTOMER> .Execute(sql, new
{
ID = ID,
NAME = NAME,
DOB = DOB,
POSITION = POSITION,
MOBILE = MOBILE,
EMAIL = EMAIL,
SEX = SEX
}));
}
public virtual int Update(string EMP_ID, string CUSTOMER_ID, string CUST_CONTACTOR, DateTime?CONTACT_DATE, string CUST_VIST_TYPE, string CUST_VIST_PURPOSE, string VIST_REMARK, string ID)
{
var sql = "UPDATE VIST_CONTACTOR SET EMP_ID=@EMP_ID,CUSTOMER_ID=@CUSTOMER_ID,CUST_CONTACTOR=@CUST_CONTACTOR,CONTACT_DATE=@CONTACT_DATE,CUST_VIST_TYPE=@CUST_VIST_TYPE,CUST_VIST_PURPOSE=@CUST_VIST_PURPOSE,VIST_REMARK=@VIST_REMARK WHERE ID=@ID";
return(DBManager <VIST_CONTACTOR> .Execute(sql, new
{
EMP_ID = EMP_ID,
CUSTOMER_ID = CUSTOMER_ID,
CUST_CONTACTOR = CUST_CONTACTOR,
CONTACT_DATE = CONTACT_DATE,
CUST_VIST_TYPE = CUST_VIST_TYPE,
CUST_VIST_PURPOSE = CUST_VIST_PURPOSE,
VIST_REMARK = VIST_REMARK,
ID = ID
}));
}
public virtual int Insert(string EMP_ID, string EMP_NAME, string EMP_DEPT, string EMP_EMAIL, string EMP_MOBILE, string PASSWORD, int ROLE)
{
PASSWORD = this.Encode(PASSWORD);
var sql = "INSERT INTO EMPLOYEE(EMP_ID,EMP_NAME,EMP_DEPT,EMP_EMAIL,EMP_MOBILE,PASSWORD,ROLE) VALUES(@EMP_ID,@EMP_NAME,@EMP_DEPT,@EMP_EMAIL,@EMP_MOBILE,@PASSWORD,@ROLE)";
return(DBManager <EMPLOYEE> .Execute(sql, new
{
EMP_ID = EMP_ID,
EMP_NAME = EMP_NAME,
EMP_DEPT = EMP_DEPT,
EMP_EMAIL = EMP_EMAIL,
EMP_MOBILE = EMP_MOBILE,
PASSWORD = PASSWORD,
ROLE = ROLE
}));
}
public virtual int Insert(string CUS_ID, string NAME, string DOB, string POSITION, string MOBILE, string EMAIL, string SEX)
{
var CONT_ID = GenerateId();
var sql = "INSERT INTO CONTACT(ID,CUS_ID,NAME,DOB,POSITION,MOBILE,EMAIL,SEX) VALUES(@ID,@CUS_ID,@NAME,@DOB,@POSITION,@MOBILE,@EMAIL,@SEX)";
return(DBManager <CUSTOMER> .Execute(sql, new
{
ID = CONT_ID,
CUS_ID = CUS_ID,
NAME = NAME,
DOB = DOB,
POSITION = POSITION,
MOBILE = MOBILE,
EMAIL = EMAIL,
SEX = SEX
}));
}
public virtual int Insert(string EMP_ID, string CUSTOMER_ID, string CUST_CONTACTOR, DateTime?CONTACT_DATE, string CUST_VIST_TYPE, string CUST_VIST_PURPOSE, string VIST_REMARK)
{
var ID = GenerateId();
var sql = "INSERT INTO VIST_CONTACTOR(ID,EMP_ID,CUSTOMER_ID,CUST_CONTACTOR,CONTACT_DATE,CUST_VIST_TYPE,CUST_VIST_PURPOSE,VIST_REMARK) VALUES(@ID,@EMP_ID,@CUSTOMER_ID,@CUST_CONTACTOR,@CONTACT_DATE,@CUST_VIST_TYPE,@CUST_VIST_PURPOSE,@VIST_REMARK)";
return(DBManager <VIST_CONTACTOR> .Execute(sql, new
{
ID = ID,
EMP_ID = EMP_ID,
CUSTOMER_ID = CUSTOMER_ID,
CUST_CONTACTOR = CUST_CONTACTOR,
CONTACT_DATE = CONTACT_DATE,
CUST_VIST_TYPE = CUST_VIST_TYPE,
CUST_VIST_PURPOSE = CUST_VIST_PURPOSE,
VIST_REMARK = VIST_REMARK
}));
}
public int ChangeId(string CUS_ID, string OLD_ID)
{
var sql1 = "UPDATE CONTACT SET CUS_ID=@CUS_ID WHERE CUS_ID=@OLD_ID";
var sql2 = "UPDATE CLAIM SET CUSTOMER_ID=@CUS_ID WHERE CUSTOMER_ID=@OLD_ID";
var sql3 = "UPDATE END_USER SET CUS_ID=@CUS_ID WHERE CUS_ID=@OLD_ID";
var sql4 = "UPDATE ORDERED SET CUSTOMER_ID=@CUS_ID WHERE CUSTOMER_ID=@OLD_ID";
var sql5 = "UPDATE VIST_CONTACTOR SET CUSTOMER_ID=@CUS_ID WHERE CUSTOMER_ID=@OLD_ID";
DBManager <CUSTOMER> .Execute(sql1, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
});
DBManager <CUSTOMER> .Execute(sql2, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
});
DBManager <CUSTOMER> .Execute(sql3, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
});
DBManager <CUSTOMER> .Execute(sql4, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
});
DBManager <CUSTOMER> .Execute(sql5, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
});
var sql = "UPDATE CUSTOMER SET ID=@CUS_ID WHERE ID=@OLD_ID";
return(DBManager <CUSTOMER> .Execute(sql, new
{
CUS_ID = CUS_ID,
OLD_ID = OLD_ID
}));
}
public virtual int Update(string ID, string NAME, string ADDRESS, string LOCATION, string TEL, string FAX, string ESTABLE, string CONTACT,
string CLASS, string APPLICATION, string PERSON, string SPEC, string TYPE)
{
var sql = "UPDATE CUSTOMER SET NAME=@NAME,ADDRESS=@ADDRESS,LOCATION=@LOCATION,TEL=@TEL,FAX=@FAX,ESTABLE=@ESTABLE,CONTACT=@CONTACT,CLASS=@CLASS,APPLICATION=@APPLICATION,PERSON=@PERSON,SPEC=@SPEC,TYPE=@TYPE WHERE ID=@ID";
return(DBManager <CUSTOMER> .Execute(sql, new
{
ID = ID,
NAME = NAME,
ADDRESS = ADDRESS,
LOCATION = LOCATION,
TEL = TEL,
FAX = FAX,
ESTABLE = ESTABLE,
CONTACT = CONTACT,
CLASS = CLASS,
APPLICATION = APPLICATION,
PERSON = PERSON,
SPEC = SPEC,
TYPE = TYPE
}));
}
public virtual int Insert(string ID, string NAME, string ADDRESS, string LOCATION, string TEL, string FAX, string ESTABLE, string CONTACT,
string CLASS, string APPLICATION, string PERSON, string SPEC, string TYPE)
{
var sql = "INSERT INTO CUSTOMER(ID,NAME,ADDRESS,LOCATION,TEL,FAX,ESTABLE,CONTACT,CLASS,APPLICATION,PERSON,SPEC,TYPE) VALUES(@ID,@NAME,@ADDRESS,@LOCATION,@TEL,@FAX,@ESTABLE,@CONTACT,@CLASS,@APPLICATION,@PERSON,@SPEC,@TYPE)";
return(DBManager <CUSTOMER> .Execute(sql, new
{
ID = ID,
NAME = NAME,
ADDRESS = ADDRESS,
LOCATION = LOCATION,
TEL = TEL,
FAX = FAX,
ESTABLE = ESTABLE,
CONTACT = CONTACT,
CLASS = CLASS,
APPLICATION = APPLICATION,
PERSON = PERSON,
SPEC = SPEC,
TYPE = TYPE
}));
}
public virtual int Update(string EMP_ID, string CLAIM_NO, DateTime?CLAIM_DATE, string CUSTOMER_ID, string COIL_NO, decimal CLAIM_WGT,
decimal NET_WGT, DateTime?VISIT_DATE, string DEFECT_CD, string DEFECT_LINE, DateTime?FINISH_DATE, decimal COMPENT, string REMARK,
string STATUS, decimal COIL_THK, decimal COIL_WTH, string STS_ST_CLS, string SURFACE_CD, string GRADE, string DEFFECT_KIND,
string END_USER, string SPEC, string TYPE, string ATTACHMENT = "")
{
var sql = string.Format(@"UPDATE CLAIM SET EMP_ID=@EMP_ID,TYPE=@TYPE,CLAIM_DATE=@CLAIM_DATE,CUSTOMER_ID=@CUSTOMER_ID,COIL_NO=@COIL_NO,
CLAIM_WGT=@CLAIM_WGT,NET_WGT=@NET_WGT,VISIT_DATE=@VISIT_DATE,DEFECT_CD=@DEFECT_CD,DEFECT_LINE=@DEFECT_LINE,FINISH_DATE=@FINISH_DATE,COMPENT=@COMPENT,
REMARK=@REMARK,STATUS=@STATUS,COIL_THK=@COIL_THK,COIL_WTH=@COIL_WTH,STS_ST_CLS=@STS_ST_CLS,SURFACE_CD=@SURFACE_CD,GRADE=@GRADE,
DEFFECT_KIND=@DEFFECT_KIND,END_USER=@END_USER,SPEC=@SPEC,ATTACHMENT=@ATTACHMENT WHERE CLAIM_NO=@CLAIM_NO");
return(DBManager <CLAIM> .Execute(sql, new
{
EMP_ID = EMP_ID,
CLAIM_NO = CLAIM_NO,
CLAIM_DATE = CLAIM_DATE,
CUSTOMER_ID = CUSTOMER_ID,
COIL_NO = COIL_NO,
CLAIM_WGT = CLAIM_WGT,
NET_WGT = NET_WGT,
VISIT_DATE = VISIT_DATE,
DEFECT_CD = DEFECT_CD,
DEFECT_LINE = DEFECT_LINE,
FINISH_DATE = FINISH_DATE,
COMPENT = COMPENT,
REMARK = REMARK,
STATUS = STATUS,
COIL_THK = COIL_THK,
COIL_WTH = COIL_WTH,
STS_ST_CLS = STS_ST_CLS,
SURFACE_CD = SURFACE_CD,
GRADE = GRADE,
DEFFECT_KIND = DEFFECT_KIND,
END_USER = END_USER,
SPEC = SPEC,
TYPE = TYPE,
ATTACHMENT = ATTACHMENT
}));
}
public virtual int Insert(string EMP_ID, string CLAIM_NO, DateTime?CLAIM_DATE, string CUSTOMER_ID, string COIL_NO, decimal CLAIM_WGT,
decimal NET_WGT, DateTime?VISIT_DATE, string DEFECT_CD, string DEFECT_LINE, DateTime?FINISH_DATE, decimal COMPENT, string REMARK,
string STATUS, decimal COIL_THK, decimal COIL_WTH, string STS_ST_CLS, string SURFACE_CD, string GRADE, string DEFFECT_KIND,
string END_USER, string SPEC, string TYPE, string ATTACHMENT = "")
{
CLAIM_NO = this.GenerateId();
var sql = string.Format(@"
INSERT INTO CLAIM(EMP_ID,CLAIM_NO,CLAIM_DATE,CUSTOMER_ID,COIL_NO,CLAIM_WGT,NET_WGT,VISIT_DATE,DEFECT_CD,DEFECT_LINE,FINISH_DATE,COMPENT,REMARK,STATUS,
COIL_THK,COIL_WTH,SURFACE_CD,GRADE,DEFFECT_KIND,END_USER,SPEC,TYPE,ATTACHMENT) VALUES(@EMP_ID,@CLAIM_NO,@CLAIM_DATE,@CUSTOMER_ID,@COIL_NO,@CLAIM_WGT,@NET_WGT,
@VISIT_DATE,@DEFECT_CD,@DEFECT_LINE,@FINISH_DATE,@COMPENT,@REMARK,@STATUS,@COIL_THK,@COIL_WTH,@SURFACE_CD ,@GRADE,@DEFFECT_KIND,@END_USER,@SPEC,@TYPE,@ATTACHMENT)");
return(DBManager <CLAIM> .Execute(sql, new
{
EMP_ID = EMP_ID,
CLAIM_NO = CLAIM_NO,
CLAIM_DATE = CLAIM_DATE,
CUSTOMER_ID = CUSTOMER_ID,
COIL_NO = COIL_NO,
CLAIM_WGT = CLAIM_WGT,
NET_WGT = NET_WGT,
VISIT_DATE = VISIT_DATE,
DEFECT_CD = DEFECT_CD,
DEFECT_LINE = DEFECT_LINE,
FINISH_DATE = FINISH_DATE,
COMPENT = COMPENT,
REMARK = REMARK,
STATUS = STATUS,
COIL_THK = COIL_THK,
COIL_WTH = COIL_WTH,
DEFFECT_KIND = DEFFECT_KIND,
SURFACE_CD = SURFACE_CD,
END_USER = END_USER,
GRADE = GRADE,
SPEC = SPEC,
TYPE = TYPE,
ATTACHMENT = ATTACHMENT
}));
}
public virtual int Insert(string EMP_ID, string CUST_ID)
{
var sql = "INSERT INTO EMP_CUST(EMP_ID,CUST_ID) VALUES(@EMP_ID,@CUST_ID)";
return(DBManager <EMP_CUST> .Execute(sql, new { EMP_ID = EMP_ID, CUST_ID = CUST_ID }));
}
public int ChangePassword(string EmpId, string pass, string newpass)
{
var sql = "UPDATE EMPLOYEE SET PASSWORD=@NEWPASS WHERE EMP_ID=@EMP_ID AND PASSWORD=@PASS";
return(DBManager <EMPLOYEE> .Execute(sql, new { NEWPASS = newpass, EMP_ID = EmpId, PASS = pass }));
}
public virtual int Insert(string EMP_ID, string VISIT_PLAN_MONTH, int VISIT_TARGET, int VISIT_RESULT)
{
var sql = "INSERT INTO EMP_VISIT(EMP_ID,VISIT_PLAN_MONTH,VISIT_TARGET,VISIT_RESULT) VALUES(@EMP_ID,@VISIT_PLAN_MONTH,@VISIT_TARGET,@VISIT_RESULT)";
return(DBManager <EMP_VISIT> .Execute(sql, new { EMP_ID = EMP_ID, VISIT_PLAN_MONTH = VISIT_PLAN_MONTH, VISIT_TARGET = VISIT_TARGET, VISIT_RESULT = VISIT_RESULT }));
}
public virtual int Update(string STD_CD_KIND, string STD_CD_NAME)
{
var sql = "UPDATE STD_CODE SET STD_CD_KIND=@STD_CD_KIND,STD_CD_NAME=@STD_CD_NAME WHERE ID=@ID";
return(DBManager <STD_CODE> .Execute(sql, new { STD_CD_KIND = STD_CD_KIND, STD_CD_NAME = STD_CD_NAME }));
}
public virtual int Insert(string STD_CD_KIND, string STD_CD_NAME)
{
var sql = "INSERT INTO STD_CODE(STD_CD_KIND,STD_CD_NAME) VALUES(@STD_CD_KIND,@STD_CD_NAME)";
return(DBManager <STD_CODE> .Execute(sql, new { STD_CD_KIND = STD_CD_KIND, STD_CD_NAME = STD_CD_NAME }));
}
public virtual int Update(string EMP_ID, string CUST_ID)
{
var sql = "UPDATE EMP_CUST SET EMP_ID=@EMP_ID,CUST_ID=@CUST_ID WHERE EMP_ID=@EMP_ID AND CUST_ID=@CUST";
return(DBManager <EMP_CUST> .Execute(sql, new { EMP_ID = EMP_ID, CUST_ID = CUST_ID }));
}