批量补差

最新推荐文章于 2023-03-31 11:25:23 发布
最新推荐文章于 2023-03-31 11:25:23 发布
阅读量874 收藏
点赞数
分类专栏： C# 文章标签： textbox join string button calendar exception
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/liuzhaopds/article/details/6593346
版权

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;

using System.Text.RegularExpressions;


public partial class Default3 : System.Web.UI.Page

{

    bool loadflag = false;

    private string DataFormatString;


    记录房屋面积的变量，用来进行差异率的计算和数据库更新的数据

    //String unit_area_jianzhu = "";

    //String unit_area_taonei = "";


    //GRIDVIEW数据源

    DataTable dt = new DataTable();


    protected void Page_Load(object sender, EventArgs e)

    {

        //if (loadflag == false)

        //{

        //    //设置为不可见

        //    VisibleFalse();

        //    loadflag = true;

        //}


        


    }

    //读取项目信息

    protected void Button1_Click(object sender, EventArgs e)

    {

        Button3.Enabled = false;

        DropDownList1.Items.Clear();

        DropDownList1.Items.Add("");

        //设置为可见

        Visibletrue();

        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        String querystr = "select project_name from t_sys_project";


        SqlConnection sqlcon = new SqlConnection(constr);


        try

        {

            sqlcon.Open();

            SqlCommand sc = new SqlCommand(querystr, sqlcon);

            SqlDataReader sr = sc.ExecuteReader();

            if (sr.HasRows)

            {

                while (sr.Read())

                {

                    DropDownList1.Items.Add(sr[0].ToString());

                }

                DropDownList1.DataBind();

            }


            sqlcon.Close();


        }

        catch (Exception ex)

        {

            Label7.Text = "提示信息：" + Label7.Text + "项目错误" + ex.ToString();

        }

    }



    //读取楼号信息

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

    {

        DropDownList2.Items.Clear();

        DropDownList2.Items.Add("");


        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        String querystr = "SELECT t_hou_building.building_name from t_hou_structon  right join t_hou_building  on t_hou_structon.structon_guid=t_hou_building.structon_guid     RIGHT JOIN t_sys_project ON t_hou_structon.parent_structon_guid = t_sys_project.PROJECT_ID     where t_hou_structon.inactive<>1 AND t_sys_project.PROJECT_NAME  = '" + DropDownList1.SelectedValue.ToString() + "' ORDER BY t_hou_building.building_name ";


        SqlConnection sqlcon = new SqlConnection(constr);


        try

        {

            sqlcon.Open();

            SqlCommand sc = new SqlCommand(querystr, sqlcon);

            SqlDataReader sr = sc.ExecuteReader();

            if (sr.HasRows)

            {

                while (sr.Read())

                {

                    DropDownList2.Items.Add(sr[0].ToString());

                }

                DropDownList2.DataBind();

            }


            sqlcon.Close();


        }

        catch (Exception ex)

        {

            Label7.Text = "提示信息：" + Label7.Text + "楼号错误" + ex.ToString();

        }

    }


    public void VisibleFalse()

    {

        Label1.Visible = false;

        Label2.Visible = false;

        Label3.Visible = false;

        Label4.Visible = false;

        Label5.Visible = false;

        Label6.Visible = false;

        Label7.Visible = false;

        DropDownList1.Visible = false;

        DropDownList2.Visible = false;

        DropDownList3.Visible = false;

        DropDownList4.Visible = false;

        DropDownList5.Visible = false;

        DropDownList6.Visible = false;


    }


    public void Visibletrue()

    {

        Label1.Visible = true;

        Label2.Visible = true;

        Label3.Visible = true;

        Label4.Visible = true;

        Label5.Visible = true;

        Label6.Visible = true;

        Label7.Visible = true;

        DropDownList1.Visible = true;

        DropDownList2.Visible = true;

        DropDownList3.Visible = true;

        DropDownList4.Visible = true;

        DropDownList5.Visible = true;

        DropDownList6.Visible = true;


    }



