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