/// <summary>
/// 获取有常用城市的省份列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.Province> GetHasFavCityProvince(int companyId)
{
string sql = string.Format("select distinct p.* from tbl_CompanyProvince p inner join tbl_CompanyCity c"
+ " on p.Id = c.ProvinceId where c.IsFav = '1' and p.CompanyId = {0} "
+ " order by p.IssueTime desc", companyId);
IList <EyouSoft.Model.CompanyStructure.Province> lsProvince = new List <EyouSoft.Model.CompanyStructure.Province>();
EyouSoft.Model.CompanyStructure.Province model = null;
DbCommand cmd = this._db.GetSqlStringCommand(sql);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
while (rdr.Read())
{
model = new EyouSoft.Model.CompanyStructure.Province();
model.Id = rdr.GetInt32(rdr.GetOrdinal("Id"));
model.ProvinceName = rdr.GetString(rdr.GetOrdinal("ProvinceName"));
model.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
model.OperatorId = rdr.IsDBNull(rdr.GetOrdinal("OperatorId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
lsProvince.Add(model);
}
}
return(lsProvince);
}
/// <summary>
/// 获取指定公司的省份集合
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <returns>省份集合</returns>
public IList <EyouSoft.Model.CompanyStructure.Province> GetList(int CompanyId)
{
IList <EyouSoft.Model.CompanyStructure.Province> lsProvince = new List <EyouSoft.Model.CompanyStructure.Province>();
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())
{
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"));
lsProvince.Add(provinceModel);
}
}
return(lsProvince);
}
/// <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.Province model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_UPDATE_PROVINC);
this._db.AddInParameter(cmd, "ProvinceName", DbType.String, model.ProvinceName);
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 Update(EyouSoft.Model.CompanyStructure.Province 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 Add(EyouSoft.Model.CompanyStructure.Province model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_PROVINCE);
this._db.AddInParameter(cmd, "ProvinceName", DbType.String, model.ProvinceName);
this._db.AddInParameter(cmd, "CompanyId", DbType.String, model.CompanyId);
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>
/// 修改:田想兵 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="Id">主键编号</param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.Province GetModel(int Id)
{
EyouSoft.Model.CompanyStructure.Province provinceModel = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_PROVINC);
this._db.AddInParameter(cmd, "Id", DbType.Int32, Id);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
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"));
}
}
return(provinceModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_基础设置_城市管理栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_基础设置_城市管理栏目, false);
return;
}
provinceName = Utils.GetFormValue("txtProvinceName"); //获取省份
pId = Utils.GetInt(Utils.GetQueryStringValue("proId")); //省份Id
string method = Utils.GetFormValue("hidMethod"); //获取当前操作(保存/继续)
string showMess = "数据保存成功"; //提示消息
EyouSoft.Model.CompanyStructure.Province proModel = null;
EyouSoft.BLL.CompanyStructure.Province proBll = new EyouSoft.BLL.CompanyStructure.Province();//初始化bll
//当前操作为空则初始化
if (method == "")
{
string isExist = Utils.GetFormValue("isExist");//验证城市是否已经存在
if (isExist == "isExist")
{
string pNameE = Utils.GetFormValue("pName");//获取城市名
int id = Utils.GetInt(Utils.GetFormValue("pId"));
bool isExistResult = proBll.IsExists(pNameE, CurrentUserCompanyID, id);
Utils.ResponseMeg(isExistResult, "");
return;
}
#region 初次加载数据
if (pId != 0)
{
proModel = proBll.GetModel(pId);//获取省份实体
if (proModel != null)
{
provinceName = proModel.ProvinceName;
}
return;
}
#endregion
}
else
{
#region 保存
if (provinceName == "")
{
MessageBox.Show(this, "省份不为空！");
return;
}
proModel = new EyouSoft.Model.CompanyStructure.Province();
proModel.ProvinceName = provinceName;
proModel.CompanyId = CurrentUserCompanyID;
proModel.IssueTime = DateTime.Now;
bool result = false;
if (pId != 0)
{
proModel.Id = pId;
result = proBll.Update(proModel);//更新省份
}
else
{
result = proBll.Add(proModel);//添加省份
}
if (!result)
{
showMess = "数据保存失败！";
}
//继续添加则刷新页面,否则关闭当前窗口
if (method == "continue")//继续添加重定向当前页，否则关闭当前窗口
{
MessageBox.ShowAndRedirect(this, showMess, "ProvinceEdit.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
}
}
