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_mthSaveLimitTime()
{
long lngRes = 0;
string applyunitid = string.Empty;
if (m_objViewer.dgvItem.Rows.Count > 0)
{
applyunitid = m_objViewer.dgvItem.CurrentRow.Cells["项目编码"].Value.ToString();
}
else
{
return;
}
if (string.IsNullOrEmpty(applyunitid))
{
return;
}
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"));
string week1 = m_objViewer.cboWeek_1.Text.Trim();
string week2 = m_objViewer.cboWeek_2.Text.Trim();
string week3 = m_objViewer.cboWeek_3.Text.Trim();
string week4 = m_objViewer.cboWeek_4.Text.Trim();
string week5 = m_objViewer.cboWeek_5.Text.Trim();
string week6 = m_objViewer.cboWeek_6.Text.Trim();
string normalLimit = m_objViewer.txtNormal.Text.Trim();
string emergencyLimit = m_objViewer.txtEmergency.Text.Trim();
string timelimit5 = m_objViewer.txtTimeLimit5.Text.Trim();
string timelimit6 = m_objViewer.txtTimeLimit6.Text.Trim();
#region ACCEPTTIME
string acceptTimeH1 = m_objViewer.cboAceepH_1.Text.Trim();;
string acceptTimeM1 = string.Empty;
string acceptTime1 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH1))
{
acceptTimeM1 = string.IsNullOrEmpty(m_objViewer.cboAceepM_1.Text.Trim()) ? "00" : m_objViewer.cboAceepM_1.Text.Trim();
acceptTime1 = acceptTimeH1 + ":" + acceptTimeM1;
}
string acceptTimeH2 = m_objViewer.cboAceepH_2.Text.Trim();;
string acceptTimeM2 = string.Empty;
string acceptTime2 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH2))
{
acceptTimeM2 = string.IsNullOrEmpty(m_objViewer.cboAceepM_2.Text.Trim()) ? "00" : m_objViewer.cboAceepM_2.Text.Trim();
acceptTime2 = acceptTimeH2 + ":" + acceptTimeM2;
}
string acceptTimeHPre2 = m_objViewer.cboAceepHPre_2.Text.Trim();;
string acceptTimeMPre2 = string.Empty;
string acceptTimePre2 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeHPre2))
{
acceptTimeMPre2 = string.IsNullOrEmpty(m_objViewer.cboAceepMPre_2.Text.Trim()) ? "00" : m_objViewer.cboAceepMPre_2.Text.Trim();
acceptTimePre2 = acceptTimeHPre2 + ":" + acceptTimeMPre2;
}
if (!string.IsNullOrEmpty(acceptTimeH2) && !string.IsNullOrEmpty(acceptTimeHPre2))
{
acceptTime2 = acceptTimePre2 + "~" + acceptTime2;
}
string acceptTimeH3 = m_objViewer.cboAceepH_3.Text.Trim();;
string acceptTimeM3 = string.Empty;
string acceptTime3 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH3))
{
acceptTimeM3 = string.IsNullOrEmpty(m_objViewer.cboAceepM_3.Text.Trim()) ? "00" : m_objViewer.cboAceepM_3.Text.Trim();
acceptTime3 = acceptTimeH3 + ":" + acceptTimeM3;
}
string acceptTimeHPre3 = m_objViewer.cboAceepHPre_3.Text.Trim();;
string acceptTimeMPre3 = string.Empty;
string acceptTimePre3 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeHPre3))
{
acceptTimeMPre3 = string.IsNullOrEmpty(m_objViewer.cboAceepMPre_3.Text.Trim()) ? "00" : m_objViewer.cboAceepMPre_3.Text.Trim();
acceptTimePre3 = acceptTimeHPre3 + ":" + acceptTimeMPre3;
}
if (!string.IsNullOrEmpty(acceptTimeH3) && !string.IsNullOrEmpty(acceptTimeHPre3))
{
acceptTime3 = acceptTimePre3 + "~" + acceptTime3;
}
string acceptTimeH4 = m_objViewer.cboAceepH_4.Text.Trim();;
string acceptTimeM4 = string.Empty;
string acceptTime4 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH4))
{
acceptTimeM4 = string.IsNullOrEmpty(m_objViewer.cboAceepM_4.Text.Trim()) ? "00" : m_objViewer.cboAceepM_4.Text.Trim();
acceptTime4 = acceptTimeH4 + ":" + acceptTimeM4;
}
string acceptTimeH5 = m_objViewer.cboAceepH_5.Text.Trim();;
string acceptTimeM5 = string.Empty;
string acceptTime5 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH5))
{
acceptTimeM5 = string.IsNullOrEmpty(m_objViewer.cboAceepM_5.Text.Trim()) ? "00" : m_objViewer.cboAceepM_5.Text.Trim();
acceptTime5 = acceptTimeH5 + ":" + acceptTimeM5;
}
string acceptTimeHPre5 = m_objViewer.cboAceepHPre_5.Text.Trim();;
string acceptTimeMPre5 = string.Empty;
string acceptTimePre5 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeHPre5))
{
acceptTimeMPre5 = string.IsNullOrEmpty(m_objViewer.cboAceepMPre_5.Text.Trim()) ? "00" : m_objViewer.cboAceepMPre_5.Text.Trim();
acceptTimePre5 = acceptTimeHPre5 + ":" + acceptTimeMPre5;
}
if (!string.IsNullOrEmpty(acceptTimeH5) && !string.IsNullOrEmpty(acceptTimeHPre5))
{
acceptTime5 = acceptTimePre5 + "~" + acceptTime5;
}
string acceptTimeH6 = m_objViewer.cboAceepH_6.Text.Trim();;
string acceptTimeM6 = string.Empty;
string acceptTime6 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeH6))
{
acceptTimeM6 = string.IsNullOrEmpty(m_objViewer.cboAceepM_6.Text.Trim()) ? "00" : m_objViewer.cboAceepM_6.Text.Trim();
acceptTime6 = acceptTimeH6 + ":" + acceptTimeM6;
}
string acceptTimeHPre6 = m_objViewer.cboAceepHPre_6.Text.Trim();;
string acceptTimeMPre6 = string.Empty;
string acceptTimePre6 = string.Empty;
if (!string.IsNullOrEmpty(acceptTimeHPre6))
{
acceptTimeMPre6 = string.IsNullOrEmpty(m_objViewer.cboAceepMPre_6.Text.Trim()) ? "00" : m_objViewer.cboAceepMPre_6.Text.Trim();
acceptTimePre6 = acceptTimeHPre6 + ":" + acceptTimeMPre6;
}
if (!string.IsNullOrEmpty(acceptTimeH6) && !string.IsNullOrEmpty(acceptTimeHPre6))
{
acceptTime6 = acceptTimePre6 + "~" + acceptTime6;
}
#endregion
#region CONFIRTIME
string confrEndH = m_objViewer.cboConfirEndH.Text.Trim();;
string confrEndM = string.Empty;
string confirmEndTime = string.Empty;
if (!string.IsNullOrEmpty(confrEndH))
{
confrEndM = string.IsNullOrEmpty(m_objViewer.cboConfirEndM.Text.Trim()) ? "00" : m_objViewer.cboConfirEndM.Text.Trim();
confirmEndTime = confrEndH + ":" + confrEndM;
}
string confirTimeH_1 = m_objViewer.cboConfirH_1.Text.Trim();;
string confirTimeM_1 = string.Empty;
string confirTime_1 = string.Empty;
if (!string.IsNullOrEmpty(confirTimeH_1))
{
confirTimeM_1 = string.IsNullOrEmpty(m_objViewer.cboConfirM_1.Text.Trim()) ? "00" : m_objViewer.cboConfirM_1.Text.Trim();
confirTime_1 = confirTimeH_1 + ":" + confirTimeM_1;
}
string confirTimeH_2 = m_objViewer.cboConfirH_2.Text.Trim();;
string confirTimeM_2 = string.Empty;
string confirTime_2 = string.Empty;
if (!string.IsNullOrEmpty(confirTimeH_2))
{
confirTimeM_2 = string.IsNullOrEmpty(m_objViewer.cboConfirM_2.Text.Trim()) ? "00" : m_objViewer.cboConfirM_2.Text.Trim();
confirTime_2 = confirTimeH_2 + ":" + confirTimeM_2;
}
string confirTimeH_3 = m_objViewer.cboConfirH_3.Text.Trim();;
string confirTimeM_3 = string.Empty;
string confirTime_3 = string.Empty;
if (!string.IsNullOrEmpty(confirTimeH_3))
{
confirTimeM_3 = string.IsNullOrEmpty(m_objViewer.cboConfirM_3.Text.Trim()) ? "00" : m_objViewer.cboConfirM_3.Text.Trim();
confirTime_3 = confirTimeH_3 + ":" + confirTimeM_3;
}
string confirTimeH_4 = m_objViewer.cboConfirH_4.Text.Trim();;
string confirTimeM_4 = string.Empty;
string confirTime_4 = string.Empty;
if (!string.IsNullOrEmpty(confirTimeH_4))
{
confirTimeM_4 = string.IsNullOrEmpty(m_objViewer.cboConfirM_4.Text.Trim()) ? "00" : m_objViewer.cboConfirM_4.Text.Trim();
confirTime_4 = confirTimeH_4 + ":" + confirTimeM_4;
}
#endregion
DataRow newRow;
newRow = dt.NewRow();
newRow["applyunitid"] = applyunitid;
newRow["week1"] = week1;
newRow["week2"] = week2;
newRow["normalLimit"] = normalLimit;
newRow["emergencyLimit"] = emergencyLimit;
newRow["acceptTime1"] = acceptTime1;
newRow["acceptTime2"] = acceptTime2;
newRow["acceptTime3"] = acceptTime3;
newRow["acceptTime4"] = acceptTime4;
newRow["confirTime1"] = confirTime_1;
newRow["confirTime2"] = confirTime_2;
newRow["confirTime3"] = confirTime_3;
newRow["confirTime4"] = confirTime_4;
newRow["week3"] = week3;
newRow["week4"] = week4;
newRow["week5"] = week5;
newRow["week6"] = week6;
newRow["confirmendtime"] = confirmEndTime;
newRow["acceptTime5"] = acceptTime5;
newRow["acceptTime6"] = acceptTime6;
newRow["timelimit5"] = timelimit5;
newRow["timelimit6"] = timelimit6;
dt.Rows.Add(newRow);
lngRes = m_objManage.lngSaveLimitTime(dt);
if (lngRes > 0)
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}