/// <summary> /// 增加一条数据 /// </summary> public int Add(LPWeb.Model.Groups model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Groups("); strSql.Append("GroupName,OrganizationType,Enabled)"); strSql.Append(" values ("); strSql.Append("@GroupName,@OrganizationType,@Enabled)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@GroupName", SqlDbType.NVarChar, 50), new SqlParameter("@OrganizationType", SqlDbType.NVarChar, 50), new SqlParameter("@Enabled", SqlDbType.Bit, 1) }; parameters[0].Value = model.GroupName; parameters[1].Value = model.OrganizationType; parameters[2].Value = model.Enabled; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// get group object of Company /// </summary> /// <returns></returns> public Model.Groups GetCompanyGroup() { string strSql = "SELECT * FROM dbo.Groups WHERE CompanyID IS NOT NULL AND OrganizationType='Company'"; DataTable dtCompany = DbHelperSQL.ExecuteDataTable(strSql); LPWeb.Model.Groups groupCompany = null; if (null != dtCompany && dtCompany.Rows.Count > 0) { groupCompany = new Model.Groups(); if (dtCompany.Rows[0]["GroupId"].ToString() != "") { groupCompany.GroupId = int.Parse(dtCompany.Rows[0]["GroupId"].ToString()); } groupCompany.GroupName = dtCompany.Rows[0]["GroupId"].ToString(); if (dtCompany.Rows[0]["Enabled"].ToString() != "") { if ((dtCompany.Rows[0]["Enabled"].ToString() == "1") || (dtCompany.Rows[0]["Enabled"].ToString().ToLower() == "true")) { groupCompany.Enabled = true; } else { groupCompany.Enabled = false; } } groupCompany.OrganizationType = dtCompany.Rows[0]["OrganizationType"].ToString(); } return(groupCompany); }
/// <summary> /// 得到一个对象实体 /// </summary> public LPWeb.Model.Groups GetModel(int GroupId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 GroupId,GroupName,OrganizationType,Enabled from Groups "); strSql.Append(" where GroupId=@GroupId "); SqlParameter[] parameters = { new SqlParameter("@GroupId", SqlDbType.Int, 4) }; parameters[0].Value = GroupId; LPWeb.Model.Groups model = new LPWeb.Model.Groups(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["GroupId"].ToString() != "") { model.GroupId = int.Parse(ds.Tables[0].Rows[0]["GroupId"].ToString()); } model.GroupName = ds.Tables[0].Rows[0]["GroupName"].ToString(); model.OrganizationType = ds.Tables[0].Rows[0]["OrganizationType"].ToString(); if (ds.Tables[0].Rows[0]["Enabled"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Enabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["Enabled"].ToString().ToLower() == "true")) { model.Enabled = true; } else { model.Enabled = false; } } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LPWeb.Model.Groups model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Groups set "); strSql.Append("GroupId=@GroupId,"); strSql.Append("GroupName=@GroupName,"); strSql.Append("OrganizationType=@OrganizationType,"); strSql.Append("Enabled=@Enabled"); strSql.Append(" where GroupId=@GroupId "); SqlParameter[] parameters = { new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@GroupName", SqlDbType.NVarChar, 50), new SqlParameter("@OrganizationType", SqlDbType.NVarChar, 50), new SqlParameter("@Enabled", SqlDbType.Bit, 1) }; parameters[0].Value = model.GroupId; parameters[1].Value = model.GroupName; parameters[2].Value = model.OrganizationType; parameters[3].Value = model.Enabled; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }