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