public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.msUserSequence d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@USERCODE", d.USERCODE.GetValue());
param.Add("@STDATE", d.STDATE);
param.Add("@ENDATE", d.ENDATE);
param.Add("@USER_ID", d.USER_ID.GetValue());
param.Add("@USER_DATE", d.USER_DATE);
param.Add("@EDIT_TYPE", d.EDIT_TYPE.GetValue());
string cmd = "";
/*
* cmd = DELETE FROM mcis.dbo.msUserSequence "+
* "WHERE USERCODE = @.USERCODE "+
* " AND STDATE = @.STDATE "+
* " AND ENDATE = @.ENDATE "+
* " AND USER_ID = @.USER_ID "+
* " AND USER_DATE = @.USER_DATE "+
* " AND EDIT_TYPE = @.EDIT_TYPE "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.msUserSequence d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@USERCODE", d.USERCODE);
param.Add("@STDATE", d.STDATE);
param.Add("@ENDATE", d.ENDATE);
param.Add("@USER_ID", d.USER_ID);
param.Add("@USER_DATE", d.USER_DATE);
param.Add("@EDIT_TYPE", d.EDIT_TYPE);
string cmd = "INSERT INTO mcis.dbo.msUserSequence " +
$" (USERCODE, STDATE, ENDATE, USER_ID, USER_DATE, EDIT_TYPE) " +
$"VALUES(@USERCODE, @STDATE, @ENDATE, @USER_ID, @USER_DATE, @EDIT_TYPE); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Save(ASSETKKF_MODEL.Data.Mssql.Mcis.msUserSequence d, string userID = "", SqlTransaction transac = null)
{
/*
* if (d.ID.HasValue)
* {
* Update(d, userID, transac);
* return d.ID.Value;
* }
* else
* {
* var req = new ASSETKKF_MODEL.Request.Mcis.msUserSequenceReq()
* req.USERCODE= new List<string>();
* req.USERCODE.Add(d.USERCODE);
*
* req.STDATE= new List<string>();
* req.STDATE.Add(d.STDATE);
*
* req.ENDATE= new List<string>();
* req.ENDATE.Add(d.ENDATE);
*
* req.USER_ID= new List<string>();
* req.USER_ID.Add(d.USER_ID);
*
* req.USER_DATE= new List<string>();
* req.USER_DATE.Add(d.USER_DATE);
*
* req.EDIT_TYPE= new List<string>();
* req.EDIT_TYPE.Add(d.EDIT_TYPE);
*
* var _msUserSequence = Search(req, transac).FirstOrDefault();
* if (msUserSequence != null)
* {
* throw new Exception(Model.Enum.ErrorCode.V001.ToString());
*
* }
*
* return Insert(d, userID, transac);
*/
return(Insert(d, userID, transac));
}
