/// <summary>
/// 得到一个对象实体
/// </summary>
public MobileSoft.Model.WorkFlow.Tb_WorkFlow_FlowSort GetModel(int InfoId)
{
SqlParameter[] parameters =
{
new SqlParameter("@InfoId", SqlDbType.Int, 4)
};
parameters[0].Value = InfoId;
MobileSoft.Model.WorkFlow.Tb_WorkFlow_FlowSort model = new MobileSoft.Model.WorkFlow.Tb_WorkFlow_FlowSort();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_WorkFlow_FlowSort_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["InfoId"].ToString() != "")
{
model.InfoId = int.Parse(ds.Tables[0].Rows[0]["InfoId"].ToString());
}
if (ds.Tables[0].Rows[0]["Pid"].ToString() != "")
{
model.Pid = int.Parse(ds.Tables[0].Rows[0]["Pid"].ToString());
}
model.FlowSortName = ds.Tables[0].Rows[0]["FlowSortName"].ToString();
if (ds.Tables[0].Rows[0]["IsUpdate"].ToString() != "")
{
model.IsUpdate = int.Parse(ds.Tables[0].Rows[0]["IsUpdate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsFlow"].ToString() != "")
{
model.IsFlow = int.Parse(ds.Tables[0].Rows[0]["IsFlow"].ToString());
}
model.DocumentUrl = ds.Tables[0].Rows[0]["DocumentUrl"].ToString();
if (ds.Tables[0].Rows[0]["SystemSign"].ToString() != "")
{
model.SystemSign = int.Parse(ds.Tables[0].Rows[0]["SystemSign"].ToString());
}
model.DirectionaryCode = ds.Tables[0].Rows[0]["DirectionaryCode"].ToString();
if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
{
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString());
}
model.UseStartDate = ds.Tables[0].Rows[0]["UseStartDate"].ToString();
model.UseEndDate = ds.Tables[0].Rows[0]["UseEndDate"].ToString();
model.UseUserList = ds.Tables[0].Rows[0]["UseUserList"].ToString();
model.UseUserNameList = ds.Tables[0].Rows[0]["UseUserNameList"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MobileSoft.Model.WorkFlow.Tb_WorkFlow_FlowSort model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@InfoId", SqlDbType.Int, 4),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@FlowSortName", SqlDbType.VarChar, 1000),
new SqlParameter("@IsUpdate", SqlDbType.Int, 4),
new SqlParameter("@IsFlow", SqlDbType.Int, 4),
new SqlParameter("@DocumentUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@SystemSign", SqlDbType.Int, 4),
new SqlParameter("@DirectionaryCode", SqlDbType.NVarChar, 20),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@UseStartDate", SqlDbType.NVarChar, 50),
new SqlParameter("@UseEndDate", SqlDbType.NVarChar, 50),
new SqlParameter("@UseUserList", SqlDbType.NVarChar, 1000),
new SqlParameter("@UseUserNameList", SqlDbType.NVarChar, 1000)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Pid;
parameters[2].Value = model.FlowSortName;
parameters[3].Value = model.IsUpdate;
parameters[4].Value = model.IsFlow;
parameters[5].Value = model.DocumentUrl;
parameters[6].Value = model.SystemSign;
parameters[7].Value = model.DirectionaryCode;
parameters[8].Value = model.Sort;
parameters[9].Value = model.IsDelete;
parameters[10].Value = model.UseStartDate;
parameters[11].Value = model.UseEndDate;
parameters[12].Value = model.UseUserList;
parameters[13].Value = model.UseUserNameList;
DbHelperSQL.RunProcedure("Proc_Tb_WorkFlow_FlowSort_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
