protected void BindEquipAndConsume()
{
#region ������
List<LabMS.Model.ProjectConsume> ls = new List<LabMS.Model.ProjectConsume>();
LabMS.BLL.ProjectConsume ProjectConsume = new LabMS.BLL.ProjectConsume();
//������
ls = ProjectConsume.GetModelList("ProjectID=" + QueryString + " and Type =1 ");
string strHTML = "<table id='tableEquip' style='border-collapse: collapse;' border='1' class='infoTable'>";
strHTML += "<thead>";
strHTML += "<tr class='header'>";
strHTML += "<th>";
strHTML += "���";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "�ͺ�";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "�����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "���";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "";
strHTML += "</th>";
strHTML += "</tr>";
strHTML += "</thead>";
strHTML += "<tbody>";
tb_EIndex.Value = ls.Count.ToString();
for (int i = 0; i < ls.Count; i++)
{
strHTML += "<tr>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipType + "' name='code" + i + "' id='code" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/><input onclick=OpenEditWin2('../CommonPage/consumselectlist.aspx?location=@ALL@&Type=yiqi',500,400,'code" + i + "','name" + i + "','model" + i + "','categorycode" + i + "','num" + i + "'); type='button' value='...' /> ";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipName + "' name='name" + i + "' id='name" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].Model + "' name='model" + i + "' id='model" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].CategoryCode + "' name='categorycode" + i + "' id='categorycode" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].Argument + "' name='argument" + i + "' id='argument" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipNum + "' name='num" + i + "' id='num" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<a>ɾ��</a>";
strHTML += "</td>";
strHTML += "</tr>";
}
strHTML += "</tbody>";
strHTML += "</table>";
lbEquip.Text += strHTML;
tbTableEquip.Value = strHTML;
#endregion ������
#region ������Ʒ
ls = ProjectConsume.GetModelList("ProjectID=" + QueryString + " and Type =2 ");
strHTML = "<table id='tableConsump' style='border-collapse: collapse;' border='1' class='infoTable'> ";
strHTML += "<thead>";
strHTML += "<tr class='header'>";
strHTML += "<th>";
strHTML += "���";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "�ͺ�";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "�����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "ÿ������";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "����";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "�ܽ��";
strHTML += "</th>";
strHTML += "<th>";
strHTML += "";
strHTML += "</th>";
strHTML += "</tr>";
strHTML += "</thead>";
strHTML += "<tbody>";
tb_ConsumpIndex.Value = ls.Count.ToString();
for (int i = 0; i < ls.Count; i++)
{
strHTML += "<tr>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipType + "' name='consumpcode" + i + "' id='consumpcode" + i + "' type='text'style='border-bottom: solid 1px #000000; width: 60px;'/><input onclick=OpenEditWin3('../CommonPage/consumselectlist.aspx?location=@ALL@&Type=xiaohaopin',500,400,'consumpcode" + i + "','consumpname" + i + "','consumpmodel" + i + "','consumpcategorycode" + i + "','consumpnum" + i + "','consumpunitprice" + i + "'); type='button' value='...' /> ";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipName + "' name='consumpname" + i + "' id='consumpname" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].Model + "' name='consumpmodel" + i + "' id='consumpmodel" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].CategoryCode + "' name='consumpcategorycode" + i + "' id='consumpcategorycode" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].EquipNum + "' name='consumpnum" + i + "' id='consumpnum" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].UnitPrice + "' name='consumpunitprice" + i + "' id='consumpunitprice" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<input value='" + ls[i].Money + "' name='consumpmoney" + i + "' id='consumpmoney" + i + "' type='text' style='border-bottom: solid 1px #000000; width: 60px;'/>";
strHTML += "</td>";
strHTML += "<td>";
strHTML += "<a>ɾ��</a>";
strHTML += "</td>";
strHTML += "</tr>";
}
strHTML += "</tbody>";
strHTML += "</table>";
tbTableConsump.Value += strHTML;
lbConsume.Text = strHTML;
#endregion ������Ʒ
}
protected void Save_Click(object sender, EventArgs e)
{
#region validation
int Index = 0;
int NewIndex = 0;
if (!int.TryParse(tb_EIndex.Value, out Index))
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('�������ݴ���');window.location.href='ProjectList.aspx';</script>");
return;
}
if (!int.TryParse(tb_ConsumpIndex.Value, out NewIndex))
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('�������ݴ���');window.location.href='ProjectList.aspx';</script>");
return;
}
for (int i = 0; i < Index; i++)
{
if (!string.IsNullOrEmpty(Request.Form["code" + i]) && !string.IsNullOrEmpty(Request.Form["name" + i]))
{
if (string.IsNullOrEmpty(Request.Form["model" + i]))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�������ͺŲ���Ϊ��");
return;
}
if (string.IsNullOrEmpty(Request.Form["categorycode" + i]))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��������Ų���Ϊ��");
return;
}
}
}
for (int j = 0; j < NewIndex; j++)
{
if (!string.IsNullOrEmpty(Request.Form["code" + j]) && !string.IsNullOrEmpty(Request.Form["name" + j]))
{
if (string.IsNullOrEmpty(Request.Form["model" + j]))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�����ͺŲ���Ϊ��");
return;
}
if (string.IsNullOrEmpty(Request.Form["categorycode" + j]))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��������Ų���Ϊ��");
return;
}
}
}
#endregion validation
string[] DateTimeList = {
"yyyy/M/d tt hh:mm:ss",
"yyyy/MM/dd tt hh:mm:ss",
"yyyy/MM/dd HH:mm:ss",
"yyyy/M/d HH:mm:ss",
"yyyy/MM/dd",
"yyyy-MM-dd hh:mm:ss",
"yyyy-MM-dd",
"yyyy-M-d"
};
LabMS.BLL.Project Project = new LabMS.BLL.Project();
LabMS.Model.Project ProjectItem = new LabMS.Model.Project();
ProjectItem = Project.GetModel(Convert.ToInt32(Request.QueryString["ID"].ToString()));
ProjectItem.Project_Code = tb_Code.Text.Trim();
ProjectItem.Project_Name = tb_Name.Text.Trim();
ProjectItem.Project_StartTime = DateTime.ParseExact(tb_StartTime.Text.Trim(), DateTimeList, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.AllowInnerWhite);
ProjectItem.Project_StartWeek = new int?(Convert.ToInt32(tb_StartWeek.Text.Trim()));
ProjectItem.Project_SubmitTime = DateTime.Now;
ProjectItem.Project_EndTime = DateTime.ParseExact(tb_EndTime.Text.Trim(), DateTimeList, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.AllowInnerWhite);
ProjectItem.Project_EndWeek = new int?(Convert.ToInt32(tb_EndWeek.Text.Trim()));
ProjectItem.Project_ClassHourse = new int?(Convert.ToInt32(tb_ClassHourse.Text.Trim()));
ProjectItem.Project_Consume = new int?(Convert.ToInt32(tb_Cunsume.Text.Trim()));
ProjectItem.Project_PartnerNum = Convert.ToInt32(tb_PatnerNum.Text.Trim());
ProjectItem.Project_Content = tb_Content.Text.TrimEnd();
ProjectItem.Project_Lab = new int?(Convert.ToInt32(ddl_Lab.SelectedValue));
//ProjectItem.Project_PartnerTeamNum = Convert.ToInt32(tb_PatnerTeamNum.Text);
ProjectItem.Project_ExpHouse = Convert.ToInt32(tb_ExpHouse.Text.Trim());
ProjectItem.Project_Professional = Convert.ToInt32(ddl_Profess.SelectedValue);
ProjectItem.Project_Category = ddl_Category.SelectedValue.Trim();
ProjectItem.Project_AwardLevel = ddl_AwardLevel.SelectedValue.Trim();
ProjectItem.Project_PartnerType = ddl_ParterType.SelectedValue.Trim();
ProjectItem.Project_Request = ddl_Request.SelectedValue.Trim();
ProjectItem.Project_Type = ddl_Type.SelectedValue.Trim();
ProjectItem.Project_Change = ddl_Change.SelectedValue.Trim();
ProjectItem.Project_Subject = tb_Subject.Text.Trim();
ProjectItem.Project_CourseMode = "";
for (int i = 0; i < cbl_CourseMode.Items.Count; i++)
{
if (cbl_CourseMode.Items[i].Selected == true)
{
ProjectItem.Project_CourseMode += cbl_CourseMode.Items[i].Value + "|";
}
}
Project.Update(ProjectItem);
/// ���Equipment ��Ϣ
int ProjectIDs = ProjectItem.ID;
///����
///
LabMS.BLL.ProjectConsume ProjectConsume = new LabMS.BLL.ProjectConsume();
List<LabMS.Model.ProjectConsume> ls = new List<LabMS.Model.ProjectConsume>();
ls = ProjectConsume.GetModelList("ProjectID=" + ProjectIDs);
try
{
for (int v = 0; v < ls.Count; v++)
{
ProjectConsume.Delete(ls[v].ID);
}
}
catch
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��������Ʒ��Ӵ���');window.location.href='ProjectList.aspx';</script>");
return;
}
LabMS.Model.ProjectConsume projectconsumemodel;
int temp = 0;
decimal tem = 0.0M;
for (int n = 0; n < Index; n++)
{
projectconsumemodel = new LabMS.Model.ProjectConsume();
try
{
if (!string.IsNullOrEmpty(Request.Form["code" + n]) && !string.IsNullOrEmpty(Request.Form["name" + n]))
{
projectconsumemodel.EquipType = Request.Form["code" + n];
projectconsumemodel.EquipName = Request.Form["name" + n];
projectconsumemodel.Model = Request.Form["model" + n];
projectconsumemodel.CategoryCode = Request.Form["categorycode" + n];
projectconsumemodel.Argument = Request.Form["argument" + n];
if (int.TryParse(Request.Form["num" + n], out temp))
{
projectconsumemodel.EquipNum = temp;
}
else
{
projectconsumemodel.EquipNum = 0;
}
projectconsumemodel.Type = "1";
projectconsumemodel.ProjectID = ProjectIDs;
ProjectConsume.Add(projectconsumemodel);
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��������Ʒ��Ӵ���');window.location.href='ProjectList.aspx';</script>");
return;
}
}
for (int m = 0; m < NewIndex; m++)
{
projectconsumemodel = new LabMS.Model.ProjectConsume();
try
{
if (!string.IsNullOrEmpty(Request.Form["consumpcode" + m]) && !string.IsNullOrEmpty(Request.Form["consumpname" + m]))
{
projectconsumemodel.EquipType = Request.Form["consumpcode" + m];
projectconsumemodel.EquipName = Request.Form["consumpname" + m];
projectconsumemodel.Model = Request.Form["consumpmodel" + m];
projectconsumemodel.CategoryCode = Request.Form["consumpcategorycode" + m];
projectconsumemodel.Argument = Request.Form["consumpargument" + m];
if (int.TryParse(Request.Form["consumpnum" + m], out temp))
{
projectconsumemodel.EquipNum = temp;
}
else
{
projectconsumemodel.EquipNum = 0;
}
if (decimal.TryParse(Request.Form["consumpunitprice" + m], out tem))
{
projectconsumemodel.UnitPrice = tem;
}
else
{
projectconsumemodel.UnitPrice = 0.0M;
}
if (decimal.TryParse(Request.Form["consumpmoney" + m].Trim(), out tem))
{
projectconsumemodel.Money = tem.ToString();
}
else
{
decimal unitpricetemp = 0.0M;
int numtemp = 0;
if (decimal.TryParse(Request.Form["consumpunitprice" + m].Trim(), out unitpricetemp) && int.TryParse(Request.Form["consumpnum" + m].Trim(), out numtemp))
{
decimal moneyall = unitpricetemp * numtemp;
projectconsumemodel.Money = moneyall.ToString();
}
else
{
projectconsumemodel.Money = "0.0";
}
}
projectconsumemodel.ProjectID = ProjectIDs;
projectconsumemodel.Type = "2";
ProjectConsume.Add(projectconsumemodel);
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��������Ʒ��Ӵ���,����ϵ����Ա��');window.location.href='ProjectList.aspx';</script>");
return;
}
}
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('�ijɹ�');refreshParent();if(window.confirm('�Ƿ��б�ҳ��')){window.location.href='ProjectList.aspx';}else{window.location.href=window.location.href;}</script>");
return;
}
protected void Gv_DataBinds()
{
LabMS.BLL.ProjectConsume ProjectConsume = new LabMS.BLL.ProjectConsume();
List<LabMS.Model.ProjectConsume> ls;
ls = ProjectConsume.GetModelList("ProjectID=" + querystring.ToString() + " and Type='1'");
Gv_Equip.DataSource = ls;
Gv_Equip.DataBind();
ls = ProjectConsume.GetModelList("ProjectID=" + querystring.ToString() + " and Type='2'");
Gv_Consume.DataSource = ls;
Gv_Consume.DataBind();
}