    //读取单元信息

    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)

    {

        DropDownList3.Items.Clear();

        DropDownList3.Items.Add("");

        String XiangmuName = DropDownList1.SelectedValue.ToString();


        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        String querystr = "SELECT distinct unit.COLUMN_NAME FROM t_hou_unit unit RIGHT JOIN t_hou_building  building ON building.STRUCTON_GUID = unit.STRUCTON_GUID RIGHT JOIN  (SELECT t_hou_building.structon_guid ,t_hou_building.building_name ,t_sys_project.PROJECT_NAME from t_hou_structon  right join t_hou_building  on t_hou_structon.structon_guid=t_hou_building.structon_guid     RIGHT JOIN t_sys_project ON t_hou_structon.parent_structon_guid = t_sys_project.PROJECT_ID  WHERE  t_sys_project.PROJECT_NAME = '" + DropDownList1.SelectedValue.ToString() + "' )t1 ON t1.structon_guid = unit.structon_guid  where building.building_name = '" + DropDownList2.SelectedValue.ToString() + "'   and column_name <> '商铺' and unit.INACTIVE=0 order by unit.COLUMN_NAME DESC";


        SqlConnection sqlcon = new SqlConnection(constr);


        try

        {

            sqlcon.Open();

            SqlCommand sc = new SqlCommand(querystr, sqlcon);

            SqlDataReader sr = sc.ExecuteReader();

            if (sr.HasRows)

            {

                while (sr.Read())

                {

                    DropDownList3.Items.Add(sr[0].ToString());

                }

                DropDownList3.DataBind();

            }


            sqlcon.Close();


        }

        catch (Exception ex)

        {

            Label7.Text = "提示信息：" + Label7.Text + "单元号错误" + ex.ToString();

        }

    }


    //读取单元下级信息

    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)

    {

        DropDownList4.Items.Clear();

        DropDownList4.Items.Add("");

        String XiangmuName = DropDownList1.SelectedValue.ToString();


        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        String querystr = "SELECT distinct order_no FROM t_hou_unit unit RIGHT JOIN t_hou_building  building ON building.STRUCTON_GUID = unit.STRUCTON_GUID RIGHT JOIN  (SELECT t_hou_building.structon_guid ,t_hou_building.building_name ,t_sys_project.PROJECT_NAME from t_hou_structon  right join t_hou_building  on t_hou_structon.structon_guid=t_hou_building.structon_guid     RIGHT JOIN t_sys_project ON t_hou_structon.parent_structon_guid = t_sys_project.PROJECT_ID  WHERE  t_sys_project.PROJECT_NAME = '" + DropDownList1.SelectedValue.ToString() + "' )t1 ON t1.structon_guid = unit.structon_guid  where building.building_name = '" + DropDownList2.SelectedValue.ToString() + "'  and column_name <> '商铺'  and unit.INACTIVE=0 order by order_no";


        SqlConnection sqlcon = new SqlConnection(constr);


        try

        {

            sqlcon.Open();

            SqlCommand sc = new SqlCommand(querystr, sqlcon);

            SqlDataReader sr = sc.ExecuteReader();

            if (sr.HasRows)

            {

                while (sr.Read())

                {

                    DropDownList4.Items.Add(sr[0].ToString());

                }

                DropDownList4.DataBind();

            }


            sqlcon.Close();


        }

        catch (Exception ex)

        {

            Label7.Text = "提示信息：" + Label7.Text + "单元下级错误" + ex.ToString();

        }

    }

    //读取房间信息

    protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)

    {

        DropDownList5.Items.Clear();

        DropDownList6.Items.Clear();

        DropDownList5.Items.Add("");

        DropDownList6.Items.Add("");

        String XiangmuName = DropDownList1.SelectedValue.ToString();


        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        String querystr = "select tunit.unit_name  from  t_sal_reservation tres left join t_hou_unit tunit on tunit.unit_guid=tres.unit_guid and tunit.inactive=0 left join t_hou_structon tstru on  tstru.structon_guid=tunit.structon_guid and tstru.inactive=0 left join t_hou_building tbuild on tstru.structon_guid=tbuild.structon_guid  left join t_sys_project tproj on tproj .project_id=tstru.project_guid left join t_cus_customer tper on tper.customer_guid=tres.customer_guid left join t_hou_unit_info tinfo on tinfo.unit_guid=tunit.unit_guid left join t_sal_area_expiation tae on tae.reservation_guid=tres.reservation_guid and tae.inactive=0 left join t_sal_process tproc on tproc.unit_guid = tres.unit_guid where tres.inactive=0  and tproc.status_id=5  AND project_name = '" + DropDownList1.SelectedValue.ToString() + "' and building_name = '" + DropDownList2.SelectedValue.ToString() + "' and column_name = '" + DropDownList3.SelectedValue.ToString() + "' AND tunit.order_no = '" + DropDownList4.SelectedValue.ToString() + "'  and column_name <> '商铺'  and   tae.aduit_user_guid is null   order by cast(unit_name  as int) ,project_name,building_name ";


        SqlConnection sqlcon = new SqlConnection(constr);


        try

        {

            sqlcon.Open();

            SqlCommand sc = new SqlCommand(querystr, sqlcon);

            SqlDataReader sr = sc.ExecuteReader();

            if (sr.HasRows)

            {

                while (sr.Read())

                {

                    DropDownList5.Items.Add(sr[0].ToString());

                    DropDownList6.Items.Add(sr[0].ToString());

                }

                DropDownList5.DataBind();

                DropDownList6.DataBind();

            }


            sqlcon.Close();


        }

        catch (Exception ex)

        {

            Label7.Text = "提示信息：" + Label7.Text + "单元下级错误" + ex.ToString();

        }

    }


    protected void DropDownList6_SelectedIndexChanged(object sender, EventArgs e)

    {

        //Label7.Text = "选择的房间信息为： " + DropDownList1.SelectedValue + " " + DropDownList2.SelectedValue

        //    + " " + DropDownList3.SelectedValue + " 第" + DropDownList4.SelectedValue + "列\n";

        //for (int i = DropDownList5.SelectedIndex; i <= DropDownList6.SelectedIndex; i++)

        //{

        //    Label7.Text = Label7.Text + DropDownList6.Items[i].Value + "  ";

        //}

        //Label7.Text = Label7.Text + " 号房间。";

        Button3.Enabled = true;


    }


    protected void Button3_Click(object sender, EventArgs e)

    {


        Label23.Text = "";

        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        SqlConnection sqlcon = new SqlConnection(constr);

        

        

        

        

        try

        {

            DataTable dt = new DataTable();

            dt.Columns.Add("项目名称");

            dt.Columns.Add("楼号");

            dt.Columns.Add("单元号");

            dt.Columns.Add("房间号");

            dt.Columns.Add("客户名称");

            dt.Columns.Add("认购日期");

            dt.Columns.Add("签约日期");

            dt.Columns.Add("合同建筑面积(㎡)");

            dt.Columns.Add("合同套内面积(㎡)");

            dt.Columns.Add("合同单价");

            dt.Columns.Add("合同总价");


            for (int i = DropDownList5.SelectedIndex; i <= DropDownList6.SelectedIndex; i++)

            {

                

                sqlcon.Open();

                String querystr = "select  CAST(tproj.project_id AS VARCHAR(32)) , tproj.project_name, tbuild.building_name, tunit.unit_guid,tunit.column_name ,tunit.order_no,tunit.unit_name, tper.customer_name as name, tinfo.construction_area, tres.reservation_guid, tres.amount, isnull(tae.aduit_user_guid,'-1') as exId, convert(varchar(10),tres.reservation_date,120) as rdate, convert(varchar(10),tres.sign_contract_date,120) as cdate, tres.construction_area_price, tinfo.use_area,    case    when tunit.column_name is not null then tunit.sales_code_prefix + '-' + tunit.column_name + '-' +tunit.unit_name         else tunit.sales_code_prefix + '-' + tunit.unit_name            end as roomCode  from  t_sal_reservation tres left join t_hou_unit tunit on tunit.unit_guid=tres.unit_guid and tunit.inactive=0 left join t_hou_structon tstru on  tstru.structon_guid=tunit.structon_guid and tstru.inactive=0 left join t_hou_building tbuild on tstru.structon_guid=tbuild.structon_guid  left join t_sys_project tproj on tproj .project_id=tstru.project_guid left join t_cus_customer tper on tper.customer_guid=tres.customer_guid left join t_hou_unit_info tinfo on tinfo.unit_guid=tunit.unit_guid left join t_sal_area_expiation tae on tae.reservation_guid=tres.reservation_guid and tae.inactive=0 left join t_sal_process tproc on tproc.unit_guid = tres.unit_guid where tres.inactive=0  and tproc.status_id=5  AND project_name = '" + DropDownList1.SelectedValue + "' and building_name = '" + DropDownList2.SelectedValue + "' and column_name = '" + DropDownList3.SelectedValue + "' AND tunit.order_no = '" + DropDownList4.SelectedValue + "'  AND unit_name = " + DropDownList6.Items[i].Value + " order by cast(unit_name  as int) ,project_name,building_name";

                SqlCommand sc = new SqlCommand(querystr, sqlcon);

                SqlDataReader sr = sc.ExecuteReader();

                

                if (sr.HasRows)

                {

                    while (sr.Read())

                    {

                        

                        DataRow dr = dt.NewRow();

                        dr["项目名称"] = sr["project_name"].ToString();

                        dr["楼号"] = sr["building_name"].ToString();

                        dr["单元号"] = sr["column_name"].ToString();

                        dr["房间号"] = sr["unit_name"].ToString();

                        dr["客户名称"] = sr["name"].ToString();

                        dr["认购日期"] = sr["rdate"].ToString();

                        dr["签约日期"] = sr["cdate"].ToString();                        

                        dr["合同建筑面积(㎡)"] = sr["construction_area"].ToString();

                        dr["合同套内面积(㎡)"] = sr["use_area"].ToString();

                        dr["合同单价"] = String.Format("{0:N}",Convert.ToDecimal(sr["construction_area_price"]));

                        dr["合同总价"] = String.Format("{0:N}",Convert.ToDecimal(sr["amount"].ToString()));

                        dt.Rows.Add(dr);


                    }

                }


                sqlcon.Close();

            }


            


            GridView1.DataSource = dt;

            GridView1.DataBind();


            for (int i = dt.Rows.Count - 1; i >= 1; i--)

            {

                DataRow dr1 = dt.Rows[i];

                DataRow dr2 = dt.Rows[i - 1];

                if (!dr1["合同建筑面积(㎡)"].Equals(dr2["合同建筑面积(㎡)"]))

                {

                    Label23.Text = Label23.Text + "选取房屋的建筑面积不一样，不能批量操作。";

                    Button6.Enabled = false;

                }

                 if (!dr1["合同套内面积(㎡)"].Equals(dr2["合同套内面积(㎡)"]))

                {

                    Label23.Text = Label23.Text + "选取房屋的套内面积不一样，不能批量操作。";

                    Button6.Enabled = false;

                }

                // if (dr1["合同建筑面积(㎡)"].Equals(dr2["合同建筑面积(㎡)"]))

                //{

                //    unit_area_jianzhu = dr1["合同建筑面积(㎡)"].ToString();

                //}

                // if (dr1["合同套内面积(㎡)"].Equals(dr2["合同套内面积(㎡)"]))

                //{

                //    unit_area_taonei = dr1["合同套内面积(㎡)"].ToString();

                //}

                

            }


            Button8.Focus();


            


        }

        catch (Exception ex)

        {

            Label23.Text = "房间信息错误：" + ex.ToString();

        }


        

    }

    protected void TextBox1_TextChanged(object sender, EventArgs e)

    {

        //TextBox3.Text = (Convert.ToDouble(TextBox1.Text) - Convert.ToDouble(unit_area_jianzhu)).ToString();

        TextBox3.Text = (Convert.ToDouble(TextBox1.Text) - Convert.ToDouble(GridView1.Rows[0].Cells[7].Text)).ToString();

        TextBox4.Text = (Convert.ToDouble(TextBox3.Text) / Convert.ToDouble(GridView1.Rows[0].Cells[7].Text)*100).ToString().Substring(0,5);

        Button8.Focus();

        

        

    }

    protected void TextBox2_TextChanged(object sender, EventArgs e)

    {

        TextBox5.Text = (Convert.ToDouble(TextBox2.Text) - Convert.ToDouble(GridView1.Rows[0].Cells[8].Text)).ToString();

        TextBox6.Text = (Convert.ToDouble(TextBox5.Text) / Convert.ToDouble(GridView1.Rows[0].Cells[8].Text)*100).ToString().Substring(0,5);

        Button6.Enabled = true;

        Button8.Focus();

        

    }

    

    protected void Calendar1_SelectionChanged(object sender, EventArgs e)

    {

        TextBox8.Text = Calendar1.SelectedDate.ToShortDateString();

        Button8.Focus();

    }

    protected void Button6_Click(object sender, EventArgs e)

    {


        DataTable dt2 = new DataTable();

        dt2.Columns.Add("项目名称");

        dt2.Columns.Add("楼号");

        dt2.Columns.Add("单元号");

        dt2.Columns.Add("房间号");

        dt2.Columns.Add("客户名称");

        dt2.Columns.Add("认购日期");

        dt2.Columns.Add("签约日期");

        dt2.Columns.Add("合同建筑面积(㎡)");

        dt2.Columns.Add("合同套内面积(㎡)");

        dt2.Columns.Add("合同单价");

        dt2.Columns.Add("合同总价");

        dt2.Columns.Add("实测建筑面积(㎡)");

        dt2.Columns.Add("实测套内面积(㎡)");

        dt2.Columns.Add("建筑面积差异(㎡)");

        dt2.Columns.Add("建筑面积差异率(%)");

        dt2.Columns.Add("套内面积差异(㎡)");

        dt2.Columns.Add("套内面积差异率(%)");

        dt2.Columns.Add("应补差款");


        for (int i = 0; i < GridView1.Rows.Count  ; i++)

        {

            DataRow dr = dt2.NewRow();

            dr["项目名称"] = GridView1.Rows[i].Cells[0].Text;

            dr["楼号"] = GridView1.Rows[i].Cells[1].Text;

            dr["单元号"] = GridView1.Rows[i].Cells[2].Text;

            dr["房间号"] = GridView1.Rows[i].Cells[3].Text;

            dr["客户名称"] = GridView1.Rows[i].Cells[4].Text;

            dr["认购日期"] = GridView1.Rows[i].Cells[5].Text;

            dr["签约日期"] = GridView1.Rows[i].Cells[6].Text;

            dr["合同建筑面积(㎡)"] = GridView1.Rows[i].Cells[7].Text;

            dr["合同套内面积(㎡)"] = GridView1.Rows[i].Cells[8].Text;

            dr["合同单价"] = String.Format("{0:N}",Convert.ToDecimal(DeleteQianFenWei(GridView1.Rows[i].Cells[9].Text)));

            dr["合同总价"] = String.Format("{0:N}",Convert.ToDecimal(DeleteQianFenWei(GridView1.Rows[i].Cells[10].Text)));

            dr["实测建筑面积(㎡)"] = TextBox1.Text;

            dr["实测套内面积(㎡)"] = TextBox2.Text;

            dr["建筑面积差异(㎡)"] = TextBox3.Text;

            dr["建筑面积差异率(%)"] = TextBox4.Text;

            dr["套内面积差异(㎡)"] = TextBox5.Text;

            dr["套内面积差异率(%)"] = TextBox6.Text;

            dr["应补差款"] = String.Format("{0:N}", Convert.ToDecimal(dr["合同单价"]) * Convert.ToDecimal(dr["建筑面积差异(㎡)"]));


            dt2.Rows.Add(dr);

         

          

        }


        GridView2.DataSource = dt2;

        GridView2.DataBind();        

        Button7.Focus();


    }

    protected void Button7_Click(object sender, EventArgs e)

    {


        


        String constr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;

        SqlConnection sqlcon = new SqlConnection(constr);

        //成功写入数据数的统计

        int count = 0;

        for (int i = 0; i < GridView2.Rows.Count; i++)

        {


            String Banliren = "销售主管";

            String Pizhunren = "销售总监";

            String expiation_guid = System.Guid.NewGuid().ToString().Substring(0, 32);

            Double Jianzhumianji = Convert.ToDouble(GridView2.Rows[i].Cells[11].Text);

            Double Yonghumianji = Convert.ToDouble(GridView2.Rows[i].Cells[12].Text);

            String Cehuidanwei = "";

            if (!TextBox7.Text.Equals("")&&TextBox7.Text.Length >= 31)

            {

                Cehuidanwei = TextBox7.Text.Substring(0,31);

            }

            else if (!TextBox7.Text.Equals("") && TextBox7.Text.Length <= 31)

            {

                Cehuidanwei = TextBox7.Text;

            }


            String Cehuiriqi = "";

            if (!TextBox8.Text.Equals(""))

            {

                Cehuiriqi = TextBox8.Text;

            }


            String Xiangmu = GridView2.Rows[i].Cells[0].Text;

            String Louhao = GridView2.Rows[i].Cells[1].Text;

            String Danyuanhao = GridView2.Rows[i].Cells[2].Text;

            String Fangjianhao = GridView2.Rows[i].Cells[3].Text;


            Double BuchaJIANZHUmianji = Convert.ToDouble(GridView2.Rows[i].Cells[13].Text);

            Double BuchajinE = Convert.ToDouble(DeleteQianFenWei(GridView2.Rows[i].Cells[17].Text));

            String Beizhu = "";

            if (!TextBox10.Text.Equals("")&&TextBox10.Text.Length >= 31)

            {

                Beizhu = TextBox10.Text.Substring(0,31);

            }

            else if (!TextBox10.Text.Equals("")&&TextBox10.Text.Length <= 31)

            {

                Beizhu = TextBox10.Text;

            }

            String Banliriqi = "";

            if (!TextBox9.Text.Equals(""))

            {

                Banliriqi = TextBox9.Text;

            }

            

            String querystr = "DECLARE @P0 nvarchar(4000),@P1 float,@P2 float,@P3 nvarchar(4000),@P4 datetime,@P5 nvarchar(4000),@P6 "

                + " nvarchar(4000),@P7 nvarchar(4000),@P8 float,@P9 float,@P10 nvarchar(4000),@p11 nvarchar(4000),@p12 nvarchar(4000),@p13 datetime "

                + " SET @P0 =  '" + expiation_guid + "' "

                + " SET @p1 = "+Jianzhumianji+" "

                + " SET @p2 = "+Yonghumianji+" "

                + " SET @p3 = '"+Cehuidanwei+"' "

                + " SET @p4 = '"+Cehuiriqi+"' "

                + " SET @p5 = (SELECT org_id FROM T_SYS_USERINFO WHERE NAME = '" + Banliren + "') "

                + " SET @p6 = (SELECT tres.reservation_guid from  t_sal_reservation tres left join t_hou_unit tunit on tunit.unit_guid=tres.unit_guid and tunit.inactive=0 left join t_hou_structon tstru on  tstru.structon_guid=tunit.structon_guid and tstru.inactive=0 left join t_hou_building tbuild on tstru.structon_guid=tbuild.structon_guid  left join t_sys_project tproj on tproj .project_id=tstru.project_guid left join t_cus_customer tper on tper.customer_guid=tres.customer_guid left join t_hou_unit_info tinfo on tinfo.unit_guid=tunit.unit_guid left join t_sal_area_expiation tae on tae.reservation_guid=tres.reservation_guid and tae.inactive=0 left join t_sal_process tproc on tproc.unit_guid = tres.unit_guid where tres.inactive=0  and tproc.status_id=5  AND project_name = '"+Xiangmu+"' and building_name = '"+Louhao+"' and column_name = '"+Danyuanhao+"'    and column_name <> '商铺'  and   tae.aduit_user_guid is null  and unit_name = "+Fangjianhao+" ) "

                + " SET @p7 = 0 "

                + " SET @p8 = "+BuchaJIANZHUmianji+" "

                + " SET @p9 = "+BuchajinE+"1 "

                + " SET @p10 = ( "

                //这里没有判断公式

                + " select t2.expiation_means_guid from t_set_expiation_precept t1 left join  t_set_expiation_means t2 on  t1.expiation_precept_guid=t2.expiation_precept_guid "

                + " where     t1.project_guid= (    SELECT project_id FROM t_sys_project WHERE project_name = '"+Xiangmu+"' "

                + "     )  and t1.ACCORDING_TYPE= 1) "

                + " SET @p11 = (SELECT org_id FROM T_SYS_USERINFO WHERE NAME = '" + Pizhunren + "') "

                + " SET @p12 = '"+Beizhu+"' "

                + " SET @p13 = '"+Banliriqi+"' "

                + " insert into  "

                + " t_sal_area_expiation(expiation_guid,construction_area,use_area,expiation_corp,expiation_date,user_guid,reservation_guid,inactive,expiation_area,expiation_amount,expiation_means_guid,aduit_user_guid, DESCRIPTION,fcurrent_date) "

                + " values( @P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7 , @P8 , @P9 , @P10 ,@p11,@p12,@p13) ";



            try

            {

                sqlcon.Open();

                SqlCommand sc = new SqlCommand(querystr, sqlcon);

                sc.ExecuteNonQuery();

                count++ ;

                sqlcon.Close();


                


            }

            catch (Exception ex)

            {

                Label31.Text = Label31.Text + "第" + i + "行写入数据库错误" + ex.ToString();

                break;

            }

        }


        Label31.Text = "共"+GridView2.Rows.Count+"条数据，成功写入"+count+"条数据";


        Button7.Focus();

    }

    protected void Calendar2_SelectionChanged(object sender, EventArgs e)

    {

        TextBox9.Text = Calendar2.SelectedDate.ToShortDateString();

        Button7.Focus();

    }


    public double DeleteQianFenWei(String a)

    {

        string b = null;

        for (int i = 0; i < a.Length; i++)

        {

            if (a[i] != ',')

            {

                b = b + a[i];

            }

        }

        return Convert.ToDouble(b);

    }

    protected void Calendar2_VisibleMonthChanged(object sender, MonthChangedEventArgs e)

    {

        Button7.Focus();

    }

    protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)

    {

        Button8.Focus();

    }

}


