/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.WorkFlow.Tb_WorkFlow_CheckLevel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@InfoId", SqlDbType.Int, 4), new SqlParameter("@InstanceInfoId", SqlDbType.Int, 4), new SqlParameter("@WorkFlowInfoId", SqlDbType.Int, 4), new SqlParameter("@StartUserCode", SqlDbType.NVarChar, 50), new SqlParameter("@CheckUserCode", SqlDbType.NVarChar, 50), new SqlParameter("@CheckType", SqlDbType.Int, 4), new SqlParameter("@OprState", SqlDbType.Int, 4), new SqlParameter("@RecordDate", SqlDbType.DateTime), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@IsGoToNext", SqlDbType.Int, 4) }; parameters[0].Value = model.InfoId; parameters[1].Value = model.InstanceInfoId; parameters[2].Value = model.WorkFlowInfoId; parameters[3].Value = model.StartUserCode; parameters[4].Value = model.CheckUserCode; parameters[5].Value = model.CheckType; parameters[6].Value = model.OprState; parameters[7].Value = model.RecordDate; parameters[8].Value = model.Sort; parameters[9].Value = model.IsGoToNext; DbHelperSQL.RunProcedure("Proc_Tb_WorkFlow_CheckLevel_Update", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.WorkFlow.Tb_WorkFlow_CheckLevel GetModel(int InfoId) { SqlParameter[] parameters = { new SqlParameter("@InfoId", SqlDbType.Int, 4) }; parameters[0].Value = InfoId; MobileSoft.Model.WorkFlow.Tb_WorkFlow_CheckLevel model = new MobileSoft.Model.WorkFlow.Tb_WorkFlow_CheckLevel(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_WorkFlow_CheckLevel_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]["InstanceInfoId"].ToString() != "") { model.InstanceInfoId = int.Parse(ds.Tables[0].Rows[0]["InstanceInfoId"].ToString()); } if (ds.Tables[0].Rows[0]["WorkFlowInfoId"].ToString() != "") { model.WorkFlowInfoId = int.Parse(ds.Tables[0].Rows[0]["WorkFlowInfoId"].ToString()); } model.StartUserCode = ds.Tables[0].Rows[0]["StartUserCode"].ToString(); model.CheckUserCode = ds.Tables[0].Rows[0]["CheckUserCode"].ToString(); if (ds.Tables[0].Rows[0]["CheckType"].ToString() != "") { model.CheckType = int.Parse(ds.Tables[0].Rows[0]["CheckType"].ToString()); } if (ds.Tables[0].Rows[0]["OprState"].ToString() != "") { model.OprState = int.Parse(ds.Tables[0].Rows[0]["OprState"].ToString()); } if (ds.Tables[0].Rows[0]["RecordDate"].ToString() != "") { model.RecordDate = DateTime.Parse(ds.Tables[0].Rows[0]["RecordDate"].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]["IsGoToNext"].ToString() != "") { model.IsGoToNext = int.Parse(ds.Tables[0].Rows[0]["IsGoToNext"].ToString()); } return(model); } else { return(null); } }