public List <ASSETKKF_MODEL.Data.Mssql.Mcis.zUser> Search(ASSETKKF_MODEL.Data.Mssql.Mcis.zUser d, SqlTransaction transac = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@UserCode", d.UserCode);
param.Add("@Code", d.Code);
// param.Add("@Description", d.Description);
param.Add("@Type", d.Type);
param.Add("@UserName", d.UserName);
//param.Add("@Email", d.Email);
param.Add("@Status", d.Status);
string cmd = "SELECT * FROM zUser " +
"WHERE (@UserCode IS NULL OR UserCode=@UserCode) " +
"AND (@Code IS NULL OR Code=@Code) " +
// "AND (@Description IS NULL OR UserName=@Description) " +
"AND (@Type IS NULL OR Type=@Type) " +
"AND (@Username IS NULL OR Username=@Username) " +
// "AND (@Email IS NULL OR Email=@Email) " +
"AND (@Status IS NULL OR Status=@Status) " +
";";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.zUser>(cmd, param).ToList();
return(res);
}
public int Update(ASSETKKF_MODEL.Data.Mssql.Mcis.zUser d, string EditUser = "", SqlTransaction transac = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@Code", d.Code);
// param.Add("@Description", d.Description);
param.Add("@Type", d.Type);
param.Add("@Username", d.UserName);
// param.Add("@Email", d.Email);
// param.Add("@Password", d.Password);
// param.Add("@SoftPassword", d.SoftPassword);
param.Add("@UserPw", d.UserPw);
param.Add("@Status", d.Status);
param.Add("@EditUserId", EditUser);
param.Add("@UserCode", d.UserCode);
string cmd = $"UPDATE zUser SET " +
"Code=@Code, " +
// "Description=@Description, " +
"Type=@Type, " +
"Username=@Username, " +
// "Email=@Email, " +
// "Password=@Password, " +
// "SoftPassword=@SoftPassword, " +
"UserPw=@UserPw, " +
"Status=@Status, " +
"EditUserId=@EditUserId, " +
"EditDate=GETDATE() " +
"WHERE UserCode=@UserCode;";
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.zUser d, string EditUser = "", SqlTransaction transac = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@UserCode", d.UserCode);
param.Add("@Code", d.Code);
// param.Add("@Description", d.Description);
param.Add("@Type", d.Type); // 1 = staff, 0 = customer
param.Add("@Username", d.UserName);
param.Add("@UserGrp", d.UserGrp);
// param.Add("@Email", d.Email);
// param.Add("@Password", d.Password);
// param.Add("@SoftPassword", d.SoftPassword);
param.Add("@UserPw", d.UserPw);
param.Add("@Status", d.Status);
param.Add("@EditUserId", EditUser);
// string cmd = "INSERT INTO sxsUser (UserCode, Code, Description, Type, Username, Email, Password, SoftPassword, Status, UpdateBy, Timestamp) " +
// "VALUES (@ID, @Code, @Description, @Type, @Username, @Email, @Password, @SoftPassword, @Status, @UpdateBy, GETDATE());";
string cmd = "INSERT INTO zUser (UserCode, Code, Type, Username, UserGrp, UserPw, Status, EditUserId, EditDate) " +
"VALUES (@ID, @Code, @ @Type, @Username, @UserGrp, @UserPw, @Status, @EditUserId, GETDATE());";
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}