/// <summary>
/// 得到一个代码项表实体
/// </summary>
/// <param name="id">主键</param>
/// <returns>代码项表实体</returns>
public CodeItemsEntity GetModel(string setCode, string code)
{
SqlParameter[] parameters =
{
new SqlParameter("@setCode", SqlDbType.VarChar, 50),
new SqlParameter("@code", SqlDbType.VarChar, 50)
};
parameters[0].Value = setCode;
parameters[1].Value = code;
DataSet ds = SQLServerHelper.RunProcedure("uspWip_GetSingleCodeItems", parameters, "pagetable");
CodeItemsEntity model = new CodeItemsEntity();
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.code = dataRow["code"].ToString();
model.name = dataRow["name"].ToString();
model.setCode = dataRow["setCode"].ToString();
model.note = dataRow["note"].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>
private List <CodeItemsEntity> DataTableToList(DataTable dt)
{
List <CodeItemsEntity> modelList = new List <CodeItemsEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
CodeItemsEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new CodeItemsEntity();
var dataRow = dt.Rows[n];
if (dataRow["id"].ToString() != "")
{
model.id = int.Parse(dataRow["id"].ToString());
}
model.code = dataRow["code"].ToString();
model.name = dataRow["name"].ToString();
model.setCode = dataRow["setCode"].ToString();
model.setCodeName = dataRow["setCodeName"].ToString();
model.note = dataRow["note"].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());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条代码项表数据
/// </summary>
/// <param name="model">要插入的代码项表实体</param>
/// <param name="transModel">事务类</param>
/// <returns>插入生成的最新主键值</returns>
public int Add(CodeItemsEntity 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("@code", SqlDbType.NVarChar, 100),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@setCode", SqlDbType.NVarChar, 20),
new SqlParameter("@note", SqlDbType.NVarChar, 200),
new SqlParameter("@delFlag", SqlDbType.Bit, 1),
new SqlParameter("@creator", SqlDbType.NVarChar, 256),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@lastModifier", SqlDbType.NVarChar, 256),
new SqlParameter("@lastModifyTime", SqlDbType.DateTime),
param_id
};
parameters[0].Value = model.code;
parameters[1].Value = model.name;
parameters[2].Value = model.setCode;
parameters[3].Value = model.note;
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;
int rowsAffected;
if (transModel != null)
{
SQLServerHelper.RunProcedure(transModel.conn, transModel.trans, "uspWip_AddCodeItems", parameters, out rowsAffected);
}
else
{
SQLServerHelper.RunProcedure("uspWip_AddCodeItems", 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(CodeItemsEntity model, TransactionModel transModel = null)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@code", SqlDbType.NVarChar, 100),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@setCode", SqlDbType.NVarChar, 20),
new SqlParameter("@note", SqlDbType.NVarChar, 200),
new SqlParameter("@delFlag", SqlDbType.Bit, 1),
new SqlParameter("@lastModifier", SqlDbType.NVarChar, 256),
new SqlParameter("@lastModifyTime", SqlDbType.DateTime),
};
parameters[0].Value = model.id;
parameters[1].Value = model.code;
parameters[2].Value = model.name;
parameters[3].Value = model.setCode;
parameters[4].Value = model.note;
parameters[5].Value = model.delFlag;
parameters[6].Value = model.lastModifier;
parameters[7].Value = model.lastModifyTime;
int rowsAffected = 0;
if (transModel != null)
{
SQLServerHelper.RunProcedure(transModel.conn, transModel.trans, "uspWip_UpdateCodeItems", parameters, out rowsAffected);
}
else
{
SQLServerHelper.RunProcedure("uspWip_UpdateCodeItems", parameters, out rowsAffected);
}
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条代码项表数据
/// </summary>
/// <param name="model">要更新的代码项表实体</param>
/// <returns>是否更新成功</returns>
public bool Update(CodeItemsEntity model)
{
model.lastModifyTime = DateTime.Now;
return(codeItemsDAL.Update(model));
}
/// <summary>
/// 增加一条代码项表数据
/// </summary>
/// <param name="model"></param>
/// <returns>插入的最新主键值</returns>
public int Add(CodeItemsEntity model)
{
model.createTime = model.lastModifyTime = DateTime.Now;
model.delFlag = false;
return(codeItemsDAL.Add(model));
}
/// <summary>
/// 插入代码项表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnBody <string> InsertCodeItems(CodeItemsEntity model)
{
ReturnBody <string> retBody = null;
ExceptionInfoEntity exception = WipLogHelper.GetExceptionInfo <CodeItemsEntity>(namespaceName, "InsertCodeItems", 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 = "code"
},
new ColumnsModel()
{
ChinaName = "代码项名称", PropertyName = "name"
},
new ColumnsModel()
{
ChinaName = "代码编码", PropertyName = "setCode"
},
new ColumnsModel()
{
ChinaName = "说明", PropertyName = "note"
},
new ColumnsModel()
{
ChinaName = "创建时间", PropertyName = "createTime", DataType = typeof(DateTime), IsNullable = true
},
new ColumnsModel()
{
ChinaName = "修改时间", PropertyName = "lastModifyTime", DataType = typeof(DateTime), IsNullable = true
},
};
ValidateResModel res = ValidateDataHelper.ValidateNullOrEmpty <CodeItemsEntity>(columnsList, model);
if (res != null && !res.IsValidate)
{
exception.exceptionMsg = res.ValidateMsg;
retBody = BLLHelpler.GetReturnBody <string>(ResCode.PARAMETERNOEMPTY, res.ValidateMsg, exception);
return(retBody);
}
//验证重复
if (codeItemsBLL.Exists(model.setCode, model.code))
{
exception.exceptionMsg = "数据已经存在";
retBody = BLLHelpler.GetReturnBody <string>(ResCode.FAILURE, exception.exceptionMsg, exception);
return(retBody);
}
#endregion
model.delFlag = false;
model.createTime = model.lastModifyTime = DateTime.Now;
if (codeItemsBLL.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 UpdateCodeItems0(CodeItemsEntity model)
{
return("OK");
}
public string InsertCodeItems0(CodeItemsEntity model)
{
return("OK");
}