예제 #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Tunnel.Model.Tunnel_items GetModel(int i_id)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@i_id", SqlDbType.Int, 4)
            };
            parameters[0].Value = i_id;

            Tunnel.Model.Tunnel_items model = new Tunnel.Model.Tunnel_items();
            DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_items_GetModel", parameters, "ds");

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["i_id"].ToString() != "")
                {
                    model.i_id = int.Parse(ds.Tables[0].Rows[0]["i_id"].ToString());
                }
                model.i_name = ds.Tables[0].Rows[0]["i_name"].ToString();
                model.year   = ds.Tables[0].Rows[0]["year"].ToString();
                model.moon   = ds.Tables[0].Rows[0]["moon"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
예제 #2
0
    public void ListBind2()
    {
        Tunnel.BLL.Tunnel_items          ti    = new Tunnel.BLL.Tunnel_items();
        Tunnel.Model.Tunnel_items        tii   = new Tunnel.Model.Tunnel_items();
        List <Tunnel.Model.Tunnel_items> ilist = new List <Tunnel.Model.Tunnel_items>();

        DropDownList1.Items.Clear();
        ilist = ti.GetModelList(" year='" + DropDownList2.SelectedValue + "' and  moon='" + DropDownList3.SelectedValue + "'");
        foreach (Tunnel.Model.Tunnel_items item in ilist)
        {
            DropDownList1.Items.Add(new ListItem(item.i_name, item.i_id.ToString()));
        }
        DropDownList1.Items.Insert(0, new ListItem("请选择", "0"));
    }
예제 #3
0
        /// <summary>
        ///  更新一条数据
        /// </summary>
        public void Update(Tunnel.Model.Tunnel_items model)
        {
            int rowsAffected;

            SqlParameter[] parameters =
            {
                new SqlParameter("@i_id",   SqlDbType.Int,      4),
                new SqlParameter("@i_name", SqlDbType.VarChar, 50),
                new SqlParameter("@year",   SqlDbType.VarChar, 50),
                new SqlParameter("@moon",   SqlDbType.VarChar, 50)
            };
            parameters[0].Value = model.i_id;
            parameters[1].Value = model.i_name;
            parameters[2].Value = model.year;
            parameters[3].Value = model.moon;

            DbHelperSQL.RunProcedure("UP_Tunnel_items_Update", parameters, out rowsAffected);
        }
예제 #4
0
        /// <summary>
        ///  增加一条数据
        /// </summary>
        public int Add(Tunnel.Model.Tunnel_items model)
        {
            int rowsAffected;

            SqlParameter[] parameters =
            {
                new SqlParameter("@i_id",   SqlDbType.Int,      4),
                new SqlParameter("@i_name", SqlDbType.VarChar, 50),
                new SqlParameter("@year",   SqlDbType.VarChar, 50),
                new SqlParameter("@moon",   SqlDbType.VarChar, 50)
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.i_name;
            parameters[2].Value     = model.year;
            parameters[3].Value     = model.moon;

            DbHelperSQL.RunProcedure("UP_Tunnel_items_ADD", parameters, out rowsAffected);
            return((int)parameters[0].Value);
        }
예제 #5
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <Tunnel.Model.Tunnel_items> DataTableToList(DataTable dt)
        {
            List <Tunnel.Model.Tunnel_items> modelList = new List <Tunnel.Model.Tunnel_items>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                Tunnel.Model.Tunnel_items model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new Tunnel.Model.Tunnel_items();
                    if (dt.Rows[n]["i_id"].ToString() != "")
                    {
                        model.i_id = int.Parse(dt.Rows[n]["i_id"].ToString());
                    }
                    model.i_name = dt.Rows[n]["i_name"].ToString();
                    model.year   = dt.Rows[n]["year"].ToString();
                    model.moon   = dt.Rows[n]["moon"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
예제 #6
0
        public List <Tunnel.Model.Tunnel_items> GetList(PageBase pb, ref int count)
        {
            DataTable dt = dal.GetList(pb, ref count).Tables[0];
            List <Tunnel.Model.Tunnel_items> modelList = new List <Tunnel.Model.Tunnel_items>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0 && pb.DoCount == 0)
            {
                Tunnel.Model.Tunnel_items model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new Tunnel.Model.Tunnel_items();
                    if (dt.Rows[n]["i_id"].ToString() != "")
                    {
                        model.i_id = int.Parse(dt.Rows[n]["i_id"].ToString());
                    }
                    model.i_name = dt.Rows[n]["i_name"].ToString();
                    model.year   = dt.Rows[n]["year"].ToString();
                    model.moon   = dt.Rows[n]["moon"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
예제 #7
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        Tunnel.BLL.Tunnel_items   ti  = new Tunnel.BLL.Tunnel_items();
        Tunnel.Model.Tunnel_items tii = new Tunnel.Model.Tunnel_items();
        tii.i_name = txtItems.Text.Trim();
        tii.year   = TextBox1.Text;
        tii.moon   = TextBox2.Text;

        if (ti.GetModelList("1=1 and i_name = '" + tii.i_name + "' and year = '" + tii.year + "' and moon = '" + tii.moon + "'").Count == 0)
        {
            if (ti.Add(tii) > 0)
            {
                Tunnel.Common.Message.Show("添加工程项目成功!");
            }
            else
            {
                Tunnel.Common.Message.Show("添加工程项目失败!");
            }
        }
        else
        {
            Tunnel.Common.Message.Show("本月存在该项目!");
        }
    }
예제 #8
0
    public void ListBind()
    {
        DropDownList1.Items.Clear();
        DropDownList2.Items.Clear();
        DropDownList3.Items.Clear();
        Tunnel.BLL.Tunnel_items          ti    = new Tunnel.BLL.Tunnel_items();
        Tunnel.Model.Tunnel_items        tii   = new Tunnel.Model.Tunnel_items();
        List <Tunnel.Model.Tunnel_items> ilist = new List <Tunnel.Model.Tunnel_items>();

        for (int i = 2009; i < 2019; i++)
        {
            DropDownList2.Items.Add(new ListItem(i.ToString(), i.ToString()));
        }
        for (int i = 1; i < 13; i++)
        {
            if (i.ToString().Length == 2)
            {
                DropDownList3.Items.Add(new ListItem(i.ToString(), i.ToString()));
            }
            else
            {
                DropDownList3.Items.Add(new ListItem("0" + i.ToString(), "0" + i.ToString()));
            }
        }
        DateTime dt = DateTime.Now.AddMonths(-1);

        DropDownList2.Items.FindByValue(dt.Year.ToString()).Selected = true;
        DropDownList3.Items.FindByValue(dt.Month.ToString().Length > 1 ? dt.Month.ToString() : "0" + dt.Month.ToString()).Selected = true;

        ilist = ti.GetModelList(" year='" + DropDownList2.SelectedValue + "' and  moon='" + DropDownList3.SelectedValue + "'");
        foreach (Tunnel.Model.Tunnel_items item in ilist)
        {
            DropDownList1.Items.Add(new ListItem(item.i_name, item.i_id.ToString()));
        }
        DropDownList1.Items.Insert(0, new ListItem("请选择", "0"));
    }
예제 #9
0
파일: Xjb.aspx.cs 프로젝트: 262734254/OA
    public void ListBind()
    {
        nianyue = DropDownList1.SelectedValue;

        Tunnel.BLL.Tunnel_menber          tm     = new Tunnel.BLL.Tunnel_menber();
        Tunnel.Model.Tunnel_menber        tmm    = new Tunnel.Model.Tunnel_menber();
        List <Tunnel.Model.Tunnel_menber> tmList = new List <Tunnel.Model.Tunnel_menber>();

        Tunnel.BLL.Tunnel_work          tw     = new Tunnel.BLL.Tunnel_work();
        Tunnel.Model.Tunnel_work        tww    = new Tunnel.Model.Tunnel_work();
        List <Tunnel.Model.Tunnel_work> twList = new List <Tunnel.Model.Tunnel_work>();

        Tunnel.BLL.Tunnel_grade          tg     = new Tunnel.BLL.Tunnel_grade();
        Tunnel.Model.Tunnel_grade        tgg    = new Tunnel.Model.Tunnel_grade();
        List <Tunnel.Model.Tunnel_grade> tgList = new List <Tunnel.Model.Tunnel_grade>();

        Tunnel.BLL.Tunnel_items          ti     = new Tunnel.BLL.Tunnel_items();
        Tunnel.Model.Tunnel_items        tii    = new Tunnel.Model.Tunnel_items();
        List <Tunnel.Model.Tunnel_items> tiList = new List <Tunnel.Model.Tunnel_items>();

        Tunnel.BLL.Tunnel_check          tc     = new Tunnel.BLL.Tunnel_check();
        Tunnel.Model.Tunnel_check        tcc    = new Tunnel.Model.Tunnel_check();
        List <Tunnel.Model.Tunnel_check> tcList = new List <Tunnel.Model.Tunnel_check>();

        List <Tunnel.Model.Tunnel_ReadCheckList> trList = new List <Tunnel.Model.Tunnel_ReadCheckList>();

        tcList = tc.GetModelList("c_date='" + nianyue + "'");

        foreach (Tunnel.Model.Tunnel_check itemCheck in tcList)
        {
            Tunnel.Model.Tunnel_ReadCheckList tr    = new Tunnel.Model.Tunnel_ReadCheckList();
            List <Tunnel.Model.Tunnel_check>  clist = new List <Tunnel.Model.Tunnel_check>();

            tr.ItemsID   = Convert.ToInt32(itemCheck.c_itemsId);
            tr.ItemsName = ti.GetModel(Convert.ToInt32(itemCheck.c_itemsId)).i_name;
            tr.UserId    = Convert.ToInt32(itemCheck.c_userId);
            tr.UserName  = tm.GetModel(Convert.ToInt64(itemCheck.c_userId.ToString())).m_name;
            tgList       = tg.GetModelList("g_checkid=" + itemCheck.c_id + "");
            tr.AqscCent  = 0;
            tr.CbkzCent  = 0;
            tr.ClglCent  = 0;
            tr.DzbgzCent = 0;
            tr.GbgzCent  = 0;
            tr.GczlCent  = 0;
            tr.SbglCent  = 0;
            tr.ScjhCent  = 0;
            tr.WmsgCent  = 0;
            tr.XcgzCent  = 0;
            tr.XnzhCent  = 0;
            tr.XxgzCent  = 0;
            tr.ZhzlCent  = 0;
            if (tgList.Count > 0)
            {
                foreach (Tunnel.Model.Tunnel_grade item in tgList)
                {
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "成本控制")
                    {
                        tr.CbkzCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "虚拟账户")
                    {
                        tr.XnzhCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "生产计划")
                    {
                        tr.ScjhCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "文明施工")
                    {
                        tr.WmsgCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "安全生产")
                    {
                        tr.AqscCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "工程质量")
                    {
                        tr.GczlCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "设备管理")
                    {
                        tr.SbglCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "材料管理")
                    {
                        tr.ClglCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "综合治理")
                    {
                        tr.ZhzlCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "贯标工作")
                    {
                        tr.GbgzCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "宣传工作")
                    {
                        tr.XcgzCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "党支部工作")
                    {
                        tr.DzbgzCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                    if (tw.GetModel(Convert.ToInt32(item.g_workId)).w_workName == "信息工作")
                    {
                        tr.XxgzCent = Convert.ToSingle(item.g_cent.ToString());
                    }
                }
            }

            tr.AllCent = tr.AqscCent +
                         tr.CbkzCent +
                         tr.ClglCent +
                         tr.DzbgzCent +
                         tr.GbgzCent +
                         tr.GczlCent +
                         tr.SbglCent +
                         tr.ScjhCent +
                         tr.WmsgCent +
                         tr.XcgzCent +
                         tr.XnzhCent +
                         tr.XxgzCent +
                         tr.ZhzlCent;
            trList.Add(tr);
        }
        GridView1.DataSource = trList;
        GridView1.DataBind();
    }
예제 #10
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(Tunnel.Model.Tunnel_items model)
 {
     dal.Update(model);
 }
예제 #11
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(Tunnel.Model.Tunnel_items model)
 {
     return(dal.Add(model));
 }