/// <summary>
/// 得到一个打印配置实体
/// </summary>
/// <param name="printType">打印类型</param>
/// <returns>打印配置实体</returns>
public PrintConfigEntity GetModel(string printType)
{
SqlParameter[] parameters =
{
new SqlParameter("@printType", SqlDbType.VarChar, 50)
};
parameters[0].Value = printType;
DataSet ds = SQLServerHelper.RunProcedure("uspWip_GetSinglePrintConfig", parameters, "pagetable");
PrintConfigEntity model = new PrintConfigEntity();
if (ds.Tables[0].Rows.Count > 0)
{
var dataRow = ds.Tables[0].Rows[0];
if (dataRow["id"].ToString() != "")
{
model.id = int.Parse(dataRow["id"].ToString());
}
model.printType = dataRow["printType"].ToString();
model.printTypeName = dataRow["printTypeName"].ToString();
model.printerName = dataRow["printerName"].ToString();
model.printTemplete = dataRow["printTemplete"].ToString();
model.printArea = dataRow["printArea"].ToString();
if (dataRow["delFlag"].ToString() != "")
{
if ((dataRow["delFlag"].ToString() == "1") || (dataRow["delFlag"].ToString().ToLower() == "true"))
{
model.delFlag = true;
}
else
{
model.delFlag = false;
}
}
model.creator = dataRow["creator"].ToString();
if (dataRow["createTime"].ToString() != "")
{
model.createTime = DateTime.Parse(dataRow["createTime"].ToString());
}
model.lastModifier = dataRow["lastModifier"].ToString();
if (dataRow["lastModifyTime"].ToString() != "")
{
model.lastModifyTime = DateTime.Parse(dataRow["lastModifyTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条打印配置数据
/// </summary>
/// <param name="model">要插入的打印配置实体</param>
/// <param name="transModel">事务类</param>
/// <returns>插入生成的最新主键值</returns>
public int Add(PrintConfigEntity model, TransactionModel transModel = null)
{
SqlParameter param_id = new SqlParameter();
param_id.ParameterName = "@id";
param_id.SqlDbType = SqlDbType.Int;
param_id.Direction = ParameterDirection.Output;
SqlParameter[] parameters =
{
new SqlParameter("@printType", SqlDbType.NChar, 3),
new SqlParameter("@printTypeName", SqlDbType.NVarChar, 100),
new SqlParameter("@printerName", SqlDbType.NVarChar, 100),
new SqlParameter("@printTemplete", SqlDbType.NVarChar, 20),
new SqlParameter("@delFlag", SqlDbType.Bit, 1),
new SqlParameter("@creator", SqlDbType.NVarChar, 100),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@lastModifier", SqlDbType.NVarChar, 100),
new SqlParameter("@lastModifyTime", SqlDbType.DateTime),
new SqlParameter("@printArea", SqlDbType.NVarChar, 10),
param_id
};
parameters[0].Value = model.printType;
parameters[1].Value = model.printTypeName;
parameters[2].Value = model.printerName;
parameters[3].Value = model.printTemplete;
parameters[4].Value = model.delFlag;
parameters[5].Value = model.creator;
parameters[6].Value = model.createTime;
parameters[7].Value = model.lastModifier;
parameters[8].Value = model.lastModifyTime;
parameters[9].Value = model.printArea;
int rowsAffected;
if (transModel != null)
{
SQLServerHelper.RunProcedure(transModel.conn, transModel.trans, "uspWip_AddPrintConfig", parameters, out rowsAffected);
}
else
{
SQLServerHelper.RunProcedure("uspWip_AddPrintConfig", parameters, out rowsAffected);
}
return((int)parameters[parameters.Length - 1].Value);
}
/// <summary>
/// 更新一条打印配置数据
/// </summary>
/// <param name="model">要更新的打印配置实体</param>
/// <param name="transModel">事务类</param>
/// <returns>是否更新成功</returns>
public bool Update(PrintConfigEntity model, TransactionModel transModel = null)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@printType", SqlDbType.NChar, 3),
new SqlParameter("@printTypeName", SqlDbType.NVarChar, 100),
new SqlParameter("@printerName", SqlDbType.NVarChar, 100),
new SqlParameter("@printTemplete", SqlDbType.NVarChar, 20),
new SqlParameter("@delFlag", SqlDbType.Bit, 1),
new SqlParameter("@lastModifier", SqlDbType.NVarChar, 100),
new SqlParameter("@lastModifyTime", SqlDbType.DateTime),
new SqlParameter("@printArea", SqlDbType.NVarChar, 10),
};
parameters[0].Value = model.id;
parameters[1].Value = model.printType;
parameters[2].Value = model.printTypeName;
parameters[3].Value = model.printerName;
parameters[4].Value = model.printTemplete;
parameters[5].Value = model.delFlag;
parameters[6].Value = model.lastModifier;
parameters[7].Value = model.lastModifyTime;
parameters[8].Value = model.printArea;
int rowsAffected = 0;
if (transModel != null)
{
SQLServerHelper.RunProcedure(transModel.conn, transModel.trans, "uspWip_UpdatePrintConfig", parameters, out rowsAffected);
}
else
{
SQLServerHelper.RunProcedure("uspWip_UpdatePrintConfig", parameters, out rowsAffected);
}
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条打印配置数据
/// </summary>
/// <param name="model">要更新的打印配置实体</param>
/// <returns>是否更新成功</returns>
public bool Update(PrintConfigEntity model)
{
model.lastModifyTime = DateTime.Now;
return(printConfigDAL.Update(model));
}
/// <summary>
/// 增加一条打印配置数据
/// </summary>
/// <param name="model"></param>
/// <returns>插入的最新主键值</returns>
public int Add(PrintConfigEntity model)
{
model.createTime = model.lastModifyTime = DateTime.Now;
model.delFlag = false;
return(printConfigDAL.Add(model));
}
public string InsertPrintConfig0(PrintConfigEntity model)
{
return("OK");
}
/// <summary>
/// 插入打印配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnBody <string> InsertPrintConfig(PrintConfigEntity model)
{
ReturnBody <string> retBody = null;
ExceptionInfoEntity exception = WipLogHelper.GetExceptionInfo <PrintConfigEntity>(namespaceName, "InsertPrintConfig", model);
try
{
#region 验证
if (model == null)
{
exception.exceptionMsg = ResMsg.PARAMETERNOEMPTY;
retBody = BLLHelpler.GetReturnBody <string>(ResCode.PARAMETERNOEMPTY, ResMsg.PARAMETERNOEMPTY, exception);
return(retBody);
}
List <ColumnsModel> columnsList = new List <ColumnsModel>()
{
new ColumnsModel()
{
ChinaName = "打印类型", PropertyName = "printType"
},
new ColumnsModel()
{
ChinaName = "打印类型描述", PropertyName = "printTypeName"
},
new ColumnsModel()
{
ChinaName = "打印机名称", PropertyName = "printerName"
},
new ColumnsModel()
{
ChinaName = "打印模板", PropertyName = "printTemplete"
}
};
ValidateResModel res = ValidateDataHelper.ValidateNullOrEmpty <PrintConfigEntity>(columnsList, model);
if (res != null && !res.IsValidate)
{
exception.exceptionMsg = res.ValidateMsg;
retBody = BLLHelpler.GetReturnBody <string>(ResCode.PARAMETERNOEMPTY, res.ValidateMsg, exception);
return(retBody);
}
//验证重复
if (printConfigBLL.Exists(model.printType.ToString()))
{
exception.exceptionMsg = "数据已经存在";
retBody = BLLHelpler.GetReturnBody <string>(ResCode.FAILURE, exception.exceptionMsg, exception);
return(retBody);
}
#endregion
model.delFlag = false;
model.createTime = model.lastModifyTime = DateTime.Now;
if (printConfigBLL.Add(model) > 0)
{
retBody = BLLHelpler.GetReturnBody <string>(ResCode.SUCCESS, ResMsg.SUCCESS);
}
else
{//失败
exception.exceptionMsg = "保存数据失败";
retBody = BLLHelpler.GetReturnBody <string>(ResCode.FAILURE, exception.exceptionMsg, exception);
}
return(retBody);
}
catch (Exception ex)
{
WipLogHelper.GetExceptionInfoForError(ex, ref exception);
retBody = BLLHelpler.GetReturnBody <string>(ResCode.FAILURE, ResMsg.FAILURE + ":" + ex.Message, exception);
return(retBody);
}
}
public string UpdatePrintConfig0(PrintConfigEntity model)
{
return("OK");
}
