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();
}
}