public static OperationResult AddNightBan(NightBanEditModel model)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@NightBanName", SqlDbType.NVarChar),
new SqlParameter("@NightBanAddress", SqlDbType.NVarChar),
new SqlParameter("@StartTime", SqlDbType.Time),
new SqlParameter("@EndTime", SqlDbType.Time),
new SqlParameter("@IsEnabled", SqlDbType.Bit),
new SqlParameter("@IsDefault", SqlDbType.Bit),
new SqlParameter("@CreateUserID", SqlDbType.Int)
};
paras[0].Value = model.NightBanName.Trim();
paras[1].Value = model.NightBanAddress.Trim();
paras[2].Value = model.StartTime;
paras[3].Value = model.EndTime;
paras[4].Value = model.IsEnabled;
paras[5].Value = false;
paras[6].Value = model.CreateUserID;
#region SQL
string sql = @"INSERT INTO [dbo].[NightBan]([NightBanName] ,[NightBanAddress] ,[StartTime] ,[EndTime]
,[IsEnabled] ,[IsDefault],[CreateUserID],[CreateTime] ,[Status]) VALUES
(@NightBanName,@NightBanAddress,@StartTime,@EndTime,@IsEnabled,@IsDefault,@CreateUserID,
GETDATE(),0)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public static SelectResult <NightBanEditModel> GetNightBanByID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
};
paras[0].Value = id;
string sql = @" SELECT [ID],[NightBanName],[NightBanAddress],[StartTime],[EndTime]
,[IsEnabled] FROM NightBan WHERE ID=@ID";
List <NightBanEditModel> list = ConvertToList <NightBanEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
NightBanEditModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <NightBanEditModel>()
{
DataResult = data,
Message = msg
});
}
public ActionResult AddNightBan()
{
NightBanEditModel model = new NightBanEditModel();
model.IsEnabled = true;
model.StartTime = "02:00:00";
model.EndTime = "05:00:00";
return(PartialView("_AddNightBan", model));
}
public ActionResult EditNightBan(NightBanEditModel model)
{
if (ModelState.IsValid)
{
model.UpdateUserID = base.UserIDForLog;
var result = NightBanBLL.EditNightBan(model);
base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID);
return(Json(result));
}
else
{
return(PartialView("_EditNightBan", model));
}
}
public ActionResult AddNightBan(NightBanEditModel model)
{
if (ModelState.IsValid)
{
model.CreateUserID = base.UserIDForLog;
var result = NightBanBLL.AddNightBan(model);
base.DoLog(OperationTypeEnum.Add, result, "NightBanName:" + model.NightBanName);
return(Json(result));
}
else
{
return(PartialView("_AddNightBan", model));
}
}
public static OperationResult EditNightBan(NightBanEditModel model)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@NightBanName", SqlDbType.NVarChar),
new SqlParameter("@NightBanAddress", SqlDbType.NVarChar),
new SqlParameter("@StartTime", SqlDbType.Time),
new SqlParameter("@EndTime", SqlDbType.Time),
new SqlParameter("@IsEnabled", SqlDbType.Bit),
new SqlParameter("@UpdateUserID", SqlDbType.Int)
};
paras[0].Value = model.ID;
paras[1].Value = model.NightBanName.Trim();
paras[2].Value = model.NightBanAddress.Trim();
paras[3].Value = model.StartTime;
paras[4].Value = model.EndTime;
paras[5].Value = model.IsEnabled;
paras[6].Value = model.UpdateUserID;
#region SQL
string sql;
sql = @"UPDATE [dbo].[NightBan] SET [NightBanName] = @NightBanName ,[NightBanAddress] = @NightBanAddress
,[StartTime] = @StartTime,[EndTime] = @EndTime ,[IsEnabled] = @IsEnabled ,[UpdateUserID] = @UpdateUserID
,[UpdateTime] = GETDATE() WHERE ID = @ID";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
