//datagridview初始化方法  
private void dgvHeadInit(int id)
        {
           
            string sql1 = @"select id,
                            worktimeNo as 工序代码,
                            initialCount as 起始针数,
                            seamDistance as 车缝距离, 
                            endCount as 落回针数,
                            initialCount+seamDistance+endCount as [每小时指标(件)],
                            worktimeName as 工序名称,
                            samTime as SAM值,
                            target AS 工序指标,
                            equipment as 使用设备,
                            tool as 使用工具,
                            pid 
                            from product_desProductTime 
                            where pid=" + id + " and positation='头部' and fno='"+txtfNo.Text+"'";
            
            SqlConnection cn = new SqlConnection("server=172.20.50.4;uid=sa;pwd=p4japo020;database=gsd");
            sda1 = new SqlDataAdapter(sql1, cn);
            ds1 = new DataSet();
            sda1.Fill(ds1);


            ds1.Tables[0].TableName = "product_desProductTime";



            
            dgvHead.DataSource = ds1.Tables[0];
            dgvHead.Columns["id"].Visible = false;
}

  //更新数据源的方法
        private int UpdateByDataSet(DataSet ds, string strTblName, string strconn)
        {


      try
            {
           
                
                SqlConnection cn = new SqlConnection(strconn);
                SqlDataAdapter sda = new SqlDataAdapter();
                SqlCommand cmd = new SqlCommand(@"select id,
                            worktimeNo as 工序代码,
                            initialCount as 起始针数,
                            seamDistance as 车缝距离, 
                            endCount as 落回针数,
                            worktimeName as 工序名称,
                            samTime as SAM值,
                            target AS 工序指标,
                            equipment as 使用设备,
                            tool as 使用工具,
                            pid from " + strTblName + "", cn);
                sda.SelectCommand = cmd;
                SqlCommandBuilder cb = new SqlCommandBuilder(sda);
                sda.Update(ds1,strTblName);
                
             

                return 0;
            }
            catch (Exception ee)
            {

                MessageBox.Show(ee.ToString());
                return -1;
            }
        }

  //保存按钮:更新操作(主表和子表)
        private void btnSave_Click(object sender, EventArgs e)
        {
            //int id = 0;
            //保存到数据库之前先判断一下主表是否有重复记录
            string fno = txtfNo.Text.Trim();
            string fname = txtPname.Text.Trim();
            int orderqty = Convert.ToInt32(txtOrderQty.Text);
            double orderc = Convert.ToDouble(txtOrderCoefficient.Text);
            Image pic = pbchef.Image;
            int flag = 2;
            flag= UpdateByDataSet(ds1, "product_desProductTime",strconn);




        }