public static Msg QyeryPlanById(int iPlanId)
{
Msg msg = null;
Tbl_Plan oUsers = new Tbl_Plan();;
try
{
using (var en = new LingYunEntities())
{
oUsers = en.Tbl_Plan.Where(a => a.PlanID == iPlanId).FirstOrDefault();
}
msg = new Msg()
{
UserData = oUsers, Status = true
};
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string sPlanId = this.Request["PlanId"];
List <Tbl_User> lUsers = ViewState["lUsers"] as List <Tbl_User>;
int iPlanAdm = 1;
int iDesignAdm = lUsers[DropDownList2.SelectedIndex].ID;
int iProductAdm = lUsers[DropDownList3.SelectedIndex].ID;
int iCenterStorateAdm = lUsers[DropDownList4.SelectedIndex].ID;
int iSiteStorageAdm = lUsers[DropDownList5.SelectedIndex].ID;
Tbl_Plan oPlan = new Tbl_Plan();
oPlan.PlanID = int.Parse(sPlanId);
oPlan.ProjectName = txtProjectName.Text;
oPlan.DesignAdm = iDesignAdm;
oPlan.ProductAdm = iProductAdm;
oPlan.CenterStorageAdm = iCenterStorateAdm;
oPlan.SiteStorageAdm = iSiteStorageAdm;
Msg msg = PlanModel.EditPlan(oPlan);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "您已成功提交项目");
}
else
{
PageHelper.ShowAlertMsg(this, msg.Message);
}
}
//创建人：梁林
//时间：3/29
/// <summary>
///向项目汇总表增加一条项目
/// </summary>
/// <param name="oPlan">项目表对象</param>
/// <returns>消息传输实体</returns>
public static Msg AddPlan(Tbl_Plan oPlan)
{
Msg msg = null;
if (oPlan != null)
{
try
{
using (var en = new LingYunEntities())
{
en.Tbl_Plan.AddObject(oPlan);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
public static Msg EnsureMateries(Tbl_Materies oMatries)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.PlanID == oMatries.PlanID).FirstOrDefault();
obj.Date = oMatries.Date;
obj.BuildNum = oMatries.BuildNum;
obj.BuildName = oMatries.BuildName;
obj.NowAdmStatus = oMatries.NowAdmStatus;
obj.TotalNum = oMatries.TotalNum;
obj.MateriesType = oMatries.MateriesType;
obj.NowDate = DateTime.Now.ToString();
obj.ProcessingNum = oMatries.ProcessingNum;
Tbl_Plan oPlan = en.Tbl_Plan.Where(b => b.PlanID == oMatries.PlanID).FirstOrDefault();
if (oPlan != null)
{
oPlan.DesignAdmStatus = 128;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// android端确认
/// </summary>
/// <param name="oMatries"></param>
/// <returns></returns>
public static Msg AndroidEnsure(int iPlanid)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_Materies obj = en.Tbl_Materies.Where(a => a.MateriesID == iPlanid).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowDate = DateTime.Now.ToString();
Tbl_Plan oPlan = en.Tbl_Plan.Where(b => b.PlanID == obj.PlanID).FirstOrDefault();
if (oPlan != null)
{
oPlan.DesignAdmStatus = 128;
}
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static Msg GetMetriesByPlanId(int iPlanId)
{
Msg msg = null;
try
{
Tbl_Plan oMetries = new Tbl_Plan();
using (var en = new LingYunEntities())
{
oMetries = en.Tbl_Plan.Where(a => a.PlanID == iPlanId).FirstOrDefault();
}
if (oMetries != null)
{
msg = new Msg(true)
{
UserData = oMetries
};
}
else
{
msg = new Msg(false)
{
Message = "查找失败"
};
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sPlanId = this.Request["PlanId"];
List <string> list = new List <string>();
List <Tbl_User> lUsers = new List <Tbl_User>();
Msg msg = UserLoginModel.GetAllUser();
if (msg.Status)
{
Msg planMsg = PlanModel.QyeryPlanById(int.Parse(sPlanId));
if (planMsg.Status)
{
lUsers = msg.UserData as List <Tbl_User>;
for (int i = 0; i < lUsers.Count; i++)
{
list.Add("用户名：" + lUsers[i].Name);
}
ViewState["lUsers"] = lUsers;
DropDownList2.DataSource = list;
DropDownList2.DataBind();
DropDownList3.DataSource = list;
DropDownList3.DataBind();
DropDownList4.DataSource = list;
DropDownList4.DataBind();
DropDownList5.DataSource = list;
DropDownList5.DataBind();
Tbl_Plan oPlan = planMsg.UserData as Tbl_Plan;
txtProjectName.Text = oPlan.ProjectName;
for (int i = 0; i < lUsers.Count; i++)
{
if (lUsers[i].ID == oPlan.DesignAdm)
{
DropDownList2.SelectedIndex = i;
}
if (lUsers[i].ID == oPlan.ProductAdm)
{
DropDownList3.SelectedIndex = i;
}
if (lUsers[i].ID == oPlan.CenterStorageAdm)
{
DropDownList4.SelectedIndex = i;
}
if (lUsers[i].ID == oPlan.SiteStorageAdm)
{
DropDownList5.SelectedIndex = i;
}
}
}
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
List <Tbl_User> lUsers = ViewState["lUsers"] as List <Tbl_User>;
int iPlanAdm = 1;
int iDesignAdm = lUsers[DropDownList2.SelectedIndex].ID;
int iProductAdm = lUsers[DropDownList3.SelectedIndex].ID;
int iCenterStorateAdm = lUsers[DropDownList4.SelectedIndex].ID;
int iSiteStorageAdm = lUsers[DropDownList5.SelectedIndex].ID;
DateTime now = DateTime.Now;
if ((this.CurrentUserInfo.Identify & 128) != 0)
{
Tbl_Plan oPlan = new Tbl_Plan();
oPlan.ProjectName = txtProjectName.Text;
oPlan.PlanDate = now;
oPlan.Planer = this.CurrentUserInfo.Id;//项目人员id
oPlan.PlanerStatus = 128;
oPlan.PlanAdm = iPlanAdm;
oPlan.PlanAdmStatus = 128;
oPlan.DesignAdm = iDesignAdm;
oPlan.DesignAdmStatus = 1;
oPlan.ProductAdm = iProductAdm;
oPlan.ProductAdmStatus = 1;
oPlan.CenterStorageAdm = iCenterStorateAdm;
oPlan.CenterStorageAdmStatus = 1;
oPlan.SiteStorageAdm = iSiteStorageAdm;
oPlan.SiteStorageAdmStatus = 1;
Msg msg = PlanModel.AddPlan(oPlan);
if (msg.Status)
{
StatusClass oStatus = StatusClass.GetInstance(); //此处运用单例模式
oStatus.CurrPlanId = this.CurrentUserInfo.Id;
oStatus.CurrStatus++; //已提交项目
PageHelper.ShowAlertMsg(this, "增加成功");
}
else
{
PageHelper.ShowAlertMsg(this, msg.Message);
}
}
else
{
PageHelper.ShowAlertMsg(this, "您当前没有增加项目的权限");
}
}
/// <summary>
///向项目汇总表增加一条项目
/// </summary>
/// <param name="oPlan">项目表对象</param>
/// <returns>消息传输实体</returns>
public static Msg EditPlan(Tbl_Plan oPlan)
{
Msg msg = null;
if (oPlan != null)
{
try
{
using (var en = new LingYunEntities())
{
Tbl_Plan obj = en.Tbl_Plan.Where(a => a.PlanID == oPlan.PlanID).FirstOrDefault();
if (obj != null)
{
obj.ProjectName = oPlan.ProjectName;
obj.ProductAdm = oPlan.ProductAdm;
obj.DesignAdm = oPlan.DesignAdm;
obj.CenterStorageAdm = obj.CenterStorageAdm;
obj.SiteStorageAdm = obj.SiteStorageAdm;
obj.PlanDate = DateTime.Now;
en.SaveChanges();
msg = Msg.Default;
}
else
{
msg = new Msg(false)
{
Message = "没有查到要确认的项目"
};
}
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = "没有查到要确认的项目"
};
}
}
return(msg);
}
