/// <summary>
/// 检查是否重复
/// </summary>
/// <param name="Model.Piece"></param>
/// <returns></returns>
public static bool CheckRepeat(Model.Piece model)
{
try
{
string sql = "select * from Piece where Name = @Name and Id <> @Id";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name", model.Name.Trim()),
new SqlParameter("@Id", model.Id)
};
DataTable temp = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para);
if (temp.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ErrorLog e = new ErrorLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "CheckRepeat";
e.LogName = "检查是否重复-ForPiece";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Piece>(e, model);
return(true);
}
}
/// <summary>
/// 根据id修改试件
/// </summary>
/// <param name="Model.Piece"></param>
/// <returns></returns>
public static bool ModifyPieceById(ref Model.Piece model, out string errMsg)
{
errMsg = "";
try
{
model.Name = model.Name.Trim();
model.Description = model.Description.Trim();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Id", model.Id),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Number", model.Number),
new SqlParameter("@Order", model.Order),
new SqlParameter("@Count", model.Count),
new SqlParameter("@PrintedCount", model.PrintedCount),
new SqlParameter("@IsPrinted", model.IsPrinted),
new SqlParameter("@Ots", model.Ots),
new SqlParameter("@DelegateNumber", model.DelegateNumber),
new SqlParameter("@AccessoryFactory", model.AccessoryFactory),
new SqlParameter("@VehicleType", model.VehicleType),
new SqlParameter("@TestContent", model.TestContent),
new SqlParameter("@SendPerson", model.SendPerson),
new SqlParameter("@ChargePerson", model.ChargePerson),
new SqlParameter("@SendDate", model.SendDate),
new SqlParameter("@Place", model.Place),
new SqlParameter("@IsEnable", model.IsEnable),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Modifier", model.Modifier),
new SqlParameter("@ModifiedDate", model.ModifiedDate)
};
int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_PieceByIdUpdate", para);
if (i > 0)
{
EventLog e = new EventLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "ModifyPieceById";
e.LogName = "修改试件";
EventLogService.AddEventLog <Model.Piece>(e, model);
return(true);
}
else
{
errMsg = "该记录已被删除，不能修改！";
return(false);
}
}
catch (Exception ex)
{
errMsg = ex.Message;
ErrorLog e = new ErrorLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "ModifyPieceById";
e.LogName = "修改试件";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Piece>(e, model);
return(false);
}
}
private bool tryPut(ref Model.Piece model, out string errMsg)
{
errMsg = "";
bool re = false;
model.Modifier = this.auth.UserId;
model.ModifiedDate = DateTime.Now;
if (PieceManager.ModifyPieceById(ref model, out errMsg))
{
re = true;
}
return(re);
}
private bool tryValidate(Model.Piece model, out string errMsg)
{
errMsg = "";
bool re = true;
if (model.Name == null || model.Name.Length == 0 || model.Name.Length > 20 ||
model.Description.Length > 200)
{
errMsg = "输入数据不合法";
re = false;
}
if (re && PieceManager.CheckRepeat(model))
{
errMsg = "不能重复";
re = false;
}
if (re && model.Modifier != auth.UserId)
{
errMsg = "登录信息异常，请刷新浏览器以重启应用(APP请退出应用后重新打开)";
re = false;
}
return(re);
}
/// <summary>
/// 检查是否重复
/// </summary>
/// <param name="Model.Piece"></param>
/// <returns></returns>
public static bool CheckRepeat(Model.Piece model)
{
return(PieceService.CheckRepeat(model));
}
/// <summary>
/// 根据id修改试件
/// </summary>
/// <param name="Model.Piece"></param>
/// <returns></returns>
public static bool ModifyPieceById(ref Model.Piece model, out string errMsg)
{
return(PieceService.ModifyPieceById(ref model, out errMsg));
}
/// <summary>
/// 添加试件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddPiece(ref Model.Piece model, out string errMsg)
{
return(PieceService.AddPiece(ref model, out errMsg));
}
/// <summary>
/// 添加试件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddPiece(ref Model.Piece model, out string errMsg)
{
errMsg = "";
try
{
model.Name = model.Name.Trim();
model.Description = model.Description.Trim();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Number", model.Number),
new SqlParameter("@Order", model.Order),
new SqlParameter("@Count", model.Count),
new SqlParameter("@PrintedCount", model.PrintedCount),
new SqlParameter("@IsPrinted", model.IsPrinted),
new SqlParameter("@Ots", model.Ots),
new SqlParameter("@DelegateNumber", model.DelegateNumber),
new SqlParameter("@AccessoryFactory", model.AccessoryFactory),
new SqlParameter("@VehicleType", model.VehicleType),
new SqlParameter("@TestContent", model.TestContent),
new SqlParameter("@SendPerson", model.SendPerson),
new SqlParameter("@ChargePerson", model.ChargePerson),
new SqlParameter("@SendDate", model.SendDate),
new SqlParameter("@Place", model.Place),
new SqlParameter("@IsEnable", model.IsEnable),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Creater", model.Creater),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@Modifier", model.Modifier),
new SqlParameter("@ModifiedDate", model.ModifiedDate),
new SqlParameter("@return", SqlDbType.Int)
};
para[21].Direction = ParameterDirection.ReturnValue;
int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_PieceInsert", para);
if (i > 0)
{
model.Id = int.Parse(para[21].Value.ToString());
EventLog e = new EventLog();
e.TargetIds = para[21].Value.ToString();
e.CodeTag = "AddPiece";
e.LogName = "添加试件";
EventLogService.AddEventLog <Model.Piece>(e, model);
return(true);
}
else
{
errMsg = "添加记录失败，受影响行数为0";
return(false);
}
}
catch (Exception ex)
{
errMsg = ex.Message;
ErrorLog e = new ErrorLog();
e.TargetIds = "0";
e.CodeTag = "AddPiece";
e.LogName = "添加试件";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Piece>(e, model);
return(false);
}
}