public ReturnValue Add(LoginUser model)
{
SqlParameter[] parametersAdd = {
new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12),
new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,256),
new SqlParameter("@UserID", SqlDbType.NVarChar,50),
new SqlParameter("@UserPwd", SqlDbType.NVarChar,50),
new SqlParameter("@UserType", SqlDbType.NVarChar,1),
new SqlParameter("@MEMO", SqlDbType.NVarChar,256)};
parametersAdd[0].Value = model.UPDATER_ID;
parametersAdd[1].Value = model.TERMINAL_CD;
parametersAdd[2].Value = model.UserID;
parametersAdd[3].Value = model.UserPwd;
parametersAdd[4].Value = model.UserType;
parametersAdd[5].Value = model.MEMO;
return SqlHelper.ExecuteSql(Add_SQL, parametersAdd);
}
public ReturnValue Add(LoginUser model)
{
OleDbParameter[] parametersAdd = {
new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12),
new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar),
new OleDbParameter("@UserID", OleDbType.VarWChar,50),
new OleDbParameter("@UserPwd", OleDbType.VarWChar,50),
new OleDbParameter("@UserType", OleDbType.VarWChar,1),
new OleDbParameter("@MEMO", OleDbType.LongVarWChar)};
parametersAdd[0].Value = model.UPDATER_ID;
parametersAdd[1].Value = model.TERMINAL_CD;
parametersAdd[2].Value = model.UserID;
parametersAdd[3].Value = model.UserPwd;
parametersAdd[4].Value = model.UserType;
parametersAdd[5].Value = model.MEMO;
return OleDbHelper.ExecuteSql(Add_SQL, parametersAdd);
}
public ReturnValue AddUpdate(LoginUser model)
{
ReturnValue resoult = dalLoginUser.Search(model.UserID);
if (!resoult.ErrorFlag)
{
return resoult;
}
if (resoult.Count > 0)
{
resoult = dalLoginUser.Update(model);
}
else
{
resoult = dalLoginUser.Add(model);
}
return resoult;
}
public ReturnValue Update(LoginUser model)
{
OleDbParameter[] parametersUpdate = {
new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12),
new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar),
new OleDbParameter("@UserPwd", OleDbType.VarWChar,50),
new OleDbParameter("@UserType", OleDbType.VarWChar,1),
new OleDbParameter("@MEMO", OleDbType.LongVarWChar),
new OleDbParameter("@UserID", OleDbType.VarWChar,50)};
parametersUpdate[0].Value = model.UPDATER_ID;
parametersUpdate[1].Value = model.TERMINAL_CD;
parametersUpdate[2].Value = model.UserPwd;
parametersUpdate[3].Value = model.UserType;
parametersUpdate[4].Value = model.MEMO;
parametersUpdate[5].Value = model.UserID;
return OleDbHelper.ExecuteSql(Update_SQL, parametersUpdate);
}
