/// <summary> /// 更新一条数据 /// </summary> public bool Update(CustomerService.Model.CustomerGroup model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@GUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@cName", SqlDbType.VarChar, 20), new SqlParameter("@parentGUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@createDate", SqlDbType.DateTime) }; parameters[0].Value = model.GUID; parameters[1].Value = model.cName; parameters[2].Value = model.parentGUID; parameters[3].Value = model.createDate; DbHelperSQL.RunProcedure("T_CustomerGroup_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CustomerService.Model.CustomerGroup GetModel(Guid GUID) { SqlParameter[] parameters = { new SqlParameter("@GUID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = GUID; CustomerService.Model.CustomerGroup model = new CustomerService.Model.CustomerGroup(); DataSet ds = DbHelperSQL.RunProcedure("T_CustomerGroup_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["GUID"] != null && ds.Tables[0].Rows[0]["GUID"].ToString() != "") { model.GUID = new Guid(ds.Tables[0].Rows[0]["GUID"].ToString()); } if (ds.Tables[0].Rows[0]["cName"] != null && ds.Tables[0].Rows[0]["cName"].ToString() != "") { model.cName = ds.Tables[0].Rows[0]["cName"].ToString(); } if (ds.Tables[0].Rows[0]["parentGUID"] != null && ds.Tables[0].Rows[0]["parentGUID"].ToString() != "") { model.parentGUID = new Guid(ds.Tables[0].Rows[0]["parentGUID"].ToString()); } if (ds.Tables[0].Rows[0]["createDate"] != null && ds.Tables[0].Rows[0]["createDate"].ToString() != "") { model.createDate = DateTime.Parse(ds.Tables[0].Rows[0]["createDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CustomerService.Model.CustomerGroup GetModel(Guid GUID) { SqlParameter[] parameters = { new SqlParameter("@GUID", SqlDbType.UniqueIdentifier,16)}; parameters[0].Value = GUID; CustomerService.Model.CustomerGroup model=new CustomerService.Model.CustomerGroup(); DataSet ds= DbHelperSQL.RunProcedure("T_CustomerGroup_GetModel",parameters,"ds"); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["GUID"]!=null && ds.Tables[0].Rows[0]["GUID"].ToString()!="") { model.GUID=new Guid(ds.Tables[0].Rows[0]["GUID"].ToString()); } if(ds.Tables[0].Rows[0]["cName"]!=null && ds.Tables[0].Rows[0]["cName"].ToString()!="") { model.cName=ds.Tables[0].Rows[0]["cName"].ToString(); } if(ds.Tables[0].Rows[0]["parentGUID"]!=null && ds.Tables[0].Rows[0]["parentGUID"].ToString()!="") { model.parentGUID=new Guid(ds.Tables[0].Rows[0]["parentGUID"].ToString()); } if(ds.Tables[0].Rows[0]["createDate"]!=null && ds.Tables[0].Rows[0]["createDate"].ToString()!="") { model.createDate=DateTime.Parse(ds.Tables[0].Rows[0]["createDate"].ToString()); } return model; } else { return null; } }