public void m_mthCpyLimitTime() { long lngRes = 0; DataTable dtResult = null; lngRes = m_objManage.lngGetLimitTime(out dtResult, applyunitId); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow dr = dtResult.Rows[0]; if (this.dgvCpyItem.Rows.Count > 0) { for (int i = 0; i < this.dgvCpyItem.Rows.Count; i++) { DataTable dt = new DataTable("Datas"); DataColumn dc = new DataColumn(); dc.AutoIncrement = true; //自动增加 dc.AutoIncrementSeed = 1; //起始为1 dc.AutoIncrementStep = 1; //步长为1 dc.AllowDBNull = false; // dc = dt.Columns.Add("applyunitid", Type.GetType("System.String")); dc = dt.Columns.Add("week1", Type.GetType("System.String")); dc = dt.Columns.Add("week2", Type.GetType("System.String")); dc = dt.Columns.Add("normalLimit", Type.GetType("System.String")); dc = dt.Columns.Add("emergencyLimit", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime1", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime2", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime3", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime4", Type.GetType("System.String")); dc = dt.Columns.Add("confirTime1", Type.GetType("System.String")); dc = dt.Columns.Add("confirTime2", Type.GetType("System.String")); dc = dt.Columns.Add("confirTime3", Type.GetType("System.String")); dc = dt.Columns.Add("confirTime4", Type.GetType("System.String")); dc = dt.Columns.Add("week3", Type.GetType("System.String")); dc = dt.Columns.Add("week4", Type.GetType("System.String")); dc = dt.Columns.Add("week5", Type.GetType("System.String")); dc = dt.Columns.Add("week6", Type.GetType("System.String")); dc = dt.Columns.Add("CONFIRMENDTIME", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime5", Type.GetType("System.String")); dc = dt.Columns.Add("acceptTime6", Type.GetType("System.String")); dc = dt.Columns.Add("timelimit5", Type.GetType("System.String")); dc = dt.Columns.Add("timelimit6", Type.GetType("System.String")); DataRow newRow; newRow = dt.NewRow(); newRow["applyunitid"] = dgvCpyItem.Rows[i].Cells[0].Value.ToString(); newRow["week1"] = dr["week1"].ToString(); newRow["week2"] = dr["week2"].ToString();; newRow["normalLimit"] = dr["normalLimit"].ToString(); newRow["emergencyLimit"] = dr["emergencyLimit"].ToString(); newRow["acceptTime1"] = dr["acceptTime1"].ToString(); newRow["acceptTime2"] = dr["acceptTime2"].ToString(); newRow["acceptTime3"] = dr["acceptTime3"].ToString(); newRow["acceptTime4"] = dr["acceptTime4"].ToString(); newRow["confirTime1"] = dr["confirtime1"].ToString(); newRow["confirTime2"] = dr["confirtime2"].ToString(); newRow["confirTime3"] = dr["confirtime3"].ToString(); newRow["confirTime4"] = dr["confirtime4"].ToString(); newRow["week3"] = dr["week3"].ToString(); newRow["week4"] = dr["week4"].ToString(); newRow["week5"] = dr["week5"].ToString(); newRow["week6"] = dr["week6"].ToString(); newRow["confirmendtime"] = dr["confirmendtime"].ToString(); newRow["acceptTime5"] = dr["acceptTime5"].ToString(); newRow["acceptTime6"] = dr["acceptTime6"].ToString(); newRow["timelimit5"] = dr["timelimit5"].ToString(); newRow["timelimit6"] = dr["timelimit6"].ToString(); dt.Rows.Add(newRow); lngRes = m_objManage.lngSaveLimitTime(dt); } if (lngRes > 0) { MessageBox.Show("复制成功 !"); } } } }
public void m_mthGetLimitTime() { long lngRes = 0; string applyunitid = string.Empty; DataTable dt = null; if (m_objViewer.dgvItem.Rows.Count > 0) { applyunitid = m_objViewer.dgvItem.CurrentRow.Cells["项目编码"].Value.ToString(); } else { return; } if (string.IsNullOrEmpty(applyunitid)) { return; } clear(); lngRes = m_objManage.lngGetLimitTime(out dt, applyunitid); if (lngRes > 0 && dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; m_objViewer.cboWeek_1.Text = dr["week1"].ToString(); m_objViewer.cboWeek_2.Text = dr["week2"].ToString(); m_objViewer.cboWeek_3.Text = dr["week3"].ToString(); m_objViewer.cboWeek_4.Text = dr["week4"].ToString(); m_objViewer.cboWeek_5.Text = dr["week5"].ToString(); m_objViewer.cboWeek_6.Text = dr["week6"].ToString(); m_objViewer.txtNormal.Text = dr["normalLimit"].ToString(); m_objViewer.txtEmergency.Text = dr["emergencyLimit"].ToString(); m_objViewer.txtTimeLimit5.Text = dr["timelimit5"].ToString(); m_objViewer.txtTimeLimit6.Text = dr["timelimit6"].ToString(); if (!string.IsNullOrEmpty(dr["acceptTime1"].ToString())) { m_objViewer.cboAceepH_1.Text = dr["acceptTime1"].ToString().Split(':')[0]; m_objViewer.cboAceepM_1.Text = dr["acceptTime1"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["acceptTime2"].ToString())) { string acceptTimePre2 = dr["acceptTime2"].ToString().Split('~')[0]; string acceptTime2 = dr["acceptTime2"].ToString().Split('~')[1]; m_objViewer.cboAceepHPre_2.Text = acceptTimePre2.Split(':')[0]; m_objViewer.cboAceepMPre_2.Text = acceptTimePre2.Split(':')[1]; m_objViewer.cboAceepH_2.Text = acceptTime2.Split(':')[0]; m_objViewer.cboAceepM_2.Text = acceptTime2.Split(':')[1]; } if (!string.IsNullOrEmpty(dr["acceptTime3"].ToString())) { string acceptTimePre3 = dr["acceptTime3"].ToString().Split('~')[0]; string acceptTime3 = dr["acceptTime3"].ToString().Split('~')[1]; m_objViewer.cboAceepHPre_3.Text = acceptTimePre3.Split(':')[0]; m_objViewer.cboAceepMPre_3.Text = acceptTimePre3.Split(':')[1]; m_objViewer.cboAceepH_3.Text = acceptTime3.Split(':')[0]; m_objViewer.cboAceepM_3.Text = acceptTime3.Split(':')[1]; } if (!string.IsNullOrEmpty(dr["acceptTime4"].ToString())) { m_objViewer.cboAceepH_4.Text = dr["acceptTime4"].ToString().Split(':')[0]; m_objViewer.cboAceepM_4.Text = dr["acceptTime4"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["acceptTime5"].ToString())) { string acceptTimePre5 = dr["acceptTime5"].ToString().Split('~')[0]; string acceptTime5 = dr["acceptTime5"].ToString().Split('~')[1]; m_objViewer.cboAceepHPre_5.Text = acceptTimePre5.Split(':')[0]; m_objViewer.cboAceepMPre_5.Text = acceptTimePre5.Split(':')[1]; m_objViewer.cboAceepH_5.Text = acceptTime5.Split(':')[0]; m_objViewer.cboAceepM_5.Text = acceptTime5.Split(':')[1]; } if (!string.IsNullOrEmpty(dr["acceptTime6"].ToString())) { string acceptTimePre6 = dr["acceptTime6"].ToString().Split('~')[0]; string acceptTime6 = dr["acceptTime6"].ToString().Split('~')[1]; m_objViewer.cboAceepHPre_6.Text = acceptTimePre6.Split(':')[0]; m_objViewer.cboAceepMPre_6.Text = acceptTimePre6.Split(':')[1]; m_objViewer.cboAceepH_6.Text = acceptTime6.Split(':')[0]; m_objViewer.cboAceepM_6.Text = acceptTime6.Split(':')[1]; } if (!string.IsNullOrEmpty(dr["confirmendtime"].ToString())) { m_objViewer.cboConfirEndH.Text = dr["confirmendtime"].ToString().Split(':')[0]; m_objViewer.cboConfirEndM.Text = dr["confirmendtime"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["confirtime1"].ToString())) { m_objViewer.cboConfirH_1.Text = dr["confirtime1"].ToString().Split(':')[0]; m_objViewer.cboConfirM_1.Text = dr["confirtime1"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["confirtime2"].ToString())) { m_objViewer.cboConfirH_2.Text = dr["confirtime2"].ToString().Split(':')[0]; m_objViewer.cboConfirM_2.Text = dr["confirtime2"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["confirtime3"].ToString())) { m_objViewer.cboConfirH_3.Text = dr["confirtime3"].ToString().Split(':')[0]; m_objViewer.cboConfirM_3.Text = dr["confirtime3"].ToString().Split(':')[1]; } if (!string.IsNullOrEmpty(dr["confirtime4"].ToString())) { m_objViewer.cboConfirH_4.Text = dr["confirtime4"].ToString().Split(':')[0]; m_objViewer.cboConfirM_4.Text = dr["confirtime4"].ToString().Split(':')[1]; } } else { clear(); } }