using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;
using Stone.Entity;
using Gm_WMS.DataAccess.DataService;
using Stone.Common;

namespace Stone.WinBiz.BasicData
{
    public class F_Part_ValidityDays : F_Base
    {
        public F_Part_ValidityDays()
        {
            this.type = "Part_ValidityDays";
            this.name = "基础资料_物料与保质期对应关系";
            this.entity = new Entity_t_Part_ValidityDays();
        }

        public override void GetView(DataGridView dgv)
        {
            base.GetView(dgv);

            dgv.Columns["PartCode"].HeaderText = "零件编号";
            dgv.Columns["ValidityDays"].HeaderText = "质保期(天)";
            dgv.Columns["Memo"].HeaderText = "备注";


        }

        public override void Checking(DataRow drData, bool isNew)
        {
            if (drData["PartCode"].ToString().Trim() == "")
                throw new Exception("零件编号 不能为空!");
            //零件校验
            //Entity_t_Dep t_Dep = new Entity_t_Dep();
            //if (t_Dep.GetData("[DepCode]='" + drData["DepCode"].ToString() + "'").Tables[0].Rows.Count == 0)
            //    throw new Exception("部门编号 " + drData["DepCode"].ToString() + " 在系统中不存在");

            if (isNew)
            {
                if (entity.GetData("", "PartCode='" + drData["PartCode"].ToString() + "'", "id asc").Tables[0].Rows.Count > 0)
                    throw new Exception("编号 " + drData["PartCode"].ToString() + " 已经存在！");

            }
            else
            {
                if (entity.GetData("", "[ID]<>" + drData["ID"].ToString() + " and PartCode='" + drData["PartCode"].ToString() + "'", "id asc").Tables[0].Rows.Count > 0)
                    throw new Exception("编号 " + drData["PartCode"].ToString() + " 已经存在！");
            }
        }
       
        public override void InputData(DataSet dsData, LocalDBService db)
        {
            Entity_t_Part_ValidityDays t_Input = new Entity_t_Part_ValidityDays(db);
            DataRow drInput = null;

            foreach (DataRow drData in dsData.Tables[0].Rows)
            {

                drInput = t_Input.Table.NewRow();
                drInput["PartCode"] = MyStrings.GetString(drData["零件编号"].ToString().Trim());
                drInput["ValidityDays"] = MyStrings.GetString(drData["质保期(天)"].ToString().Trim());
                drInput["Memo"] = MyStrings.GetString(drData["备注"].ToString().Trim());


                if (drInput["PartCode"].ToString().Trim() == "")
                    throw new Exception("零件编号 不能为空!");

                if (drInput["ValidityDays"].ToString().Trim() == "")
                    throw new Exception("质保期 不能为空!");
               
                t_Input.Add(drInput);

            }
        }
    }
}