protected void UpadateDepart()
{
if (!IsCompanyCheck)
{
Utils.ResponseMeg(false, "对不起,你尚未审核通过!");
return;
}
string departId = Utils.GetQueryStringValue("departid");
string departName = Utils.InputText(Request.QueryString["departname"], 20);
if (departId == "" || departName == "")
{
Utils.ResponseMegNoComplete();
}
else
{
if (companyDepartBll.Exists(SiteUserInfo.CompanyID, departName, departId))
{
Utils.ResponseMeg(false, "改部门已经存在!");
return;
}
companyDepartModel = companyDepartBll.GetModel(departId);
companyDepartModel.DepartName = departName;
companyDepartModel.OperatorID = SiteUserInfo.ID;
if (companyDepartBll.Update(companyDepartModel))
{
Utils.ResponseMeg(true, "修改成功!");
}
else
{
Utils.ResponseMegError();
}
}
}
/// <summary>
/// 修改一个部门信息
/// </summary>
/// <param name="model">部门实体信息</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Update(EyouSoft.Model.CompanyStructure.CompanyDepartment model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_UPDATE_CompanyDepartment);
this._database.AddInParameter(dc, "DepartName", DbType.String, model.DepartName);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 修改一个部门信息
/// </summary>
/// <param name="model">公司部门实体</param>
/// <returns>false:失败 true:成功</returns>
public bool Update(EyouSoft.Model.CompanyStructure.CompanyDepartment model)
{
if (model == null)
{
return(false);
}
return(dal.Update(model));
}
/// <summary>
/// 添加一个部门
/// </summary>
/// <param name="model">部门实体信息</param>
/// <returns>false:失败 true:成功</returns>
public virtual bool Add(EyouSoft.Model.CompanyStructure.CompanyDepartment model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_INSERT_CompanyDepartment);
this._database.AddInParameter(dc, "ID", DbType.String, Guid.NewGuid().ToString());
this._database.AddInParameter(dc, "CompanyID", DbType.String, model.CompanyID);
this._database.AddInParameter(dc, "OperatorID", DbType.String, model.OperatorID);
this._database.AddInParameter(dc, "DepartName", DbType.String, model.DepartName);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 获取一个部门信息实体
/// </summary>
/// <param name="id">部门编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.CompanyStructure.CompanyDepartment GetModel(string id)
{
EyouSoft.Model.CompanyStructure.CompanyDepartment model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_SELECT_CompanyDepartmentModel);
this._database.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, id);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.CompanyStructure.CompanyDepartment();
model.CompanyID = dr.GetString(dr.GetOrdinal("CompanyID"));
model.DepartName = dr.GetString(dr.GetOrdinal("DepartName"));
model.ID = dr.GetString(dr.GetOrdinal("ID"));
model.OperatorID = dr.GetString(dr.GetOrdinal("OperatorID"));
}
}
return(model);
}
/// <summary>
/// 根据公司编号获取部门列表
/// </summary>
/// <param name="companyId">公司ID</param>
/// <param name="pageSize">分页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CompanyStructure.CompanyDepartment> GetList(string companyId, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.CompanyStructure.CompanyDepartment> list = new List <EyouSoft.Model.CompanyStructure.CompanyDepartment>();
EyouSoft.Model.CompanyStructure.CompanyDepartment model = null;
string tableName = "tbl_CompanyDepartment";
string fields = "id,DepartName,IssueTime";
string primaryKey = "ID";
string orderByString = "IssueTime DESC";
string strWhere = string.Format(" companyid='{0}' ", companyId);
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere, orderByString))
{
while (dr.Read())
{
model = new EyouSoft.Model.CompanyStructure.CompanyDepartment();
model.DepartName = dr[1].ToString();
model.ID = dr[0].ToString();
list.Add(model);
model = null;
}
}
return(list);
}
protected void AddDepart()
{
if (!IsCompanyCheck)
{
Utils.ResponseMeg(false, "对不起,你尚未审核通过!");
return;
}
string departName = Utils.InputText(Request.QueryString["departname"], 20);
if (departName == "")
{
Utils.ResponseMegNoComplete();
}
else
{
if (companyDepartBll.Exists(SiteUserInfo.CompanyID, departName, ""))
{
Utils.ResponseMeg(false, "该部门已经存在!");
return;
}
companyDepartModel = new EyouSoft.Model.CompanyStructure.CompanyDepartment();
companyDepartModel.CompanyID = SiteUserInfo.CompanyID;
companyDepartModel.DepartName = departName;
companyDepartModel.OperatorID = SiteUserInfo.ID;
if (companyDepartBll.Add(companyDepartModel))
{
string departId = companyDepartBll.GetList(SiteUserInfo.CompanyID, 1, 1, ref recordCount)[0].ID;
Utils.ResponseMeg(true, departId);
}
else
{
Utils.ResponseMegError();
}
}
}
