//修改
public static void UpdateWyInfos(WyInfos tNew)
{
ISession session = NHibernateHelper.OpenSession();
try
{
ITransaction tx = session.BeginTransaction();
WyInfos tModify = session.Get <WyInfos>(tNew.WyID);
tModify.WyName = tNew.WyName;
tModify.JZArea = tNew.JZArea;
tModify.TNArea = tNew.TNArea;
tModify.GTArea = tNew.GTArea;
tModify.OwnerName = tNew.OwnerName;
tModify.OwnerDetail = tNew.OwnerDetail;
tModify.UNIT_No = tNew.UNIT_No;
tModify.FLOOR_No = tNew.FLOOR_No;
tModify.ROOM_No = tNew.ROOM_No;
tModify.CustomerID = tNew.CustomerID;
tx.Commit();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
}
session.Close();
}
//将DataTable数据填充到数据库表中
public static void FillWyInfos(DataTable tDt)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
DataRow[] drs;
drs = tDt.Select("1=1");
for (int i = 0; i < drs.Length; i++)
{
WyInfos tNew = new WyInfos();
tNew.WyName = drs[i]["WyName"].ToString();
tNew.JZArea = Convert.ToDecimal(drs[i]["JZArea"].ToString());
tNew.TNArea = Convert.ToDecimal(drs[i]["TNArea"].ToString());
tNew.GTArea = Convert.ToDecimal(drs[i]["GTArea"].ToString());
tNew.OwnerName = drs[i]["OwnerName"].ToString();
tNew.OwnerDetail = drs[i]["OwnerDetail"].ToString();
tNew.UNIT_No = Convert.ToInt32(drs[i]["UNIT_No"].ToString());
tNew.FLOOR_No = Convert.ToInt32(drs[i]["FLOOR_No"].ToString());
tNew.ROOM_No = Convert.ToInt32(drs[i]["ROOM_No"].ToString());
session.Save(tNew);
}
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//删除
public static void DelWyInfo(int i_WyID)
{
//ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
ISession session = NHibernateHelper.OpenSession();
ITransaction tx = session.BeginTransaction();
WyInfos toDelete = session.Get <WyInfos>(i_WyID);
try
{
if (!CanDelWyInfo(i_WyID))
{
session.Close();
return;
}
session.Delete(toDelete);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//获取指定WyInfos
public static WyInfos GetWyInfo(int i_WyID)
{
ISession session = NHibernateHelper.OpenSession();
WyInfos tClass = new WyInfos();
try
{
tClass = session.Get <WyInfos>(i_WyID);
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
}
session.Close();
return(tClass);
}
//添加新的
public static void AddWyInfos(WyInfos tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
session.Save(tNew);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
void ButtonModifyClick(object sender, EventArgs e)
{
//修改
buttonNew.Enabled = false;
buttonModify.Enabled = false;
buttonDel.Enabled = false;
新增物业ToolStripMenuItem.Enabled = false;
修改物业ToolStripMenuItem.Enabled = false;
除物业ToolStripMenuItem.Enabled = false;
buttonSave.Enabled = true;
buttonCancel.Enabled = true;
//修改
if (dataGridView1.CurrentRow != null)
{
int i_WyID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["WyID"].Value.ToString());
WyInfos tWy = BLL.WyInfosBLL.GetWyInfo(i_WyID);
textBoxWyID.Text = tWy.WyID.ToString();
textBoxWyName.Text = tWy.WyName;
textBoxOwnerName.Text = tWy.OwnerName;
if (tWy.CustomerID != null)
{
comboBoxCustomerID.SelectedValue = tWy.CustomerID;
}
textBoxJZArea.Text = tWy.JZArea.ToString();
textBoxTNArea.Text = tWy.TNArea.ToString();
textBoxGTArea.Text = tWy.GTArea.ToString();
textBoxUNIT_No.Text = tWy.UNIT_No.ToString();
textBoxFLOOR_No.Text = tWy.FLOOR_No.ToString();
textBoxROOM_No.Text = tWy.ROOM_No.ToString();
textBoxOwnerDetail.Text = tWy.OwnerDetail;
//设定第一个输入的焦点
textBoxWyName.Focus();
}
}
//单独计费
public static void CalSingleJF(string s_PeriodNo, string s_CustomerID, Label lStatus)
{
//1.先查是否能计费，只要有1笔记录有【已收费】或【免收】
Object[] parms = new object[2];
parms[0] = new object();
parms[0] = Convert.ToInt32(s_CustomerID);
parms[1] = new object();
parms[1] = s_PeriodNo;
int i_rtn = Convert.ToInt32(SQLiteHelper.ExecuteScalar("SELECT Count(*) FROM ChargeDetail WHERE WyID IN (SELECT WyID FROM WyInfos WHERE CustomerID = @CustomerID ) AND (ChargeStatus = '已收费' OR ChargeStatus = '免收') AND PeriodNo = @PeriodNo ", parms));
if (i_rtn > 0)
{
MessageBox.Show("当前计费周期已经有收费完成，不能计费！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//2.将表计量的数据填充到ChargeDetail
lStatus.Text = "【计量表计费生成...】";
ISession session = NHibernateHelper.OpenSession();
ITransaction tx = session.BeginTransaction();
DataSet ds = new DataSet();
ds = SQLiteHelper.ExecuteDataSet("SELECT RID FROM MeterReading WHERE RStatus='计量计算' AND WyID IN (SELECT WyID FROM WyInfos WHERE CustomerID = @CustomerID ) AND PeriodNo = @PeriodNo ORDER BY MeterClass", parms);
DataRow[] drs;
drs = ds.Tables[0].Select("1=1");
try
{
for (int i = 0; i < drs.Length; i++)
{
int i_RID = Convert.ToInt32(drs[i]["RID"].ToString());
//检查ChargeDetail中是否有此表计量数据
MeterReading tMeterReading = session.Get <MeterReading>(i_RID);
lStatus.Text = "【计量表计费生成】:" + tMeterReading.MeterName;
Rates tRate = new Rates();
if (tMeterReading.RateID != null)
{
tRate = session.Get <Rates>(tMeterReading.RateID);
}
else
{
tRate = new Rates();
tRate.RateUnit = "";
tRate.RateValue = 0.0m;
}
IQuery query = session.CreateQuery("FROM ChargeDetail WHERE RID = ? AND PeriodNo = ?");
query.SetParameter(0, tMeterReading.RID);
query.SetParameter(1, s_PeriodNo);
IList <ChargeDetail> eList = query.List <ChargeDetail>();
if (eList.Count == 0)
{
int i_Share = 0;
//没有表计量记录
ChargeDetail tNew = new ChargeDetail();
tNew.PeriodNo = s_PeriodNo;
tNew.WyID = tMeterReading.WyID;
tNew.WyName = tMeterReading.WyName;
tNew.ChargeName = "表计量费用";
tNew.ChargeStatus = "已计费";
tNew.ChargeUnit = tRate.RateUnit;
if (tMeterReading.MeterCanSharing == 1)
{
//分摊量要计算
tNew.ChargeNum = Convert.ToDecimal(tMeterReading.TotalNum);
i_Share = Convert.ToInt32(tMeterReading.ShareNum);
}
else
{
//分摊量不计算
tNew.ChargeNum = Convert.ToDecimal(tMeterReading.TotalNum - tMeterReading.ShareNum);
i_Share = 0;
}
tNew.ChargePrice = Convert.ToDecimal(tMeterReading.RateValue);
tNew.ChargeYS = tNew.ChargeNum * tNew.ChargePrice;
tNew.ChargeSS = 0.0m;
tNew.ChargeDate = DateTime.Now;
tNew.RID = tMeterReading.RID;
tNew.Abstract = "表【" + tMeterReading.MeterName + "】计量:自 "
+ tMeterReading.StartReading.ToString()
+ " 至 " + tMeterReading.EndReading.ToString()
+ "止，调整【" + tMeterReading.AdjustNum.ToString()
+ "】，分摊【" + i_Share.ToString() + "】";
session.Save(tNew);
}
else
{
//有表计量记录
int i_Share = 0;
ChargeDetail tOld = session.Get <ChargeDetail>(eList[0].CDNo);
tOld.PeriodNo = s_PeriodNo;
tOld.WyID = tMeterReading.WyID;
tOld.WyName = tMeterReading.WyName;
tOld.ChargeName = "表计量费用";
tOld.ChargeStatus = "已计费";
tOld.ChargeUnit = tRate.RateUnit;
if (tMeterReading.MeterCanSharing == 1)
{
//分摊量要计算
tOld.ChargeNum = Convert.ToDecimal(tMeterReading.TotalNum);
i_Share = Convert.ToInt32(tMeterReading.ShareNum);
}
else
{
//分摊量不计算
tOld.ChargeNum = Convert.ToDecimal(tMeterReading.TotalNum - tMeterReading.ShareNum);
i_Share = 0;
}
tOld.ChargePrice = Convert.ToDecimal(tMeterReading.RateValue);
tOld.ChargeYS = tOld.ChargeNum * tOld.ChargePrice;
tOld.ChargeSS = 0.0m;
tOld.ChargeDate = DateTime.Now;
tOld.RID = tMeterReading.RID;
tOld.Abstract = "表【" + tMeterReading.MeterName + "】计量:自 "
+ tMeterReading.StartReading.ToString()
+ " 至 " + tMeterReading.EndReading.ToString()
+ "止，调整【" + tMeterReading.AdjustNum.ToString()
+ "】，分摊【" + i_Share.ToString() + "】";
session.Update(tOld);
}
Application.DoEvents();
}
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
//3.循环所有物业，将除计量外的计费全部添加
lStatus.Text = "【物业计费生成...】";
session = NHibernateHelper.OpenSession();
tx = session.BeginTransaction();
ds = new DataSet();
ds = SQLiteHelper.ExecuteDataSet("SELECT WyRateID,WyID,RateID FROM WyRates WHERE WyID IN (SELECT WyID FROM WyInfos WHERE CustomerID = @CustomerID)", s_CustomerID);
drs = ds.Tables[0].Select("1=1");
try
{
for (int i = 0; i < drs.Length; i++)
{
int i_WyRateID = Convert.ToInt32(drs[i]["WyRateID"].ToString());
WyRates tWyRate = session.Get <WyRates>(i_WyRateID);
//检查ChargeDetail中是否有此收费的数据
WyInfos tWyInfo = session.Get <WyInfos>(tWyRate.WyID);
lStatus.Text = "【物业计费生成】:" + tWyInfo.WyName;
Rates tRate = session.Get <Rates>(tWyRate.RateID);
IQuery query = session.CreateQuery("FROM ChargeDetail WHERE WyRateID = ? AND PeriodNo = ?");
query.SetParameter(0, tWyRate.WyRateID);
query.SetParameter(1, s_PeriodNo);
IList <ChargeDetail> eList = query.List <ChargeDetail>();
if (eList.Count == 0)
{
int i_Share = 0;
//没有此收费记录
ChargeDetail tNew = new ChargeDetail();
tNew.PeriodNo = s_PeriodNo;
tNew.WyID = tWyInfo.WyID;
tNew.WyName = tWyInfo.WyName;
tNew.ChargeName = tRate.RateName;
tNew.ChargeStatus = "已计费";
tNew.ChargeUnit = tRate.RateUnit;
//收费费率的单位 建筑面积，套内面积，公摊面积，人口数，固定金额
switch (tRate.RateUnit)
{
case "建筑面积":
tNew.ChargeNum = Convert.ToDecimal(tWyInfo.JZArea);
tNew.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
case "套内面积":
tNew.ChargeNum = Convert.ToDecimal(tWyInfo.TNArea);
tNew.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
case "公摊面积":
tNew.ChargeNum = Convert.ToDecimal(tWyInfo.GTArea);
tNew.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
default:
tNew.ChargeNum = tRate.RateValue;
tNew.ChargePrice = 1.0m;
break;
}
tNew.ChargeYS = tNew.ChargeNum * tNew.ChargePrice;
tNew.ChargeSS = 0.0m;
tNew.ChargeDate = DateTime.Now;
tNew.Abstract = "物业【" + tWyInfo.WyName + "】的【 "
+ tRate.RateName
+ " 】收费项 ";
tNew.WyRateID = tWyRate.WyRateID;
session.Save(tNew);
}
else
{
//有此收费记录
ChargeDetail tOld = session.Get <ChargeDetail>(eList[0].CDNo);
tOld.PeriodNo = s_PeriodNo;
tOld.WyID = tWyInfo.WyID;
tOld.WyName = tWyInfo.WyName;
tOld.ChargeName = tRate.RateName;
tOld.ChargeStatus = "已计费";
tOld.ChargeUnit = tRate.RateUnit;
//收费费率的单位 建筑面积，套内面积，公摊面积，人口数，固定金额
switch (tRate.RateUnit)
{
case "建筑面积":
tOld.ChargeNum = Convert.ToDecimal(tWyInfo.JZArea);
tOld.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
case "套内面积":
tOld.ChargeNum = Convert.ToDecimal(tWyInfo.TNArea);
tOld.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
case "公摊面积":
tOld.ChargeNum = Convert.ToDecimal(tWyInfo.GTArea);
tOld.ChargePrice = Convert.ToDecimal(tRate.RateValue);
break;
default:
tOld.ChargeNum = tRate.RateValue;
tOld.ChargePrice = 1.0m;
break;
}
tOld.ChargeYS = tOld.ChargeNum * tOld.ChargePrice;
tOld.ChargeSS = 0.0m;
tOld.ChargeDate = DateTime.Now;
tOld.Abstract = "物业【" + tWyInfo.WyName + "】的【 "
+ tRate.RateName
+ " 】收费项 ";
tOld.WyRateID = tWyRate.WyRateID;
session.Update(tOld);
}
Application.DoEvents();
}
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
//4.
lStatus.Text = "【计费生成完成！】";
return;
}
void ButtonModifyClick(object sender, EventArgs e)
{
//修改
buttonNew.Enabled = false;
buttonModify.Enabled = false;
buttonDel.Enabled = false;
新计量表ToolStripMenuItem.Enabled = false;
修改计量表ToolStripMenuItem.Enabled = false;
除计量表ToolStripMenuItem.Enabled = false;
buttonSave.Enabled = true;
buttonCancel.Enabled = true;
if (treeView1.SelectedNode != null)
{
Meters tModify = new Meters();
Meters tPModify = new Meters();
tModify = BLL.MetersBLL.GetMeter(Convert.ToInt32(treeView1.SelectedNode.Tag.ToString()));
textBoxMeterID.Text = tModify.MeterID.ToString();
if (tModify.MeterPID != null)
{
tPModify = BLL.MetersBLL.GetMeter(Convert.ToInt32(tModify.MeterPID.ToString()));
comboBoxTreeViewMeterPID.Tag = tModify.MeterPID.ToString();
comboBoxTreeViewMeterPID.Text = tPModify.MeterName;
}
else
{
comboBoxTreeViewMeterPID.Text = "";
}
textBoxMeterName.Text = tModify.MeterName;
comboBoxMeterClass.Text = tModify.MeterClass;
if (tModify.MeterUsing == 1)
{
checkBoxMeterUsing.Checked = true;
}
else
{
checkBoxMeterUsing.Checked = false;
}
if (tModify.MeterCanSharing == 1)
{
checkBoxMeterSharing.Checked = true;
}
else
{
checkBoxMeterSharing.Checked = false;
}
if (tModify.MeterSelfUse == 1)
{
checkBoxMeterSelfUse.Checked = true;
}
else
{
checkBoxMeterSelfUse.Checked = false;
}
textBoxMeterMulti.Text = tModify.MeterMulti.ToString();
textBoxMeterMaxNumber.Text = tModify.MeterMaxNumber.ToString();
if (tModify.RateID != null)
{
Rates tRate = new Rates();
tRate = BLL.RatesBLL.GetRate(Convert.ToInt32(tModify.RateID.ToString()));
comboBoxRateID.Tag = tModify.RateID;
comboBoxRateID.Text = tRate.RateName;
}
if (tModify.WyID != null)
{
WyInfos tWy = new WyInfos();
tWy = BLL.WyInfosBLL.GetWyInfo(Convert.ToInt32(tModify.WyID.ToString()));
comboBoxWyID.Tag = tModify.WyID;
comboBoxWyID.Text = tWy.WyName;
}
}
}
//生成指定周期的计量表记录空表
public static void ProduceMeterReading(string s_PeriodNo, Label lStatus)
{
string s_LastPeriodNo = "";
string s_year, s_month;
s_year = s_PeriodNo.Substring(0, 4);
s_month = s_PeriodNo.Substring(4, 2);
int i_month = Convert.ToInt32(s_month);
int i_year = Convert.ToInt32(s_year);
if (i_month == 1)
{
s_LastPeriodNo = (i_year - 1).ToString() + "12";
}
else
{
s_LastPeriodNo = i_year.ToString() + (i_month - 1).ToString("00");
}
DataSet ds = new DataSet();
//检查当前周期的表记录是否已经结算了（状态：已结算）
int i_rtn = Convert.ToInt32(SQLiteHelper.ExecuteScalar("SELECT Count(*) FROM MeterReading WHERE RStatus = '已结算' AND PeriodNo = @PeriodNo", s_PeriodNo));
if (i_rtn > 0)
{
MessageBox.Show("当前计量周期已经结算完成，不能生成！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ISession session = NHibernateHelper.OpenSession();
ITransaction tx = session.BeginTransaction();
ds = SQLiteHelper.ExecuteDataSet("SELECT MeterID FROM Meters WHERE MeterUsing = 1");
DataRow[] drs;
drs = ds.Tables[0].Select("1=1");
try
{
for (int i = 0; i < drs.Length; i++)
{
int i_MeterID = Convert.ToInt32(drs[i]["MeterID"].ToString());
lStatus.Text = "正在处理计量表：【" + i_MeterID.ToString() + "】";
IQuery query = session.CreateQuery("FROM MeterReading WHERE MeterID = ? AND PeriodNo = ?");
query.SetParameter(0, i_MeterID.ToString());
query.SetParameter(1, s_PeriodNo);
IList <MeterReading> eList = query.List <MeterReading>();
//查上期有无记录
IQuery query1 = session.CreateQuery("FROM MeterReading WHERE MeterID = ? AND PeriodNo = ?");
query1.SetParameter(0, i_MeterID.ToString());
query1.SetParameter(1, s_LastPeriodNo);
IList <MeterReading> eList1 = query1.List <MeterReading>();
Meters tMeter = session.Get <Meters>(i_MeterID);
if (eList.Count == 0)
{
MeterReading tNew = new MeterReading();
tNew.MeterID = tMeter.MeterID;
tNew.MeterName = tMeter.MeterName;
tNew.MeterPID = tMeter.MeterPID;
if (tMeter.MeterPID != null)
{
Meters tPMeter = session.Get <Meters>(tMeter.MeterPID);
tNew.MeterPName = tPMeter.MeterName;
}
tNew.MeterClass = tMeter.MeterClass;
tNew.MeterUsing = tMeter.MeterUsing;
tNew.MeterCanSharing = tMeter.MeterCanSharing;
tNew.MeterSelfUse = tMeter.MeterSelfUse;
tNew.MeterMulti = tMeter.MeterMulti;
tNew.MeterMaxNumber = tMeter.MeterMaxNumber;
tNew.RateID = tMeter.RateID;
if (tMeter.RateID != null)
{
Rates tRate = session.Get <Rates>(tMeter.RateID);
tNew.RateName = tRate.RateName;
tNew.RateValue = tRate.RateValue;
}
tNew.WyID = tMeter.WyID;
if (tMeter.WyID != null)
{
WyInfos tWyInfo = session.Get <WyInfos>(tMeter.WyID);
tNew.WyName = tWyInfo.WyName;
}
tNew.PeriodNo = s_PeriodNo;
if (eList1.Count == 1)
{
tNew.StartReading = eList1[0].EndReading;
}
else
{
tNew.StartReading = 0;
}
tNew.EndReading = 0;
tNew.RStatus = "计量输入";
tNew.CreatedDate = DateTime.Now;
tNew.AdjustNum = 0;
tNew.BeforeShareTotal = 0;
tNew.ShareNum = 0;
tNew.TotalNum = 0;
session.Save(tNew);
}
else
{
//已经有数据了
MeterReading tOld = session.Get <MeterReading>(eList[0].RID);
tOld.MeterID = tMeter.MeterID;
tOld.MeterName = tMeter.MeterName;
tOld.MeterPID = tMeter.MeterPID;
if (tMeter.MeterPID != null)
{
Meters tPMeter = session.Get <Meters>(tMeter.MeterPID);
tOld.MeterPName = tPMeter.MeterName;
}
tOld.MeterClass = tMeter.MeterClass;
tOld.MeterUsing = tMeter.MeterUsing;
tOld.MeterCanSharing = tMeter.MeterCanSharing;
tOld.MeterSelfUse = tMeter.MeterSelfUse;
tOld.MeterMulti = tMeter.MeterMulti;
tOld.MeterMaxNumber = tMeter.MeterMaxNumber;
tOld.RateID = tMeter.RateID;
if (tMeter.RateID != null)
{
Rates tRate = session.Get <Rates>(tMeter.RateID);
tOld.RateName = tRate.RateName;
tOld.RateValue = tRate.RateValue;
}
tOld.WyID = tMeter.WyID;
if (tMeter.WyID != null)
{
WyInfos tWyInfo = session.Get <WyInfos>(tMeter.WyID);
tOld.WyName = tWyInfo.WyName;
}
tOld.PeriodNo = s_PeriodNo;
tOld.CreatedDate = DateTime.Now;
session.Update(tOld);
Application.DoEvents();
}
}
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
lStatus.Text = "【记录生成完成！】";
return;
}
void ButtonSaveClick(object sender, EventArgs e)
{
//保存
//保存前先检查必须输入项
if (CheckInputOK())
{
if (textBoxWyID.Text == string.Empty)
{
WyInfos tNew = new WyInfos();
tNew.WyName = textBoxWyName.Text;
if (textBoxOwnerName.Text == string.Empty)
{
tNew.OwnerName = null;
}
else
{
tNew.OwnerName = textBoxOwnerName.Text;
}
if (comboBoxCustomerID.Text == string.Empty)
{
tNew.CustomerID = null;
}
else
{
tNew.CustomerID = Convert.ToInt32(comboBoxCustomerID.SelectedValue.ToString());
}
if (textBoxJZArea.Text == string.Empty)
{
tNew.JZArea = null;
}
else
{
tNew.JZArea = Convert.ToDecimal(textBoxJZArea.Text);
}
if (textBoxTNArea.Text == string.Empty)
{
tNew.TNArea = null;
}
else
{
tNew.TNArea = Convert.ToDecimal(textBoxTNArea.Text);
}
if (textBoxGTArea.Text == string.Empty)
{
tNew.GTArea = null;
}
else
{
tNew.GTArea = Convert.ToDecimal(textBoxGTArea.Text);
}
if (textBoxUNIT_No.Text == string.Empty)
{
tNew.UNIT_No = null;
}
else
{
tNew.UNIT_No = Convert.ToInt32(textBoxUNIT_No.Text);
}
if (textBoxFLOOR_No.Text == string.Empty)
{
tNew.FLOOR_No = null;
}
else
{
tNew.FLOOR_No = Convert.ToInt32(textBoxFLOOR_No.Text);
}
if (textBoxROOM_No.Text == string.Empty)
{
tNew.ROOM_No = null;
}
else
{
tNew.ROOM_No = Convert.ToInt32(textBoxROOM_No.Text);
}
if (textBoxOwnerDetail.Text == string.Empty)
{
tNew.OwnerDetail = null;
}
else
{
tNew.OwnerDetail = textBoxOwnerDetail.Text;
}
BLL.WyInfosBLL.AddWyInfos(tNew);
}
else
{
WyInfos tNew = new WyInfos();
tNew.WyID = Convert.ToInt32(textBoxWyID.Text);
tNew.WyName = textBoxWyName.Text;
if (textBoxOwnerName.Text == string.Empty)
{
tNew.OwnerName = null;
}
else
{
tNew.OwnerName = textBoxOwnerName.Text;
}
if (comboBoxCustomerID.Text == string.Empty)
{
tNew.CustomerID = null;
}
else
{
tNew.CustomerID = Convert.ToInt32(comboBoxCustomerID.SelectedValue.ToString());
}
if (textBoxJZArea.Text == string.Empty)
{
tNew.JZArea = null;
}
else
{
tNew.JZArea = Convert.ToDecimal(textBoxJZArea.Text);
}
if (textBoxTNArea.Text == string.Empty)
{
tNew.TNArea = null;
}
else
{
tNew.TNArea = Convert.ToDecimal(textBoxTNArea.Text);
}
if (textBoxGTArea.Text == string.Empty)
{
tNew.GTArea = null;
}
else
{
tNew.GTArea = Convert.ToDecimal(textBoxGTArea.Text);
}
if (textBoxUNIT_No.Text == string.Empty)
{
tNew.UNIT_No = null;
}
else
{
tNew.UNIT_No = Convert.ToInt32(textBoxUNIT_No.Text);
}
if (textBoxFLOOR_No.Text == string.Empty)
{
tNew.FLOOR_No = null;
}
else
{
tNew.FLOOR_No = Convert.ToInt32(textBoxFLOOR_No.Text);
}
if (textBoxROOM_No.Text == string.Empty)
{
tNew.ROOM_No = null;
}
else
{
tNew.ROOM_No = Convert.ToInt32(textBoxROOM_No.Text);
}
if (textBoxOwnerDetail.Text == string.Empty)
{
tNew.OwnerDetail = null;
}
else
{
tNew.OwnerDetail = textBoxOwnerDetail.Text;
}
BLL.WyInfosBLL.UpdateWyInfos(tNew);
}
FillDataGridView1();
ClearContent();
//改按钮状态
buttonNew.Enabled = true;
buttonModify.Enabled = true;
buttonDel.Enabled = true;
新增物业ToolStripMenuItem.Enabled = true;
修改物业ToolStripMenuItem.Enabled = true;
除物业ToolStripMenuItem.Enabled = true;
buttonSave.Enabled = false;
buttonCancel.Enabled = false;
}
}
