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