/// <summary>
/// 增加上周计划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btLastWeek_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string parent = ParentID;
string where = "where ParentID in(select ID from JH_weekmant where 开始日期=" +
"(select dateadd(\"d\",-7,开始日期) from JH_weekmant where ID='" + ParentID + "')" + " and 单位代码='" + org.OrgCode + "' and 姓名='" + parentObj.姓名+"')";
IList<JH_weekman> jhweekManList = Client.ClientHelper.PlatformSqlMap.GetListByWhere<JH_weekman>(where);
frmJH_WeeksMore frm = new frmJH_WeeksMore();
frm.jhWeekManList = (List<JH_weekman>)jhweekManList;
frm.isAddLastWeek = true;
if (frm.ShowDialog() == DialogResult.OK)
{
DataTable dt = frm.GetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((bool)dt.Rows[i]["IsSelect"] == true)
{
IList<JH_weekman> weekmanList = Client.ClientHelper.PlatformSqlMap.GetListByWhere<JH_weekman>("where c5='" + dt.Rows[i]["ID"] + "'");
if (weekmanList.Count == 0)
{
JH_weekman weekman = new JH_weekman();
weekman.ID = weekman.CreateID();
weekman.ParentID = ParentID;
weekman.单位代码 = (string)dt.Rows[i]["_单位代码"];
weekman.单位名称 = (string)dt.Rows[i]["_单位名称"];
weekman.计划项目 = (string)dt.Rows[i]["_计划项目"];
weekman.工作内容 = (string)dt.Rows[i]["_实施内容"];
weekman.协作人员 = (string)dt.Rows[i]["_参加人员"];
weekman.预计时间 = ((DateTime)dt.Rows[i]["_预计时间"]).AddDays(7);
weekman.预计时间2 = ((DateTime)dt.Rows[i]["_预计时间2"]).AddDays(7);
weekman.完成时间 = DateTime.Now;
weekman.c5 = (string)dt.Rows[i]["ID"];
Client.ClientHelper.PlatformSqlMap.Create<JH_weekman>(weekman);
}
}
}
ParentID = parent;
}
}
/// <summary>
/// 增加本周计划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddWeeks_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string parentID = ParentObj.ParentID;
string parent = ParentID;
string orgcode = org.OrgCode;
IList<JH_weekks> jhweeksList= Client.ClientHelper.PlatformSqlMap.GetListByWhere<JH_weekks>("where ParentID='" + parentID + "' and 单位代码='"+orgcode+"'");
frmJH_WeeksMore fr = new frmJH_WeeksMore();
fr.jhWeeksList = (List<JH_weekks>)jhweeksList;
fr.isAddWeek = true;
if (fr.ShowDialog() == DialogResult.OK)
{
DataTable dt = fr.GetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((bool)dt.Rows[i]["IsSelect"] == true)
{
IList<JH_weekman> weekmanList = Client.ClientHelper.PlatformSqlMap.GetListByWhere<JH_weekman>("where c5='" + dt.Rows[i]["ID"] + "' and parentid='"+ParentID+"'");
if (weekmanList.Count==0)
{
//newobj.预计时间 = parentObj.开始日期;
//newobj.预计时间2 = ParentObj.结束日期;
JH_weekman weekman = new JH_weekman();
weekman.ID = weekman.CreateID();
weekman.ParentID = ParentObj.ID;
weekman.单位代码 = (string)dt.Rows[i]["_单位代码"];
weekman.单位名称 = (string)dt.Rows[i]["_单位名称"];
weekman.计划项目 = (string)dt.Rows[i]["_计划项目"];
weekman.工作内容 = (string)dt.Rows[i]["_实施内容"];
weekman.协作人员 = (string)dt.Rows[i]["_参加人员"];
weekman.预计时间 = parentObj.开始日期;
weekman.预计时间2 = ParentObj.结束日期;
weekman.完成时间 = DateTime.Now;
weekman.c5 = (string)dt.Rows[i]["ID"];
Client.ClientHelper.PlatformSqlMap.Create<JH_weekman>(weekman);
}
}
}
ParentID = parent;
}
}