/// <summary>
/// 初始化数据
/// </summary>
private void InitData()
{
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
//小区
cbArea.Items.Add(new Model.ComboBoxItem("请选择小区", 0));
cbBuild.Items.Add(new Model.ComboBoxItem("请选择楼栋", 0));
cbUnit.Items.Add(new Model.ComboBoxItem("请选择单元", 0));
cbRoom.Items.Add(new Model.ComboBoxItem("请选择房间", 0));
cbArea.SelectedIndex = 0;
cbBuild.SelectedIndex = 0;
cbUnit.SelectedIndex = 0;
cbRoom.SelectedIndex = 0;
IList <Model.Building> lsAll = objDAL.GetListByWhere(-1, 100000, "1=1");
//小区
IList <Model.Building> listArea = lsAll.Where(s => s.FID == 0).ToList();
if (!(listArea == null || listArea.Count <= 0))
{
foreach (Model.Building model in listArea)
{
cbArea.Items.Add(new Model.ComboBoxItem(string.Format("{0}|{1}", model.BName.Replace("|", ""), FormatBuildingCode(model.Code)), model.ID));
}
}
}
/// <summary>
/// 绑定数据到列表
/// </summary>
/// <param name="selNum">数据条数</param>
/// <param name="sqlWhereAndOrderBy">条件</param>
protected override void BindLVData(int selNum = 0, string sqlWhereAndOrderBy = null)
{
this.lvContent.BeginUpdate();
this.lvContent.Items.Clear();
try
{
if (selNum <= 0)
{
selNum = this.DefaultPageSize;
}
if (string.IsNullOrEmpty(sqlWhereAndOrderBy) || sqlWhereAndOrderBy.Equals(""))
{
sqlWhereAndOrderBy = "1=1";
}
this.CurrentSqlWhere = sqlWhereAndOrderBy;
IList <Building> listData = null;
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
listData = objDAL.GetListByWhere(this._DataType, selNum, sqlWhereAndOrderBy);
if (!(listData == null || listData.Count <= 0))
{
foreach (Building model in listData)
{
ListViewItem item = null;
//当前模块
switch (this._DataType)
{
case 0: //小区
//序号,50|小区名称,100|小区编码,80|小区序列号,130|管理员姓名,100|管理员联系电话,110
item = new ListViewItem(new string[] { Convert.ToString(this.lvContent.Items.Count + 1), model.BName, FormatBuildingCode(model.Code), model.BuildingSerialNo, model.Contact, model.Tel });
break;
case 1: //栋
//序号,50|楼栋名称,100|楼栋编码,80|所在小区,100|管理员姓名,100|管理员联系电话,110
item = new ListViewItem(new string[] { Convert.ToString(this.lvContent.Items.Count + 1), model.BName, FormatBuildingCode(model.Code), model.FatherInfo.BName, model.Contact, model.Tel });
break;
case 2: //单元
//序号,50|单元名称,100|单元编码,80|所在楼栋,100|所在小区,120|管理员姓名,100|管理员联系电话,110
item = new ListViewItem(new string[] { Convert.ToString(this.lvContent.Items.Count + 1), model.BName, FormatBuildingCode(model.Code), model.FatherInfo.BName, model.FatherInfo.FatherInfo.BName, model.Contact, model.Tel });
break;
case 3: //房间
//序号,50|房间名称,100|房间编码,80|所在单元,100|所在楼栋,100|所在小区,120|管理员姓名,100|管理员联系电话,110
item = new ListViewItem(new string[] { Convert.ToString(this.lvContent.Items.Count + 1), model.BName, FormatRoomCode(model.Code), model.FatherInfo.BName, model.FatherInfo.FatherInfo.BName, model.FatherInfo.FatherInfo.FatherInfo.BName, model.Contact, model.Tel });
break;
}
item.Tag = model;
item.Font = new Font("宋体", 9, FontStyle.Regular);
this.lvContent.Items.Add(item);
}
}
}
catch (Exception)
{
}
this.lvContent.EndUpdate();
}
private void CbCombo_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.IfFormLoadOk)
{
ComboBox cbCurrent = (ComboBox)sender;
string strCbName = cbCurrent.Name;
int iCurrentID = Convert.ToInt32(((Model.ComboBoxItem)cbCurrent.SelectedItem).Value);
if (iCurrentID > 0)
{
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
IList <Model.Building> lsAll = objDAL.GetListByWhere(-1, 100000, "1=1");
IList <Model.Building> listBuilding = lsAll.Where(s => s.FID == iCurrentID).ToList();
if (string.Compare(strCbName, "cbArea", true) == 0)
{
//楼栋
cbBuild.Items.Clear();
cbBuild.Items.Add(new Model.ComboBoxItem("请选择楼栋", 0));
//初始化楼栋
if (!(listBuilding == null || listBuilding.Count <= 0))
{
foreach (Model.Building model in listBuilding)
{
cbBuild.Items.Add(new Model.ComboBoxItem(string.Format("{0}", model.BName), model.ID));
}
}
cbBuild.SelectedIndex = 0;
}
else if (string.Compare(strCbName, "cbBuild", true) == 0)
{
//单元
cbUnit.Items.Clear();
cbUnit.Items.Add(new Model.ComboBoxItem("请选择单元", 0));
//初始化单元
if (!(listBuilding == null || listBuilding.Count <= 0))
{
foreach (Model.Building model in listBuilding)
{
cbUnit.Items.Add(new Model.ComboBoxItem(string.Format("{0}", model.BName), model.ID));
}
}
cbUnit.SelectedIndex = 0;
}
}
}
}
/// <summary>
/// 绑定数据到树
/// </summary>
/// <param name="objTV">树控件</param>
/// <param name="iDeep">树的深度,0:只输出到小区；1：只输出到楼栋；2：只输出到单元；3：只输出到房间；</param>
/// <param name="bIfShowUnGroup">是否显示分类</param>
protected void BindBuildTreeData(TreeView objTV, int iDeep, bool bIfShowUnGroup = false)
{
//objTV.SelectedNode = null;
TreeNode root = CreateTreeNode(new Model.NodeData(-1, Config.SoftName, 0));
if (bIfShowUnGroup)
{
root.Nodes.Add(CreateTreeNode(new NodeData(20, "未归属卡片", 0)));
}
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
IList <Model.Building> lsAll = objDAL.GetListByWhere(-1, this.DefaultPageSize, "1=1");
if (!(lsAll == null || lsAll.Count <= 0))
{
BuildTree(root.Nodes, 0, lsAll, iDeep, bIfShowUnGroup);
}
objTV.BeginUpdate();
objTV.Nodes.Clear();
objTV.Nodes.Add(root);
objTV.EndUpdate();
}
private void InitData()
{
this.lvContent.BeginUpdate();
this.lvContent.Items.Clear();
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
IList <Building> listData = objDAL.GetListByWhere(0, this.DefaultPageSize, "1=1");
if (!(listData == null || listData.Count <= 0))
{
foreach (Building model in listData)
{
ListViewItem item = new ListViewItem(new string[] { Convert.ToString(lvContent.Items.Count + 1), model.BName, FormatBuildingCode(model.Code), model.BuildingSerialNo })
{
Tag = model,
Font = new Font("宋体", 9, FontStyle.Regular)
};
this.lvContent.Items.Add(item);
}
}
this.lvContent.EndUpdate();
}
/// <summary>
/// 初始化数据
/// </summary>
private void InitData()
{
int iAreaID, iBuildID, iUnitID;
iAreaID = iBuildID = iUnitID = 0;
IDAL.IBuilding objDAL = DALFactory.DALFactory.Building();
//小区
cbArea.Items.Add(new Model.ComboBoxItem("请选择小区", 0));
cbBuild.Items.Add(new Model.ComboBoxItem("请选择楼栋", 0));
cbUnit.Items.Add(new Model.ComboBoxItem("请选择单元", 0));
cbArea.SelectedIndex = 0;
cbBuild.SelectedIndex = 0;
cbUnit.SelectedIndex = 0;
if (this._CurrentAction.Equals(EAction.Edit))
{
Model.Building objModel = objDAL.GetModel(this._DataType, this._CurrentID);
if (objModel != null)
{
txtName.Text = objModel.BName;
txtCode.Text = objModel.Flag.Equals(3) ? FormatRoomCode(objModel.Code) : FormatBuildingCode(objModel.Code);
txtContact.Text = objModel.Contact;
txtTel.Text = objModel.Tel;
txtSerialNo.Text = objModel.BuildingSerialNo;
switch (this._DataType)
{
case 1:
iAreaID = objModel.FID;
break;
case 2:
iBuildID = objModel.FID;
iAreaID = objModel.FatherInfo.FID;
break;
case 3:
iUnitID = objModel.FID;
iBuildID = objModel.FatherInfo.FID;
iAreaID = objModel.FatherInfo.FatherInfo.FID;
break;
}
//记录旧数据
this._OldName = objModel.BName;
this._OldCode = objModel.Code;
this._OldAreaID = iAreaID;
this._OldBuildID = iBuildID;
this._OldUnitID = iUnitID;
}
}
else
{
Model.Building objModel = null;
switch (this._DataType)
{
case 1:
iAreaID = this._CurrentParentID;
break;
case 2:
iBuildID = this._CurrentParentID;
objModel = objDAL.GetModel(this._DataType - 1, iBuildID);
if (objModel != null)
{
iAreaID = objModel.FID;
}
break;
case 3:
iUnitID = this._CurrentParentID;
objModel = objDAL.GetModel(this._DataType - 1, iUnitID);
if (objModel != null)
{
iBuildID = objModel.FID;
iAreaID = objModel.FatherInfo.FID;
}
break;
}
}
if (iAreaID > 0 || (this._DataType >= 1 && this._DataType <= 3))
{
IList <Model.Building> lsAll = objDAL.GetListByWhere(-1, 100000, "1=1");
int iCount = 0;
int iSelectIndex = 0;
IList <Model.Building> listArea = lsAll.Where(s => s.FID == 0).ToList();
if (!(listArea == null || listArea.Count <= 0))
{
foreach (Model.Building model in listArea)
{
iCount++;
if (model.ID.Equals(iAreaID))
{
iSelectIndex = iCount;
}
cbArea.Items.Add(new Model.ComboBoxItem(model.BName, model.ID));
}
cbArea.SelectedIndex = iSelectIndex;
//新增时如果小区只有一个就自动选择那个小区
if (this._CurrentAction.Equals(EAction.Create) && iSelectIndex == 0 && listArea.Count == 1)
{
cbArea.SelectedIndex = 1;
iAreaID = listArea[0].ID;
}
}
//新增时如果只有一个楼栋
if (this._CurrentAction.Equals(EAction.Create) && iAreaID > 0 && iBuildID == 0)
{
IList <Model.Building> listBuild = lsAll.Where(s => s.FID == iAreaID).ToList();
if (!(listBuild == null || listBuild.Count <= 0))
{
if (listBuild.Count == 1)
{
iBuildID = listBuild[0].ID;
}
}
}
if (iAreaID > 0)
{
iCount = 0;
iSelectIndex = 0;
IList <Model.Building> listBuild = lsAll.Where(s => s.FID == iAreaID).ToList();
if (!(listBuild == null || listBuild.Count <= 0))
{
foreach (Model.Building model in listBuild)
{
iCount++;
if (model.ID.Equals(iBuildID))
{
iSelectIndex = iCount;
}
cbBuild.Items.Add(new Model.ComboBoxItem(model.BName, model.ID));
}
cbBuild.SelectedIndex = iSelectIndex;
}
//新增时如果只有一个单元
if (this._CurrentAction.Equals(EAction.Create) && iBuildID > 0 && iUnitID == 0)
{
IList <Model.Building> listUnit = lsAll.Where(s => s.FID == iBuildID).ToList();
if (!(listUnit == null || listUnit.Count <= 0))
{
if (listUnit.Count == 1)
{
iUnitID = listUnit[0].ID;
}
}
}
if (iBuildID > 0)
{
iCount = 0;
iSelectIndex = 0;
IList <Model.Building> listUnit = lsAll.Where(s => s.FID == iBuildID).ToList();
if (!(listUnit == null || listUnit.Count <= 0))
{
foreach (Model.Building model in listUnit)
{
iCount++;
if (model.ID.Equals(iUnitID))
{
iSelectIndex = iCount;
}
cbUnit.Items.Add(new Model.ComboBoxItem(model.BName, model.ID));
}
cbUnit.SelectedIndex = iSelectIndex;
}
}
}
}
}
