private void SaveNewComplain(string query)
 {
     DataHelper.UpdateOrDeleteRecord(query);
 }
 private void SaveNewBuilding(string query)
 {
     DataHelper.UpdateOrDeleteRecord(query);
 }
 private void SaveNewCommonRepair(string query)
 {
     DataHelper.UpdateOrDeleteRecord(query);
 }
Exemple #4
0
        private void 查询Button_Click(object sender, EventArgs e)
        {
            string v_计费年份 = this.计费年份ComboBox.Text.Trim();
            string v_计费月份 = this.计费月份ComboBox.Text.Trim();
            string v_楼栋名称 = this.楼栋名称ComboBox.Text.Trim();
            string v_业主姓名 = this.业主姓名ComboBox.Text.Trim();
            string v_小区名称 = this.小区名称ComboBox.Text.Trim();
            string v_费用状态 = this.费用状态ComboBox.Text.Trim();

            if (string.IsNullOrEmpty(v_计费年份) || string.IsNullOrEmpty(v_计费月份) || string.IsNullOrEmpty(v_小区名称) || string.IsNullOrEmpty(v_楼栋名称))
            {
                new MsgBoxForm("提示", "没有选择正确的计费年份,计费月份,小区名称,楼栋名称等信息!").ShowDialog();
                return;
            }
            dtData.Rows.Clear();
            string query         = "Select 楼栋名称,业主编号,业主姓名,计费年份,计费月份,费用状态,收据编号,round(sum(应交金额),2) as 应交金额 FROM 水电气费 WHERE (登记标志='完成登记') AND (计费年份= " + v_计费年份 + ")";
            string ownerQuery    = "Select 业主编号,业主姓名,楼栋名称,物业费用,预存金额,联系电话 from 业主信息 WHERE (业主编号 NOT IN (SELECT 业主编号 FROM 迁出信息))";
            string reciptNoQuery = "Select 收据编号 FROM 水电气费 WHERE (登记标志='完成登记') AND (费用状态='已交费') AND (计费年份= " + v_计费年份 + ")";

            if (v_计费月份 == "全年")
            {
                query += "";
            }
            else
            {
                query         += " AND (计费月份=" + v_计费月份 + ")";
                reciptNoQuery += " AND (计费月份=" + v_计费月份 + ")";
            }
            if (v_小区名称 == "全部")
            {
                query += "";
            }
            else
            {
                if (v_楼栋名称 == "全部")
                {
                    query         += " AND (楼栋名称 in (select 楼栋名称 from 楼栋信息 where 小区名称='" + v_小区名称 + "'))";
                    ownerQuery    += " AND (楼栋名称 in (select 楼栋名称 from 楼栋信息 where 小区名称='" + v_小区名称 + "'))";
                    reciptNoQuery += " AND (楼栋名称 in (select 楼栋名称 from 楼栋信息 where 小区名称='" + v_小区名称 + "'))";
                }
                else
                {
                    query         += " AND (楼栋名称='" + v_楼栋名称 + "')";
                    ownerQuery    += " AND (楼栋名称='" + v_楼栋名称 + "')";
                    reciptNoQuery += " AND (楼栋名称='" + v_楼栋名称 + "')";
                }
            }

            if (v_业主姓名 == "全部")
            {
                query += "";
            }
            else
            {
                query         += " AND (业主姓名='" + v_业主姓名 + "')";
                ownerQuery    += " AND (业主姓名='" + v_业主姓名 + "')";
                reciptNoQuery += " AND (业主姓名='" + v_业主姓名 + "')";
            }
            if (v_费用状态 == "全部")
            {
                query += "";
            }
            else
            {
                query += " AND (费用状态='" + v_费用状态 + "')";
            }
            query += " group by 业主编号,计费年份,计费月份";
            dtData = DataHelper.GetDataTable(query);
            if (dtData.Rows.Count == 0)
            {
                return;
            }
            DataTable ownerTable  = DataHelper.GetDataTable(ownerQuery);
            string    reciptQuery = string.Format("select * from 费用收据 where 收据编号 in ({0})", reciptNoQuery);
            DataTable reciptTable = DataHelper.GetDataTable(reciptQuery);

            RefreshDataGridView(ownerTable, reciptTable);
        }
 private bool IsNewAdded(string repairNo)
 {
     string query = string.Format("select * from 业主维修 where 维修编号='{0}'", repairNo);
     System.Data.DataTable dt = DataHelper.GetDataTable(query);
     return dt.Rows.Count < 1;
 }