一路前行
关注
专栏目录
数据补差
sotong006的专栏
12-18 775
 当我们查询数据时，可能几条数据缺失，此时还必须我们自己补填时的情况，比如： 这时我们看到 2018-08-22 00:30:00的数据不存在了，而在页面顺序显示时我们还得补个空上去。下面是自己写的几个思路 1、循环收集起来的96点时间，定义一个标识，然后循环所有查询查来的数据，用查询的数据点与96个点时间一 一比较。如果存在相同，flag标记为true并返回，未找到flag为false，...
转账返款源码开发，转账返款系统
laoyangge007的博客
12-29 858
支付宝的接口一直在更新，批量付款便是最近的新接口。对于大型或者中型商家而言，这却是一个非常重要的更新，每当双11等电商大型活动来临，商家退款、退费、补差、退邮费等转账需求就会爆炸，于是支付宝批量付款便应运而生。开发对接支付宝官方开放平台API，需要具有企业营业资质，并且开通企业支付宝批量转账功能。转账系统经过多层服务器和程序防护加密，万无一失。一般人用的是最原始的人工转账，而使用批量转账可以免除更多人工成本，提高效率一键导入收款支付宝，全自动批量转账，省时更省力。
dataset，datatable的使用详解
11-03
里面包含很关于dataset和datatable的使用，还有例子
c# Json List<T> DataTable 数据相互转换
weixin_30835923的博客
01-13 127
最近在项目中用到的相关Json的数据转换 List<T>转Json public static string Obj2Json<T>(T data) { try { System.Runtime.Serialization.Json.Da...
DataTable 不支持来自 XML 的架构推断。解决方法
懒虫不懒，不信你看！
10-09 7348
DataTable 不支持来自 XML 的架构推断。VS2005以后，DataTable要用序列化XML才行的。所以用DataTable保存或者读取XML的时候要，一定要有Schema的支持。例如：保存时： dtXML.WriteXmlSchema("d://sampleSchema.xml"); dtXML.WriteXml("d://sample.xml");读取时： dtXML.Read
店群批量返款工具，最新支付宝批量转账的解决方案-收付无忧系统
weixin_44310747的博客
03-31 2659
转账到支付宝 api 接口，是在支付宝商家中心中推出的一个全新功能，有企业支付宝的商家只需输入另一个正确的支付宝账号，即可将资金从本人的支付宝账户转账至另一个支付宝账户，随时完成资金在支付宝账户间的转移，实时到账，方便安全快捷。商家批量退款、退费、补差、退邮费等就会爆增，或者淘宝阿里、拼多、抖店等商家需要批量返款的场景也多，如补丹返款、好评返现、免单试用活动，徽商返佣，批量提现等业务场景，批量返一直是困扰卖家的一大问题。通常无论是鱼塘，平台还是服务商，主流的返款模式都是使用个人支付宝点对点的专款。
一步步DIY: OSM-Web服务器(七) 利用 Google WebService 批量下载遥感瓦片数据
丁劲犇技术发布空间
09-21 5969
(-:写 http://blog.csdn.net/goldenhawking/article/details/8005564 前面六篇，是集中精力写的，其实，整个流程顺利走过来，花了笔者两个月的时间哦！因为无聊的网速、不给力的硬盘，以及停电，几乎到了恨不得砸机器的地步啦！~~ 走到现在，我们有了B/S C/S两种架构的地图服务，可是，总觉得还缺了什么——对了，只有矢量怎么行？！我们...
Oracle补历史数据存储过程,Oracle数据库数据丢失恢复的几种方法总结
weixin_31416737的博客
04-03 615
根据oracle数据库的特点和提供的工具，主要方法有以下几种方法：利用逻辑备份使用import工具丢失数据的表利用物理备份来通过还原数据文件并进行不完全恢复利用dbms_logmnr包从redo log文件中恢复利用flashback特性恢复数据前提为了方便使用方法的介绍，上述恢复方法都将基于以下场景进行：系统管理员在前一天晚上11点用export对数据库做了全库逻辑备份，然后对所有数据文件进行了...
r语言插补法_R语言实现基于多重插补的广义模型
weixin_36242060的博客
12-30 2253
数据有缺失，是一件令人不愉快的事情。然而，无论是回顾性研究还是前瞻性的研究，都可能难以避免数据缺失。那么，当你拿到了一份数据，发现其中有个别或一些缺失，你会如何处理呢？目前，可供选择的做法大概有以下两种：1.若缺失较少，且样本量较大，这时选择删除缺失的观测行，也是无伤根本的；2.若样本量不大，缺失比例也不是很小(比如5%-10%的缺失)，或者无论样本量有多大，你就是不想删除这5%-10%的缺失，那...
Excel菜鸟学习笔记
热门推荐
weixin_41745696的博客
07-06 1万+
一、常用的分析模型： 波特五力模型：用于行业分析和商业战略研究 SWOT分析模型：用于市场分析（strength、weakness、opportunity、threats） 5W2H分析模型：用于解决问题（what、why、when、where、who、how、how much） PEST分析模型：用于宏观环境分析（political、economic、social、technologic...
集合的并交补差
04-01
- **输入元素**：`Inputelem`函数用于批量输入元素，用户可以依次输入多个元素的值。 - **展示列表**：`show`函数用于显示列表中的所有元素。 - **排序**：虽然提供的代码中没有明确提到，但在实际应用中可能需要...
基于GPS+物联网技术的智能时钟系统设计与开发.pdf
07-01
在服务器端，设计利用DSP（数字信号处理器）模块采集GPS信号，并通过软件算法补差校验，从而获得中国标准的北京时间信息。作为时间源，该时间信息是网络内所有时钟终端的时间参考。 时钟终端设计要求每个终端具备...
汕头世标企管项目营销系统实施应用方案v1.0.doc
09-22
销售管理基本参数则允许系统适应不同项目的需求，提供付款方式、代收代付费用、调查问卷等个性化配置，还支持价格补差公式的自定义，以确保业务规则和管理流程的灵活性。 此外，系统还具备房源推盘管理功能，集团...
Datagridview数据写入DataTable
刘召
03-16 2518
<br /><br />System.Data.DataTable dt = new System.Data.DataTable();<br />            dt.Clear();<br /> <br />            foreach (DataGridViewColumn headerCell in dataGridView1.Columns)<br />            {<br />                dt.Columns.Add(headerCell.Head
WebServices开发实例
刘召
09-16 2101
using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Text; using System.IO; using System.Collections;
DataGridView添加行号
刘召
03-14 1625
用DataGridView的RowPostPaint事件在RowHeaderCell中绘制行号： RowPostPaint private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) { try
C# 控制台输入输出非字符串类型数据的方法[进制数字转换为八进制数字]
刘召
09-14 1530
using System;using System.Collections.Generic;using System.Text;using System.Collections;namespace ConsoleApplication3{    class Program    {        static void Main(string[] args)        {            //利用栈的原理,把十进制数字转换为八进制数字            Stack s = new Stack(
Web Services开发总结三 一个简单的XML格式定义
刘召
08-29 593
C# 控制台应用程序using System; using System.Collections.Generic; using System.Text;using System.Xml; namespace XML_Example {     class Program     {         static void Main(string[] args)         {             XmlDocument doc = new XmlDocument();      
python多重补差法
最新发布
08-02
Python中的多重补丁（Multiple Dispatch）并不是直接内置的功能，因为它是动态类型语言，不像静态类型语言（如C++通过模板等机制支持）。然而，虽然Python本身没有原生的多重继承或多态处理，但我们可以通过一些设计模式和第三方库来模拟类似的效果。 例如，你可以使用`functools`模块的` singledispatch `函数来实现单方法分发，它允许基于函数输入类型的不同执行不同的函数。如果需要更复杂的情况，可以考虑使用元编程库如`dispatch`或自定义装饰器，以及更深入地结合类和继承来实现类似于C++中的多态功能。 另外，如果你指的是数据结构的多重索引（比如Pandas DataFrame），那是完全不同的概念，它允许对二维数据表按多个列进行操作，而不是方法分发。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值