/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.SQMSys.Tb_Sys_Group GetModel(string GroupCode, Guid StreetCode) { SqlParameter[] parameters = { new SqlParameter("@GroupCode", SqlDbType.NVarChar, 50), new SqlParameter("@StreetCode", SqlDbType.UniqueIdentifier) }; parameters[0].Value = GroupCode; parameters[1].Value = StreetCode; MobileSoft.Model.SQMSys.Tb_Sys_Group model = new MobileSoft.Model.SQMSys.Tb_Sys_Group(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Sys_Group_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { model.GroupCode = ds.Tables[0].Rows[0]["GroupCode"].ToString(); if (ds.Tables[0].Rows[0]["StreetCode"].ToString() != "") { model.StreetCode = new Guid(ds.Tables[0].Rows[0]["StreetCode"].ToString()); } model.GroupName = ds.Tables[0].Rows[0]["GroupName"].ToString(); model.GroupDescribe = ds.Tables[0].Rows[0]["GroupDescribe"].ToString(); model.GroupLead = ds.Tables[0].Rows[0]["GroupLead"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.SQMSys.Tb_Sys_Group model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@GroupCode", SqlDbType.NVarChar, 20), new SqlParameter("@StreetCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@GroupName", SqlDbType.NVarChar, 40), new SqlParameter("@GroupDescribe", SqlDbType.NVarChar, 1000), new SqlParameter("@GroupLead", SqlDbType.NVarChar, 20) }; parameters[0].Value = model.GroupCode; parameters[1].Value = model.StreetCode; parameters[2].Value = model.GroupName; parameters[3].Value = model.GroupDescribe; parameters[4].Value = model.GroupLead; DbHelperSQL.RunProcedure("Proc_Tb_Sys_Group_Update", parameters, out rowsAffected); }