/// <summary>
/// 得到籍贯
/// </summary>
public string GetProvinceAndCity(string Birthplace)
{
string returnStr = "";
string[] arrBirthplace = Birthplace.Split(',');
if (arrBirthplace != null && arrBirthplace.Length > 1)
{
EyouSoft.BLL.CompanyStructure.City bllCity = new EyouSoft.BLL.CompanyStructure.City();
EyouSoft.BLL.CompanyStructure.Province bllProvince = new EyouSoft.BLL.CompanyStructure.Province();
if (arrBirthplace[0] != "")
{
EyouSoft.Model.CompanyStructure.Province modelProvince = bllProvince.GetModel(Utils.GetInt(arrBirthplace[0]));
if (modelProvince != null)
{
returnStr += modelProvince.ProvinceName + "省";
}
}
if (arrBirthplace[1] != "")
{
EyouSoft.Model.CompanyStructure.City modelCity = bllCity.GetModel(Utils.GetInt(arrBirthplace[1]));
if (modelCity != null)
{
returnStr += modelCity.CityName + "市";
}
}
}
return(returnStr);
}
/// <summary>
/// 修改城市
/// </summary>
/// <param name="model">城市实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CompanyStructure.City model)
{
bool result = false;
result = Dal.Update(model);
handleLogsBll.Add(AddLogs("修改", result));
return(result);
}
/// <summary>
/// 修改城市
/// </summary>
/// <param name="model">城市实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.CompanyStructure.City model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_UPDATE_CITY);
this._db.AddInParameter(cmd, "ProvinceId", DbType.Int32, model.ProvinceId);
this._db.AddInParameter(cmd, "CityName", DbType.String, model.CityName);
this._db.AddInParameter(cmd, "Id", DbType.Int32, model.Id);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加城市
/// </summary>
/// <param name="model">城市实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Add(EyouSoft.Model.CompanyStructure.City model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_CITY);
this._db.AddInParameter(cmd, "ProvinceId", DbType.String, model.ProvinceId);
this._db.AddInParameter(cmd, "CityName", DbType.String, model.CityName);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, model.CompanyId);
this._db.AddInParameter(cmd, "IsFav", DbType.Boolean, model.IsFav);
this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, model.OperatorId);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 获取某个公司所有省份的信息包括城市
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.Province> GetProvinceInfo(int CompanyId)
{
IList <EyouSoft.Model.CompanyStructure.Province> lsProvince = new List <EyouSoft.Model.CompanyStructure.Province>();
IList <EyouSoft.Model.CompanyStructure.City> lsCity = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_GetList);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, CompanyId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
EyouSoft.Model.CompanyStructure.Province provinceModel = null;
while (rdr.Read())
{
//a.Id as ProvinceId,a.ProvinceName,b.Id as CityId,b.CityName,b.IsFav,a.CompanyId,a.OperatorId,a.IssueTime
provinceModel = new EyouSoft.Model.CompanyStructure.Province();
provinceModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
provinceModel.ProvinceName = rdr.GetString(rdr.GetOrdinal("ProvinceName"));
provinceModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
provinceModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
provinceModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
DbCommand cmd1 = this._db.GetSqlStringCommand(SQL_GetCityByPid);
this._db.AddInParameter(cmd1, "ProvinceId", DbType.Int32, provinceModel.Id);
using (IDataReader rdr1 = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd1, this._db))
{
lsCity = new List <EyouSoft.Model.CompanyStructure.City>();
EyouSoft.Model.CompanyStructure.City cityModel = null;
while (rdr1.Read())
{
cityModel = new EyouSoft.Model.CompanyStructure.City();
cityModel.Id = rdr1.GetInt32(rdr1.GetOrdinal("CityId"));
cityModel.CityName = rdr1.GetString(rdr1.GetOrdinal("CityName"));
cityModel.IsFav = rdr1.GetString(rdr1.GetOrdinal("IsFav")) == "1";
lsCity.Add(cityModel);
}
}
provinceModel.CityList = lsCity;
lsProvince.Add(provinceModel);
}
}
return(lsProvince);
}
/// <summary>
/// 获取城市集合
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="ProvinceId">省份编号</param>
/// <param name="IsFav">是否常用城市 =null返回全部</param>
/// <returns>城市集合</returns>
public IList <EyouSoft.Model.CompanyStructure.City> GetList(int CompanyId, int?ProvinceId, bool?IsFav)
{
if (CompanyId <= 0)
{
return(null);
}
IList <EyouSoft.Model.CompanyStructure.City> lsCity = new List <EyouSoft.Model.CompanyStructure.City>();
StringBuilder strSql = new StringBuilder(" select Id,ProvinceId,CityName,CompanyId,IsFav,OperatorId,IssueTime from tbl_CompanyCity where CompanyId=@CompanyId ");
if (ProvinceId.HasValue && ProvinceId.Value > 0)
{
strSql.AppendFormat(" and ProvinceId = {0} ", ProvinceId);
}
if (IsFav.HasValue)
{
strSql.AppendFormat(" and IsFav = {0} ", IsFav.Value ? "1" : "0");
}
DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(dc, "CompanyId", DbType.Int32, CompanyId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
EyouSoft.Model.CompanyStructure.City cityModel = null;
while (rdr.Read())
{
cityModel = new EyouSoft.Model.CompanyStructure.City();
cityModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
cityModel.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
cityModel.CityName = rdr.GetString(rdr.GetOrdinal("CityName"));
cityModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
cityModel.IsFav = Convert.ToBoolean(rdr.GetOrdinal("IsFav"));
cityModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
cityModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
lsCity.Add(cityModel);
}
}
return(lsCity);
}
/// <summary>
/// 获得常用城市
/// </summary>
/// 修改:田想兵 2011.5.24
/// 修改：弹出选择
/// <param name="selectIndex"></param>
protected void CityDataInit(int provinceId, int cityId)
{
if (provinceId != 0)
{
EyouSoft.BLL.CompanyStructure.Province pBll = new EyouSoft.BLL.CompanyStructure.Province();
EyouSoft.Model.CompanyStructure.Province pModel = pBll.GetModel(provinceId);
if (pModel != null)
{
lt_province.Text = pModel.ProvinceName;
if (cityId != 0)
{
EyouSoft.BLL.CompanyStructure.City cBll = new EyouSoft.BLL.CompanyStructure.City();
EyouSoft.Model.CompanyStructure.City cModel = cBll.GetModel(cityId);
//if (cModel != null)
//{
// lt_city.Text = cModel.CityName;
//}
}
}
}
}
/// <summary>
/// 获取城市集合
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="ProvinceId">省份编号</param>
/// <param name="IsFav">是否常用城市 =null返回全部</param>
/// <returns>城市集合</returns>
public IList <EyouSoft.Model.CompanyStructure.City> GetList(int CompanyId, int ProvinceId, bool?IsFav)
{
IList <EyouSoft.Model.CompanyStructure.City> lsCity = new List <EyouSoft.Model.CompanyStructure.City>();
DbCommand cmd = null;
if (IsFav == null)
{
cmd = this._db.GetSqlStringCommand(SQL_GetList);
}
else
{
cmd = this._db.GetSqlStringCommand(SQL_GetList + " and IsFav=@IsFav ");
this._db.AddInParameter(cmd, "IsFav", DbType.String, IsFav == true ? "1" : "0");
}
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, CompanyId);
this._db.AddInParameter(cmd, "ProvinceId", DbType.Int32, ProvinceId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
EyouSoft.Model.CompanyStructure.City cityModel = null;
while (rdr.Read())
{
cityModel = new EyouSoft.Model.CompanyStructure.City();
cityModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
cityModel.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
cityModel.CityName = rdr.GetString(rdr.GetOrdinal("CityName"));
cityModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
cityModel.IsFav = Convert.ToBoolean(rdr.GetOrdinal("IsFav"));
cityModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
cityModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
lsCity.Add(cityModel);
}
}
return(lsCity);
}
/// <summary>
/// 获取城市实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.City GetModel(int Id)
{
EyouSoft.Model.CompanyStructure.City cityModel = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_CITY);
this._db.AddInParameter(cmd, "Id", DbType.Int32, Id);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
cityModel = new EyouSoft.Model.CompanyStructure.City();
cityModel.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
cityModel.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
cityModel.CityName = rdr.GetString(rdr.GetOrdinal("CityName"));
cityModel.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
cityModel.IsFav = Convert.ToBoolean(rdr.GetOrdinal("IsFav"));
cityModel.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
cityModel.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
}
}
return(cityModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_基础设置_城市管理栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_基础设置_城市管理栏目, false);
return;
}
int proId = Utils.GetInt(Utils.GetFormValue(selProvince.UniqueID)); //获取省份Id
cityName = Utils.GetFormValue("txtCityName"); //获取城市名
cId = Utils.GetInt(Utils.GetQueryStringValue("cId")); //城市Id
string method = Utils.GetFormValue("hidMethod"); //获取当前操作(保存/继续)
string showMess = "数据保存成功！"; //提示消息
EyouSoft.Model.CompanyStructure.City cityModel = null;
EyouSoft.BLL.CompanyStructure.City cityBll = new EyouSoft.BLL.CompanyStructure.City();//初始化bll
//城市Id不为空则添加,否则视为保存
if (method == "")
{
string isExist = Utils.GetFormValue("isExist");//验证城市是否已经存在
if (isExist == "isExist")
{
string cityNameE = Utils.GetFormValue("cityName");//获取城市名
int id = Utils.GetInt(Utils.GetFormValue("cityId"));
bool isExistResult = cityBll.IsExists(cityNameE, CurrentUserCompanyID, id);
Utils.ResponseMeg(isExistResult, "");
return;
}
#region 初次加载数据
//绑定省份下拉框
IList <EyouSoft.Model.CompanyStructure.Province> proList = new EyouSoft.BLL.CompanyStructure.Province().GetList(CurrentUserCompanyID);
if (proList != null && proList.Count > 0)
{
selProvince.DataTextField = "ProvinceName";
selProvince.DataValueField = "Id";
selProvince.DataSource = proList;
selProvince.DataBind();
}
selProvince.Items.Insert(0, new ListItem("请选择", ""));
if (cId != 0)//初始化城市信息
{
cityModel = cityBll.GetModel(cId);
if (cityModel != null)
{
cityName = cityModel.CityName;
selProvince.Value = cityModel.ProvinceId.ToString();
}
return;
}
#endregion
}
else
{
#region 保存数据
if (cityName == "")
{
MessageBox.Show(this, "城市名称不为空！");
return;
}
bool result = false;
cityModel = new EyouSoft.Model.CompanyStructure.City();
cityModel.CityName = cityName;
cityModel.OperatorId = SiteUserInfo.ID;
cityModel.CompanyId = CurrentUserCompanyID;
cityModel.ProvinceId = proId;
cityModel.IssueTime = DateTime.Now;
if (cId != 0)
{ //修改城市
if (cityModel != null)
{
cityModel.Id = cId;
result = cityBll.Update(cityModel);
}
}
else
{ //添加城市
result = cityBll.Add(cityModel);
}
if (!result)
{
showMess = "数据保存失败！";
}
//继续添加则刷新页面,否则关闭当前窗口
if (method == "continue")
{
MessageBox.ShowAndRedirect(this, showMess, "CityEdit.aspx");
}
else
{
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.location='/systemset/basicinfo/CityManage.aspx';window.parent.Boxy.getIframeDialog('{1}').hide();", showMess, Utils.GetQueryStringValue("iframeId")));
}
#endregion
}
}
