using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Maticsoft.BLL;
using System.Data;
using System.Data.SqlClient;
using Ajax;
public partial class Picking_Formt : CommonPage
{
     //创建一个生产领料记录模板
    Maticsoft.Model.nr_z_scdck scdck = new Maticsoft.Model.nr_z_scdck();
    //创建一个生产领料记录bll
    Maticsoft.BLL.nr_z_scdck scdckbll = new Maticsoft.BLL.nr_z_scdck();
    //创建一个操作记录模板
    Maticsoft.Model.nr_sys_rizhi rizhi = new Maticsoft.Model.nr_sys_rizhi();
    //创建一个操作记录bll
    Maticsoft.BLL.nr_sys_rizhi rizhibll = new Maticsoft.BLL.nr_sys_rizhi();
    protected void Page_Load(object sender, EventArgs e)
    {
        Utility.RegisterTypeForAjax(typeof(Picking_Formt));
        if (!IsPostBack)
        {
            if (Session["user"] == null)
            {
                Response.Redirect("../index.aspx");
            }
            //获取角色权限
            Maticsoft.Model.nr_z_yhzh user = (Maticsoft.Model.nr_z_yhzh)(Session["user"]);
            llr.Value = user.zhanghao;
            binddata();
            pdquanxianbj(user.juese);
            if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString().Length > 0)
            {

                if (Request.QueryString["lx"].ToString() == "ll")
                {
                    string uid = Request.QueryString["uid"].ToString();
                    string djbh = Request.QueryString["djbh"].ToString();

                    id.Value = uid;
                    initdata(uid, djbh);
                    //修改时拼出导航
                 }
                else {
                    string uid = Request.QueryString["uid"].ToString();
                    string djbh = Request.QueryString["djbh"].ToString();

                    id.Value = uid;
                    initdatabl(uid, djbh); 
                }
               
            }
            else if (Request.QueryString["bid"] != null && Request.QueryString["bid"].ToString().Length > 0)
            { 
                string bid = Request.QueryString["bid"].ToString();
                id.Value = bid;
                initdataedit(bid);
            }

        }
    }
    #region 用来初始化绑定下拉框等值
    private void binddata()
    {
        llrq.Value = DateTime .Now .ToString ("yyyy-MM-dd HH:mm");
        zhuangtai.Value = "待确认";
     
    }
    #endregion
    #region 获取出库数据值
    private void initdata(string did,string djbhs)
    {
        DataTable dt = DBHlper.Execute("select * from view_nr_z_scddll where id=" + did + " and bh='" + djbhs + "'").Tables[0];
        if (dt!= null&&dt.Rows.Count>0)
        {
            djbh.Text = dt.Rows[0]["bh"].ToString(); 
            khbh.Text = dt.Rows[0]["kh_bh"].ToString();
            khmc.Text = dt.Rows[0]["khmc"].ToString();
            cpmc.Value = dt.Rows[0]["cpmc"].ToString();
            wlbh.Value = dt.Rows[0]["wlbh"].ToString();
            wlmc.Value = dt.Rows[0]["wlmc"].ToString();
            kf.Value = dt.Rows[0]["kufang"].ToString();
            zhonglei.Value = dt.Rows[0]["zhonglei"].ToString();
            pinpai.Value = dt.Rows[0]["pinpai"].ToString();
            guige.Value = dt.Rows[0]["guige"].ToString();
            danwei.Value = dt.Rows[0]["danwei"].ToString();  
            double  dlsl =Convert .ToDouble( dt.Rows[0]["sjsl"].ToString())-Convert .ToDouble ( dt.Rows[0]["ylsl"].ToString());
            llsl.Value = dlsl.ToString();
            dj.Value = dt.Rows[0]["wldj"].ToString();
            double je=Convert.ToDouble(dlsl) * Convert.ToDouble(dj.Value);


            jine.Value = double.Parse(String.Format("{0:N2}", je)).ToString();
            
        }
    }

    private void initdatabl(string did, string djbhs)
    {
        DataTable dt = DBHlper.Execute("select * from view_nr_z_scdbl where id=" + did + " and bh='" + djbhs + "'").Tables[0];
        if (dt != null && dt.Rows.Count > 0)
        {
            djbh.Text = dt.Rows[0]["bh"].ToString(); 
            khbh.Text = dt.Rows[0]["kh_bh"].ToString();
            khmc.Text = dt.Rows[0]["khmc"].ToString();
            cpmc.Value = dt.Rows[0]["cpmc"].ToString();
            wlbh.Value = dt.Rows[0]["wlbh"].ToString();
            wlmc.Value = dt.Rows[0]["wlmc"].ToString();
            kf.Value = dt.Rows[0]["kufang"].ToString();
            zhonglei.Value = dt.Rows[0]["zhonglei"].ToString();
            pinpai.Value = dt.Rows[0]["pinpai"].ToString();
            guige.Value = dt.Rows[0]["guige"].ToString();
            danwei.Value = dt.Rows[0]["danwei"].ToString(); 
            double dlsl = Convert.ToDouble(dt.Rows[0]["sjsl"].ToString()) - Convert.ToDouble(dt.Rows[0]["ylsl"].ToString());
            llsl.Value ="0";
            dj.Value = dt.Rows[0]["wldj"].ToString();
            double je = Convert.ToDouble(dlsl) * Convert.ToDouble(dj.Value); 
            jine.Value = double.Parse(String.Format("{0:N2}", je)).ToString();

        }
    }

    #endregion
    #region 获取编辑数据值
    private void initdataedit(string did)
    {
         DataTable dt = DBHlper.Execute("select * from view_nr_z_scdck where id=" + did).Tables[0];
         if (dt != null && dt.Rows.Count > 0)
         {
             ckbh.Text = dt.Rows[0]["ckbh"].ToString();
             djbh.Text = dt.Rows[0]["scdbh"].ToString();  
             khbh.Text = dt.Rows[0]["kh_bh"].ToString();
             khmc.Text = dt.Rows[0]["khmc"].ToString();
             cpmc.Value = dt.Rows[0]["cpmc"].ToString();
             wlbh.Value = dt.Rows[0]["wlbh"].ToString();
             wlmc.Value = dt.Rows[0]["wlmc"].ToString();
             kf.Value = dt.Rows[0]["kufang"].ToString();
             zhonglei.Value = dt.Rows[0]["zhonglei"].ToString();
             pinpai.Value = dt.Rows[0]["pinpai"].ToString();
             guige.Value = dt.Rows[0]["guige"].ToString();
             danwei.Value = dt.Rows[0]["danwei"].ToString();
             llr.Value = dt.Rows[0]["jsr"].ToString();
             llrq.Value = dt.Rows[0]["ckrq"].ToString();
             zhuangtai.Value = dt.Rows[0]["ckzt"].ToString(); 
             llsl.Value = dt.Rows[0]["ylsl"].ToString();
             beizhu.Text = dt.Rows[0]["bz"].ToString();
         }
    }
    #endregion
    #region 领料时获取页面参数赋值model对象
    private void getmd()
    {
        scdck.ckrq = Convert.ToDateTime(llrq.Value);
        scdck.xmid = Convert.ToInt32(id.Value);
        scdck.wlbh = wlbh.Value;
        scdck.sl =Convert.ToDecimal(llsl.Value);
        scdck.jsr = llr.Value;
        scdck.zt = zhuangtai.Value;
        scdck.bz = beizhu.Text;
        scdck.djbh = djbh.Text;

        if (Request.QueryString["lx"].ToString() == "ll")
        {
            scdck.lx = "生产领料";
        }
        else {
            scdck.lx = "补料";
        }

        //给日志模板赋值
        rizhi.riqi = DateTime.Now;

        scdck.jine  =Convert.ToDecimal( jine.Value);

        rizhi.leixing = "生产领料";


    }
    #endregion
    #region 编辑时获取页面参数赋值model对象
    private void getmdbj()
    {
        scdck.ckrq = Convert.ToDateTime(llrq.Value);
        scdck = scdckbll.GetModel(Convert.ToInt32(id.Value));
        scdck.sl = Convert.ToDecimal(llsl.Value);
        scdck.bz = beizhu.Text;
        //给日志模板赋值
        rizhi.riqi = DateTime.Now;
        rizhi.leixing = "生产领料";


    }
    #endregion
    #region 编辑权限查看
    void pdquanxianbj(int juese)
    {
        Maticsoft.Model.nr_z_yhzh user = (Maticsoft.Model.nr_z_yhzh)(Session["user"]);
        if (DBHlper.getzt(user.id) != 1)
        {
            Response.Redirect("../index.aspx");
        }
        if (DBHlper.GetPermission(juese, "生产领料记录", "nr_z_scdck", "编辑个人") == false && DBHlper.GetPermission(juese, "生产领料记录", "nr_z_scdck", "编辑全部") == false)
        {
            Response.Redirect("../Common/nopower.htm");
        }


    }

    #endregion
    //保存操作
    protected void bt_tj_Click(object sender, EventArgs e)
    {
        try
        {
            string caozuo = "进行";
          
            //接收成功参数值
           int rtx = 0;
           if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString().Length > 0)
           {
               getmd();
               scdck.ckbh = DBHlper.getbh("SCCK-", "nr_z_scdck", "ckbh", 4);
               ckbh.Text = scdck.ckbh;
               rtx = scdckbll.Add(scdck);
           }
           else
           {
               getmdbj();
               if (scdckbll.Update(scdck))
               {
                   rtx =Convert.ToInt32(id.Value);
                   caozuo = "修改";
               }
           }

            if (rtx > 0)
            {
                //将session转换对象取值
                Maticsoft.Model.nr_z_yhzh zh = (Maticsoft.Model.nr_z_yhzh)Session["user"];
                rizhi.yonghuming = zh.zhanghao;
                //拼接字符串插入日志
                rizhi.jilu = zh.zhanghao + caozuo + "了生产单领料，档案编号为：" + ckbh.Text.Trim();
                rizhibll.Add(rizhi);
                Response.Redirect("Picking_browse.aspx?uid=" + rtx, false);
            }
            else
            {
                Response.Redirect("../Common/error.aspx");

            }

        }
        catch (Exception)
        {
            Response.Redirect("../Common/error.aspx");
        }


    }
}