public System.Collections.Generic.List <DataTable> GetData()
{
string sWhere = this.strwhere();
string where = this.where ();
System.Collections.Generic.List <DataTable> list = new System.Collections.Generic.List <DataTable>();
DataTable dataTable = this.prjMileSer.GetdepmentprjMilestone(sWhere, where, this.AspNetPager1.RecordCount, 1);
DataTable dataTable2 = new DataTable();
dataTable2.Columns.Add("序号");
dataTable2.Columns.Add("部门名称");
dataTable2.Columns.Add("项目储备额");
dataTable2.Columns.Add("当年预测");
dataTable2.Columns.Add("储备转换率");
dataTable2.Columns.Add("明年预测");
dataTable2.Columns.Add("初步接洽");
dataTable2.Columns.Add("提供样品");
dataTable2.Columns.Add("样品质量被接纳");
dataTable2.Columns.Add("投标");
dataTable2.Columns.Add("中标");
dataTable2.Columns.Add("下订单");
dataTable2.Columns.Add("交货");
dataTable2.Columns.Add("销售确认");
dataTable2.Columns.Add("项目失败");
dataTable2.Columns.Add("工程总数");
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable2.NewRow();
dataRow["序号"] = i + 1;
dataRow["部门名称"] = dataTable.Rows[i][1].ToString();
dataRow["项目储备额"] = dataTable.Rows[i][2].ToString();
dataRow["当年预测"] = dataTable.Rows[i][3].ToString();
if (System.Convert.ToDecimal(dataTable.Rows[i][2]) != 0m)
{
dataRow["储备转换率"] = Common2.FormatRate(System.Convert.ToDecimal(dataTable.Rows[i][3]) / System.Convert.ToDecimal(dataTable.Rows[i][2]));
}
else
{
dataRow["储备转换率"] = Common2.FormatRate("0");
}
dataRow["明年预测"] = dataTable.Rows[i][4].ToString();
dataRow["初步接洽"] = dataTable.Rows[i][5].ToString();
dataRow["提供样品"] = dataTable.Rows[i][6].ToString();
dataRow["样品质量被接纳"] = dataTable.Rows[i][7].ToString();
dataRow["投标"] = dataTable.Rows[i][8].ToString();
dataRow["中标"] = dataTable.Rows[i][9].ToString();
dataRow["下订单"] = dataTable.Rows[i][10].ToString();
dataRow["交货"] = dataTable.Rows[i][11].ToString();
dataRow["销售确认"] = dataTable.Rows[i][12].ToString();
dataRow["项目失败"] = dataTable.Rows[i][13].ToString();
dataRow["工程总数"] = System.Convert.ToInt32(dataTable.Rows[i][13]) + System.Convert.ToInt32(dataTable.Rows[i][5]) + System.Convert.ToInt32(dataTable.Rows[i][6]) + System.Convert.ToInt32(dataTable.Rows[i][7]) + System.Convert.ToInt32(dataTable.Rows[i][8]) + System.Convert.ToInt32(dataTable.Rows[i][9]) + System.Convert.ToInt32(dataTable.Rows[i][10]) + System.Convert.ToInt32(dataTable.Rows[i][11]) + System.Convert.ToInt32(dataTable.Rows[i][12]);
dataTable2.Rows.Add(dataRow);
}
string[] values = new string[]
{
"合计",
"",
this.hfldStoreAmount.Value,
this.hfldForeCast.Value,
Common2.FormatRate(decimal.Divide(System.Convert.ToDecimal(this.hfldForeCast.Value), System.Convert.ToDecimal(this.hfldStoreAmount.Value))).ToString(),
this.hfldNextForeCast.Value,
this.hfldStone1.Value,
this.hfldStone2.Value,
this.hfldStone3.Value,
this.hfldStone4.Value,
this.hfldStone5.Value,
this.hfldStone6.Value,
this.hfldStone7.Value,
this.hfldStone8.Value,
this.hfldStone9.Value,
(System.Convert.ToInt32(this.hfldStone1.Value) + System.Convert.ToInt32(this.hfldStone2.Value) + System.Convert.ToInt32(this.hfldStone3.Value) + System.Convert.ToInt32(this.hfldStone4.Value) + System.Convert.ToInt32(this.hfldStone5.Value) + System.Convert.ToInt32(this.hfldStone6.Value) + System.Convert.ToInt32(this.hfldStone7.Value) + System.Convert.ToInt32(this.hfldStone8.Value) + System.Convert.ToInt32(this.hfldStone9.Value)).ToString()
};
dataTable2.Rows.Add(values);
list.Add(dataTable2);
return(list);
}
private void BindLbl(string PrjId)
{
ProjectInfo byId = ProjectInfo.GetById(PrjId);
if (byId != null)
{
this.lblPrjId.Text = PrjId.ToString();
this.lblBllProducer.Text = byId.GetUserName(base.UserCode);
this.lblPrintDate.Text = System.DateTime.Now.ToShortDateString();
this.lblPrjState.Text = TypeList.GetTypeName(byId.PrjState.ToString(), "2", "ProjectState");
this.lblBudgetWay.Text = TypeList.GetTypeName(byId.BudgetWay, "1", "ysType");
this.lblContractWay.Text = TypeList.GetTypeName(byId.ContractWay, "1", "cbType");
this.lblKeyPart.Text = TypeList.GetTypeName(byId.KeyPart, "1", "primaryGrade");
this.lblPayCondition.Text = TypeList.GetTypeName(byId.PayCondition, "1", "payment");
this.lblPayWay.Text = TypeList.GetTypeName(byId.PayWay, "1", "jsType");
if (byId.PrjTypes != null)
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
System.Text.StringBuilder stringBuilder2 = new System.Text.StringBuilder();
foreach (ProjectKind current in byId.PrjTypes)
{
stringBuilder2.Append(current.ProfessionalCost.ToString()).Append("<br />");
stringBuilder.Append(TypeList.GetTypeName(current.PrjKind, "1", "ProjectType")).Append("<br />");
}
this.lblPrjKindClass.Text = stringBuilder.ToString();
this.lblPrjProfessionalCost.Text = stringBuilder2.ToString();
}
this.lblProperty.Text = TypeList.GetTypeName(byId.PrjProperty, "1", "ProjectProperty");
this.lblInfoOrigin.Text = this.ReplaceTxt(byId.ProjInfoOrigin);
this.lblElseRequest.Text = this.ReplaceTxt(byId.ProjElseRequest);
this.lblQualityClass.Text = TypeList.GetTypeName(byId.QualityClass, "1", "ProjectQuality");
if (byId.PrjRanks != null)
{
System.Text.StringBuilder stringBuilder3 = new System.Text.StringBuilder();
foreach (ProjectRank current2 in byId.PrjRanks)
{
stringBuilder3.Append(TypeList.GetTypeName(current2.Rank, "1", "zzGrade") + " " + current2.RankLevel).Append("<br />");
}
this.lblRank.Text = stringBuilder3.ToString();
}
this.lblTenderWay.Text = TypeList.GetTypeName(byId.TenderWay, "1", "zbType");
this.lblXmgroup.Text = TypeList.GetXmlGroupName(byId.Xmgroup);
if (byId.EngineeringTypes != null)
{
System.Text.StringBuilder stringBuilder4 = new System.Text.StringBuilder();
foreach (EngineeringType current3 in byId.EngineeringTypes)
{
stringBuilder4.Append(current3.ToString()).Append("<br />");
}
this.lblBuildingType.Text = stringBuilder4.ToString();
}
this.lblTelphone.Text = byId.Telephone;
if (byId.ProgAgent != "")
{
this.lblAgent.Text = byId.ProgAgentName;
}
this.lblBuildingArea.Text = byId.BuildingArea;
this.lblDesigner.Text = byId.Designer;
this.lblDuration.Text = byId.Duration;
this.lblEndDate.Text = Common2.GetTime(byId.EndDate);
this.lblgrade.Text = byId.PrjGrade;
this.lblInspector.Text = byId.Inspector;
this.lblOtherStatement.Text = StringUtility.ReplaceTxt(byId.OtherStatement);
this.lblPrjCode.Text = byId.PrjCode;
if (byId.PrjCost.ToString() != "0" && byId.PrjCost.ToString() != "")
{
this.lblPrjCost.Text = byId.PrjCost.ToString();
}
this.lblPrjFundInfo.Text = byId.PrjFundInfo;
this.lblPrjInfo.Text = StringUtility.ReplaceTxt(byId.PrjInfo);
if (byId.PrjManager != "")
{
this.lblPrjManager.Text = byId.PrjManagerName;
}
if (byId.Businessman != "")
{
this.lblBusinessman.Text = byId.BusinessmanName;
}
this.lblPrjName.Text = byId.PrjName;
this.lblPrjPlace.Text = byId.PrjPlace;
this.lblRemark1.Text = StringUtility.ReplaceTxt(byId.Remark);
this.lblStartDate.Text = Common2.GetTime(byId.StartDate);
this.lblTotalHouseNum.Text = byId.TotalHouseNum;
this.lblUndergroundArea.Text = byId.UndergroundArea;
this.lblUsegrounArea.Text = byId.UsegrounArea;
this.lblAfforestArea.Text = byId.AfforestArea;
this.lblParkArea.Text = byId.ParkArea;
if (byId.WorkUnit != "")
{
this.lblWorkUnit.Text = byId.WorkUnitName;
}
this.lblForecastProfitRate.Text = byId.ForecastProfitRate.ToString();
this.lblEngineeringEstimates.Text = byId.EngineeringEstimates;
if (byId.PrjDutyPerson != "")
{
this.lblDutyPerson.Text = byId.PrjDutyPersonName;
}
this.lblApprovalOf.Text = byId.PrjApprovalOf;
this.lblFundWorkable.Text = byId.PrjFundWorkable;
this.lblManagementMargin.Text = byId.ManagementMargin.ToString();
this.lblMigrantQualityMarginRate.Text = byId.MigrantQualityMarginRate.ToString();
this.lblWithholdingTaxRate.Text = byId.WithholdingTaxRate.ToString();
this.lblPerformanceBond.Text = byId.PerformanceBond.ToString();
this.lblElseMargin.Text = byId.ElseMargin.ToString();
this.lblOwner.Text = byId.OwnerName;
this.lblOwnerLinkMan.Text = byId.OwnerLinkMan;
this.lblOwnerLinkManPhone.Text = byId.OwnerLinkPhone;
this.lblOwnerAddress.Text = byId.OwnerAddress;
this.lblCorp.Text = byId.ProjPeopleCorp;
this.lblPhone.Text = byId.ProjPeopleTel;
this.lblDuty.Text = byId.ProjPeopleDuty;
this.lblName.Text = byId.ProjPeopleUserName;
this.lblPrjManagerRequire.Text = byId.PrjManagerRequire;
this.lblTechnicalLeaderRequire.Text = byId.TechnicalLeaderRequire;
this.lblPrjReadOne.Text = WebUtil.GetUserNames(byId.PrjReadOne);
if (!string.IsNullOrEmpty(byId.Province))
{
if (byId.City == "北京" || byId.City == "上海" || byId.City == "天津" || byId.City == "重庆" || byId.City == "香港" || byId.City == "澳门")
{
this.lblArea.Text = byId.City;
return;
}
this.lblArea.Text = byId.Province + byId.City;
}
}
}
public static string Common2(IOService iOService)
{
var task = new Common2();
return(task.GetTaskResult(iOService.GetNumbers("Enter the numbers separated by a space")));
}
public void BindNeedGv()
{
DataTable dataTable = this.materialWantPlan.WantPlanDataBind("");
if (base.Request.QueryString["prjGuid"] != null)
{
string procode = base.Request.QueryString["prjGuid"];
DateTime startDate = Common2.GetStartDate(this.txtStartTime);
DateTime dateTime = Common2.GetEndDate(this.txtEndTime);
if (!string.IsNullOrEmpty(this.txtEndTime.Text))
{
dateTime = Common2.GetEndDate(this.txtEndTime).AddDays(1.0);
}
if (startDate == DateTime.MinValue || dateTime == DateTime.MinValue)
{
base.RegisterScript("top.ui.alert('时间格式错误！')");
return;
}
dataTable = this.materialWantPlan.Select(new DateTime?(startDate), new DateTime?(dateTime), this.txtSwcode.Text.Trim(), "", procode, "1");
}
if (dataTable.Rows.Count == 0)
{
dataTable.Rows.Add(dataTable.NewRow());
this.gvNeed.DataSource = dataTable;
this.gvNeed.DataBind();
this.gvNeed.HeaderRow.Cells[0].Visible = false;
this.gvNeed.Rows[0].Visible = false;
}
else
{
this.gvNeed.DataSource = dataTable;
this.gvNeed.DataBind();
}
foreach (GridViewRow gridViewRow in this.gvNeed.Rows)
{
CheckBox checkBox = gridViewRow.FindControl("chkBox") as CheckBox;
if (checkBox != null)
{
string[] array = this.hdwscode.Value.Split(new char[]
{
','
});
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string text = array2[i];
string[] array3 = text.Split(new char[]
{
'|'
});
if (array3[0] == base.Request.QueryString["prjGuid"])
{
string[] array4 = array3;
for (int j = 0; j < array4.Length; j++)
{
string b = array4[j];
if (checkBox.ToolTip == b)
{
checkBox.Checked = true;
}
}
}
}
}
}
}
public void InitPage()
{
if (base.Request.QueryString["id"] != null)
{
this.lblTitle.Text = "编辑收入合同收款";
IncometPaymentModel model = this.incometPaymentBll.GetModel(base.Request.QueryString["id"]);
this.txtCllectionCode.Text = model.CllectionCode;
this.hdCode.Value = model.CllectionCode;
this.txtCllectionPrice.Text = model.CllectionPrice.ToString();
this.txtCllectionTime.Text = Common2.GetTime(model.CllectionTime.ToString());
this.txtCllectionUser.Text = model.CllectionUser;
this.txtInputDate.Text = Common2.GetTime(model.InputDate.ToString());
this.txtInputPerson.Text = model.InputPerson;
this.txtRemark.Text = model.Remark;
this.hdGuid.Value = model.ID;
this.hlfdFundPlanUID.Value = model.MonthPlanUID;
if (this.hldfIsExamineApprove.Value == "0")
{
List <string> fundPlanByMonthPlanUID = this.incometPaymentBll.GetFundPlanByMonthPlanUID(this.hlfdFundPlanUID.Value.Trim(), false);
if (fundPlanByMonthPlanUID.Count > 0)
{
this.txtMonthDate.Value = fundPlanByMonthPlanUID[1].ToString();
this.txtPlanMoney.Value = fundPlanByMonthPlanUID[2].ToString();
this.txtCollectedMoney.Value = fundPlanByMonthPlanUID[4].ToString();
this.lblAllowCollectMoney.Value = fundPlanByMonthPlanUID[5].ToString();
this.txtFundPlanRemark.Value = fundPlanByMonthPlanUID[6].ToString();
}
}
}
else
{
this.lblTitle.Text = "新增收入合同收款";
this.txtInputDate.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.txtInputPerson.Text = PageHelper.QueryUser(this, base.UserCode);
this.hdGuid.Value = Guid.NewGuid().ToString();
if (this.hldfIsExamineApprove.Value == "0")
{
this.hlfdFundPlanUID.Value = this.incometPaymentBll.GetCurrentMonthUID(this.contractId, false);
List <string> fundPlanByMonthPlanUID2 = this.incometPaymentBll.GetFundPlanByMonthPlanUID(this.hlfdFundPlanUID.Value.Trim(), false);
if (fundPlanByMonthPlanUID2.Count > 0)
{
this.txtMonthDate.Value = fundPlanByMonthPlanUID2[1].ToString();
this.txtPlanMoney.Value = fundPlanByMonthPlanUID2[2].ToString();
this.txtCollectedMoney.Value = fundPlanByMonthPlanUID2[4].ToString();
this.lblAllowCollectMoney.Value = fundPlanByMonthPlanUID2[5].ToString();
this.txtFundPlanRemark.Value = fundPlanByMonthPlanUID2[6].ToString();
}
}
}
IncometContractModel model2 = this.incometContractBll.GetModel(base.Request.QueryString["ContractID"]);
this.txtContractCode.Text = model2.ContractCode;
this.txtContractName.Text = model2.ContractName;
this.txtContractPrice.Text = WebUtil.GetEnPrice(model2.ContractPrice.ToString(), model2.ContractID);
this.txtSignedTime.Text = Common2.GetTime(model2.SignedTime.ToString());
this.txtPrjCode.Text = ((model2.Project != null) ? model2.Project.PrjCode : string.Empty);
this.txtPrjName.Text = ((model2.Project != null) ? model2.Project.PrjName : string.Empty);
this.txtSumCllection.Text = WebUtil.GetPaymentSum(model2.ContractID, "Con_Incomet_Payment", "CllectionPrice");
this.txtDiffAmount.Text = string.Concat(Convert.ToDecimal(this.txtContractPrice.Text) - Convert.ToDecimal(this.txtSumCllection.Text));
this.FileLink1.MID = 1908;
this.FileLink1.FID = this.hdGuid.Value;
this.FileLink1.Type = 1;
this.hldfContractId.Value = model2.ContractID;
}
public void BindGv()
{
Common2.BindGvTable(Common2.GetTable("F_FileInfo", " where ParentId='" + this.tvFile.SelectedValue + "' and ParentId!=Id and FileType=2 and IsValid='True' order by CreateTime desc"), this.gvFile, true);
}
public void InitPage()
{
OutReserveModel model = null;
if (base.Request.QueryString["id"] != null && base.Request.QueryString["ic"] == null)
{
model = this.outReserveBll.GetModel(base.Request.QueryString["id"]);
}
else
{
if (base.Request.QueryString["ic"] != null)
{
model = this.outReserveBll.GetModelByIc(base.Request.QueryString["ic"]);
}
}
this.lblExplain.Text = model.explain;
this.lblInTime.Text = Common2.GetTime(model.intime.ToString());
this.lblPeople.Text = model.person;
this.lblPPCode.Text = model.orcode;
this.lblPickingPeople.Text = model.PickingPeople;
PTdbmService source = new PTdbmService();
PTdbm pTdbm = (
from dbm in source
where dbm.V_bmbm == model.PickingSector && dbm.C_sfyx == "y"
select dbm).FirstOrDefault <PTdbm>();
if (pTdbm != null)
{
this.lblPickingSector.Text = pTdbm.V_BMMC;
}
else
{
this.lblPickingSector.Text = model.PickingSector;
}
PrjInfoModel modelByPrjGuid = this.pTPrjInfoBll.GetModelByPrjGuid(model.procode);
if (modelByPrjGuid != null)
{
this.lblProjectName.Text = modelByPrjGuid.PrjName;
}
else
{
DataTable tableByPrjGuid = this.pTPrjInfoBll.GetTableByPrjGuid(model.procode);
if (tableByPrjGuid.Rows.Count > 0)
{
this.lblProjectName.Text = tableByPrjGuid.Rows[0]["prjName"].ToString().Trim();
}
}
this.lblBllProducer.Text = model.person;
this.lblPrintDate.Text = DateTime.Now.ToShortDateString();
this.hdnProjectCode.Value = model.procode;
this.hdGuid.Value = model.orid;
this.hdImg.Value = model.writeName;
this.hdflowstate.Value = model.flowstate.ToString();
this.lblTerasuryName.Text = this.treasury.GetModel(model.tcode).tname;
string equipmentId = model.EquipmentId;
if (!string.IsNullOrEmpty(equipmentId))
{
EquEquipmentService equEquipmentService = new EquEquipmentService();
EquEquipment byId = equEquipmentService.GetById(equipmentId);
if (byId != null)
{
this.lblEquCode.Text = byId.EquCode;
}
}
List <OutStockModel> listArray = this.outStockBll.GetListArray(" where orcode='" + model.orcode + "'");
string text = "";
foreach (OutStockModel current in listArray)
{
text = text + "'" + current.scode + "',";
}
if (text != "")
{
text = text.Substring(0, text.Length - 1);
}
this.ViewState["DataTable"] = this.outStockBll.GetTableByOrcode(model.orcode, model.tcode);
this.BindGv();
this.FileLink1.MID = 1804;
this.FileLink1.FID = this.hdGuid.Value;
this.FileLink1.Type = 1;
}
public void BindGv()
{
this.BindGv(Common2.GetTable("Con_Incomet_Modify", ""));
}
protected void btnWord_Click(object sender, EventArgs e)
{
Common2 common = new Common2();
common.ExportToWordAll(this.GetTitleByTable(this.GetTable()), this.lblTitle.Text + ".doc");
}
public void delInfoCode()
{
Common2.DelByStrWhere("Sm_AlarmNum", " where infoCode='0'");
}
private void save(string v)
{
string strImg = dataUrl.Value.ToString();
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
foreach (GridViewRow gridViewRow in this.gvOutReserve.Rows)
{
CheckBox checkBox = gridViewRow.FindControl("cbBox") as CheckBox;
if (checkBox != null && checkBox.Checked)
{
List <OutStockModel> listArray = this.outStockBll.GetListArray(" where orcode='" + checkBox.ToolTip + "'");
OutReserveModel model = this.outReserveBll.GetModel(checkBox.ToolTip);
foreach (OutStockModel current in listArray)
{
List <TreasuryStockModel> listArray2 = this.treasuryStockBll.GetListArray(string.Concat(new object[]
{
" where scode='",
current.scode,
"' and sprice=",
current.sprice,
" and corp='",
current.corp,
"' and tcode='",
model.tcode,
"' order by intime asc"
}));
decimal num = 0m;
foreach (TreasuryStockModel current2 in listArray2)
{
num += current2.snumber;
}
if (current.number > num)
{
base.RegisterScript("alert('库存量不足!!')");
//base.RegisterScript("location='QOutReserve.aspx?prjGuid=" + base.Request["prjGuid"].ToString() + "'");
if (v == "wx")
{
base.RegisterScript("location='QOutReserveWX.aspx?prjGuid=" + base.Request["prjGuid"].ToString() + "'");
}
if (v == "pc")
{
base.RegisterScript("location='QOutReserve.aspx?prjGuid=" + base.Request["prjGuid"].ToString() + "'");
}
return;
}
foreach (TreasuryStockModel current3 in listArray2)
{
if (current3.snumber >= current.number)
{
current3.snumber -= current.number;
if (current3.snumber == 0m)
{
this.treasuryStockBll.Delete(current3.tsid);
}
else
{
this.treasuryStockBll.Update(current3);
}
Common2.AlarmMethod(current3.tcode, current3.scode);
break;
}
if (current3.snumber < current.number)
{
current.number -= current3.snumber;
this.treasuryStockBll.Delete(current3.tsid);
}
}
}
OutReserveModel model2 = this.outReserveBll.GetModel(checkBox.ToolTip);
model2.isout = true;
model2.IsOutTime = DateTime.Now;
model2.writeName = strImg;
int num2 = this.outReserveBll.Update(null, model2);
if (num2 > 0)
{
base.RegisterScript("alert('系统提示：\\n\\n操作成功');");
}
else
{
base.RegisterScript("alert('系统提示：\\n\\n操作失败');");
}
}
}
}
catch (Exception)
{
sqlTransaction.Rollback();
base.RegisterScript("alert('系统提示：\\n\\n出库出现异常,出库失败！');");
}
}
if (v == "wx")
{
base.RegisterScript("location='QOutReserveWX.aspx?prjGuid=" + base.Request["prjGuid"].ToString() + "'");
}
if (v == "pc")
{
base.RegisterScript("location='QOutReserve.aspx?prjGuid=" + base.Request["prjGuid"].ToString() + "'");
}
}
[WebMethod]//标示为web服务方法属性
public static string getList(string userId, string userType, string status, int rows, int page, string search)
{
////string strRes1 = " [{\"total\":\"15\",\"data\":[";
string strRes2 = "";
string strRes3 = "]}]";
//string strTemp = "";
////userType //my 我已提交 ;sy 我执行的 ;xg 我相关的
//if (userType == "cg") { strTemp = " and creater_id='" + userId + "' and status='0'"; }
//if (userType == "tj") { strTemp = " and creater_id='" + userId + "' and status ='"+ status + "'"; }
//if (userType == "sy") { strTemp = " and OA_Task.Id IN(select task_id from OA_Task_Append where user_id='" + userId + "' and (user_type='0' or user_type='2')) and status ='" + status + "'"; }
//if (userType == "xg") { strTemp = " and OA_Task.Id IN(select task_id from OA_Task_Append where user_id='" + userId + "' and (user_type='1' or user_type='2')) and status !='0' and status !='5'"; }
//string str1 = ((rows * (page - 1)) + 1).ToString();
//string str2 = (rows * page).ToString();
//string strs = " and pageindex between " + str1 + " and " + str2;
//string str3 = "";
//if (!string.IsNullOrEmpty(search))
//{
// str3 = " and title like '%" + search + "%'";
//}
//string strWhere = strTemp + str3;
//DataTable dtA = TaskService.GetTaskListTable(strWhere, userId);
//DataRow[] rowAs = dtA.Select(" pageindex >=" + str1 + " and pageindex<=" + str2);
//DataTable dtB = dtA.Clone();
//foreach (DataRow row in rowAs)
//{
// dtB.Rows.Add(row.ItemArray);
//}
//DataTable allTenderPrjReport = ProjectInfo.GetAllTenderPrjReport(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), this.txtName.Text.Trim(), this.dropPrjKindClass.SelectedValue, this.txtStartTime.Text.Trim(), this.txtEndTime.Text.Trim(), this.txtOwner.Text.Trim(), this.dropPrjState.SelectedValue, base.UserCode, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, this.dropPrjSource.SelectedValue, ref recordCount);
int recordCount = 0;
DataTable allTenderPrjReport = ProjectInfo.GetAllTenderPrjReport("", search, "", "", "", "", "", "", userId, page, rows, "", ref recordCount);
if (allTenderPrjReport.Rows.Count > 0)
{
foreach (DataRow dr in allTenderPrjReport.Rows)
{
strRes2 += "{\"PrjGuid\":\"" + dr["PrjGuid"] + "\",\"PrjCode\":\"" + dr["PrjCode"] + "\",\"PrjName\":\"" + dr["PrjName"] + "\",\"PrjCost\":\"" + dr["PrjCost"] + "\",\"PrjStateName\":\"" + dr["PrjStateName"] + "\",\"Owner\":\"" + dr["Owner"] + "\",\"StartDate\":\"" + Common2.GetTime(dr["StartDate"]) + "\",\"IsTender\":\"" + dr["IsTender"] + "\"},";
}
string strRes = " [{\"total\":\"" + allTenderPrjReport.Rows.Count + "\",\"data\":[" + strRes2.Substring(0, strRes2.Length - 1) + strRes3;
return(strRes);
}
else
{
return("");
}
}
public void BindGv()
{
this.BindGv(Common2.GetTable("Con_PayendFeedback", " where contractId='" + base.Request.QueryString["cid"] + "' order by InTime desc"));
}
protected void btnOk_Click(object sender, System.EventArgs e)
{
using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
{
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
foreach (GridViewRow gridViewRow in this.gvWastage.Rows)
{
CheckBox checkBox = gridViewRow.FindControl("cbBox") as CheckBox;
if (checkBox != null && checkBox.Checked)
{
System.Collections.Generic.List <SmWastageStockModel> listArray = this.smWastageStockBll.GetListArray(" where WastageCode='" + checkBox.ToolTip + "' ");
SmWastageModel modelByCode = this.smWastageBll.GetModelByCode(checkBox.ToolTip);
foreach (SmWastageStockModel current in listArray)
{
System.Collections.Generic.List <TreasuryStockModel> listArray2 = this.treasuryStockBll.GetListArray(string.Concat(new object[]
{
" where scode='",
current.ResourceCode,
"' and sprice=",
current.Sprice,
" and ISNULL(corp,'')='",
current.Corp,
"' and tcode='",
modelByCode.Treasurycode,
"' order by intime asc"
}));
decimal num = 0m;
foreach (TreasuryStockModel current2 in listArray2)
{
num += current2.snumber;
}
if (current.Number > num)
{
base.RegisterScript("top.ui.alert('库存量不足!')");
base.RegisterScript("location='ConfirmWastage.aspx'");
return;
}
foreach (TreasuryStockModel current3 in listArray2)
{
if (current3.snumber >= current.Number)
{
current3.snumber -= current.Number;
if (current3.snumber == 0m)
{
this.treasuryStockBll.Delete(current3.tsid);
}
else
{
this.treasuryStockBll.Update(current3);
}
Common2.AlarmMethod(current3.tcode, current3.scode);
break;
}
if (current3.snumber < current.Number)
{
current.Number -= current3.snumber;
this.treasuryStockBll.Delete(current3.tsid);
}
}
}
SmWastageModel modelByCode2 = this.smWastageBll.GetModelByCode(checkBox.ToolTip);
modelByCode2.Isout = true;
modelByCode2.IsOutTime = new System.DateTime?(System.DateTime.Now);
int num2 = this.smWastageBll.Update(null, modelByCode2);
if (num2 > 0)
{
base.RegisterScript("top.ui.show('操作成功');");
}
else
{
base.RegisterScript("top.ui.show('操作失败');");
}
}
}
}
catch (System.Exception)
{
sqlTransaction.Rollback();
base.RegisterScript("top.ui.alert('出库出现异常,出库失败！');");
}
}
base.RegisterScript("location='ConfirmWastage.aspx'");
}
public DataTable GetTitleByTable(DataTable dtSource)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("退库编号");
dataTable.Columns.Add("仓库名称");
dataTable.Columns.Add("资源编号");
dataTable.Columns.Add("资源名称");
dataTable.Columns.Add("资源类别");
dataTable.Columns.Add("规格");
dataTable.Columns.Add("品牌");
dataTable.Columns.Add("型号");
dataTable.Columns.Add("技术参数");
dataTable.Columns.Add("单位");
dataTable.Columns.Add("单价");
dataTable.Columns.Add("数量");
dataTable.Columns.Add("小计");
dataTable.Columns.Add("供应商");
dataTable.Columns.Add("项目名称");
dataTable.Columns.Add("申请日期");
if (dtSource.Rows.Count != 0)
{
int num = 0;
foreach (DataRow dataRow in dtSource.Rows)
{
num++;
DataRow dataRow2 = dataTable.NewRow();
dataRow2["序号"] = num.ToString();
dataRow2["退库编号"] = dataRow["rcode"];
dataRow2["仓库名称"] = dataRow["tname"];
dataRow2["资源编号"] = dataRow["ResourceCode"];
dataRow2["资源名称"] = dataRow["ResourceName"];
dataRow2["资源类别"] = dataRow["ResourceTypeName"];
dataRow2["规格"] = dataRow["Specification"];
dataRow2["品牌"] = dataRow["Brand"];
dataRow2["型号"] = dataRow["ModelNumber"];
dataRow2["技术参数"] = dataRow["TechnicalParameter"];
dataRow2["单位"] = dataRow["Name"];
dataRow2["单价"] = dataRow["sprice"];
dataRow2["数量"] = dataRow["number"];
dataRow2["小计"] = dataRow["xjsprice"];
dataRow2["供应商"] = dataRow["corpName"];
dataRow2["项目名称"] = dataRow["prjName"];
dataRow2["申请日期"] = Common2.GetTime(dataRow["intime"]);
dataTable.Rows.Add(dataRow2);
}
DataRow dataRow3 = dataTable.NewRow();
dataRow3["序号"] = "合计";
dataRow3["退库编号"] = "";
dataRow3["仓库名称"] = "";
dataRow3["资源编号"] = "";
dataRow3["资源名称"] = "";
dataRow3["资源类别"] = "";
dataRow3["规格"] = "";
dataRow3["品牌"] = "";
dataRow3["规格"] = "";
dataRow3["型号"] = "";
dataRow3["单位"] = "";
dataRow3["单价"] = "";
dataRow3["数量"] = "";
dataRow3["小计"] = dtSource.Compute("sum(xjsprice)", string.Empty).ToString();
dataRow3["供应商"] = "";
dataRow3["项目名称"] = "";
dataRow3["申请日期"] = "";
dataTable.Rows.Add(dataRow3);
}
return(dataTable);
}
public void BindPlanDetail()
{
if (this.MonthPlanID != "" && this.MonthPlanID.Length == 36)
{
DataTable dt = new DataTable();
Fund_Plan_MonthMainInfo fund_Plan_MonthMainInfo = new Fund_Plan_MonthMainInfo();
fund_Plan_MonthMainInfo = this.FA.GetMainInfoByMonthPlanID(this.MonthPlanID);
this.ltFlowState.Text = Common2.GetState(fund_Plan_MonthMainInfo.FlowState.ToString());
this.ltadduser.Text = fund_Plan_MonthMainInfo.OperatorName.ToString();
this.ltadddate.Text = fund_Plan_MonthMainInfo.OperateTime.ToShortDateString();
if (fund_Plan_MonthMainInfo.PrjGuid.ToString() != "")
{
this.ltprjname.Text = fund_Plan_MonthMainInfo.PrjName.ToString();
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(fund_Plan_MonthMainInfo.PlanYear.ToString()).Append("年");
stringBuilder.Append(fund_Plan_MonthMainInfo.PlanMonth.ToString()).Append("月");
stringBuilder.Append("资金");
this.plantype = fund_Plan_MonthMainInfo.PlanType;
int num = fund_Plan_MonthMainInfo.PlanYear;
int num2 = fund_Plan_MonthMainInfo.PlanMonth;
num2--;
if (num2 < 1)
{
num2 = 12;
num--;
}
if (!string.IsNullOrEmpty(fund_Plan_MonthMainInfo.Remark))
{
this.Literal2.Text = fund_Plan_MonthMainInfo.Remark.ToString();
}
string text = string.Empty;
if (fund_Plan_MonthMainInfo.PlanType == "payout")
{
this.hfldAdjunctPath.Value = ConfigHelper.Get("MonthPlanPayOut");
text = ConfigHelper.Get("MonthPlanPayOut");
this.showaudit1.BusiCode = "091";
dt = this.getLastPlan("payout", num2, num, fund_Plan_MonthMainInfo.PrjGuid.ToString());
stringBuilder.Append("支出");
}
else
{
text = ConfigHelper.Get("MonthPlanIncome");
this.hfldAdjunctPath.Value = ConfigHelper.Get("MonthPlanIncome");
this.showaudit1.BusiCode = "090";
dt = this.getLastPlan("income", num2, num, fund_Plan_MonthMainInfo.PrjGuid.ToString());
stringBuilder.Append("收入");
}
text += this.MonthPlanID.ToString();
string value = string.Empty;
if (!string.IsNullOrEmpty(text))
{
value = text;
text = HttpContext.Current.Server.MapPath(text);
}
DirectoryUtility directoryUtility = new DirectoryUtility(text);
List <Annex> annex = directoryUtility.GetAnnex();
ISerializable serializable = new JsonSerializer();
string a = serializable.Serialize <List <Annex> >(annex);
StringBuilder stringBuilder2 = new StringBuilder();
if (a != "[]")
{
for (int i = 0; i < annex.Count; i++)
{
if (annex[i].Name != null && annex[i].Name.ToString() != "")
{
stringBuilder2.Append("<a class=\"link\" target=\"_blank\" href=\"../../Common/DownLoad.aspx?path=").Append(value).Append("/").Append(annex[i].Name.ToString()).Append("\" title=\"" + HttpContext.Current.Server.UrlDecode(annex[i].Name.ToString()) + "\" >");
stringBuilder2.Append(HttpContext.Current.Server.UrlDecode(annex[i].Name.ToString()));
stringBuilder2.Append("</a> ");
}
}
}
this.Literal1.Text = stringBuilder2.ToString();
stringBuilder.Append("计划");
this.lblTitle.Text = stringBuilder.ToString();
DataTable planDetailList = this.FA.GetPlanDetailList(this.MonthPlanID, fund_Plan_MonthMainInfo.PlanType);
DataTable dataTable = this.UniteDataTable(planDetailList, new DataTable
{
Columns =
{
{
"sumtotal",
Type.GetType("System.String")
}
},
Rows =
{
new object[]
{
""
}
}
}, "ce");
dataTable = this.JoinDataTable(dataTable, dt, "eee");
this.ViewState["sourcesTable"] = dataTable;
this.gvwWebLineList.DataSource = dataTable;
this.gvwWebLineList.DataBind();
string[] value2 = new string[]
{
dataTable.Compute("SUM(PlanMoney)", string.Empty).ToString()
};
int[] index = new int[]
{
9
};
GridViewUtility.AddTotalRow(this.gvwWebLineList, value2, index);
}
}
[WebMethod]//标示为web服务方法属性
public static string getList(string userId, string userType, string status, int rows, int page, string search)
{
////string strRes1 = " [{\"total\":\"15\",\"data\":[";
string strRes2 = "";
string strRes3 = "]}]";
//string strTemp = "";
////userType //my 我已提交 ;sy 我执行的 ;xg 我相关的
//if (userType == "cg") { strTemp = " and creater_id='" + userId + "' and status='0'"; }
//if (userType == "tj") { strTemp = " and creater_id='" + userId + "' and status ='"+ status + "'"; }
//if (userType == "sy") { strTemp = " and OA_Task.Id IN(select task_id from OA_Task_Append where user_id='" + userId + "' and (user_type='0' or user_type='2')) and status ='" + status + "'"; }
//if (userType == "xg") { strTemp = " and OA_Task.Id IN(select task_id from OA_Task_Append where user_id='" + userId + "' and (user_type='1' or user_type='2')) and status !='0' and status !='5'"; }
//string str1 = ((rows * (page - 1)) + 1).ToString();
//string str2 = (rows * page).ToString();
//string strs = " and pageindex between " + str1 + " and " + str2;
//string str3 = "";
//if (!string.IsNullOrEmpty(search))
//{
// str3 = " and title like '%" + search + "%'";
//}
//string strWhere = strTemp + str3;
//DataTable dtA = TaskService.GetTaskListTable(strWhere, userId);
//DataRow[] rowAs = dtA.Select(" pageindex >=" + str1 + " and pageindex<=" + str2);
//DataTable dtB = dtA.Clone();
//foreach (DataRow row in rowAs)
//{
// dtB.Rows.Add(row.ItemArray);
//}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append(" and IsArchived='false' ");
//if (this.txtSignPeople.Value.Trim() != "")
//{
// stringBuilder.AppendFormat("AND v_xm LIKE '%{0}%'", this.Replace(this.txtSignPeople.Value.Trim()));
//}
//if (this.txtParty.Value.Trim() != "")
//{
// stringBuilder.AppendFormat("AND Party LIKE '%{0}%'", this.Replace(this.txtParty.Value.Trim()));
//}
//if (this.txtCParty.Text.Trim() != "")
//{
// stringBuilder.AppendFormat("AND CParty LIKE '%{0}%'", this.Replace(this.txtCParty.Text.Trim()));
//}
// DataTable dt= incometContractBll.GetTbByParamSort(this.Replace(this.txtContractCode.Text.Trim()), this.Replace(this.txtContractName.Text.Trim()), this.Replace(this.txtConType.Text.Trim()), this.txtStartSignedTime.Text.Trim(), this.txtEndSignedTime.Text.Trim(), this.txtStartContractPrice.Text.Trim(), this.txtEndContractPrice.Text.Trim(), this.txtProject.Text.Trim(), base.UserCode, stringBuilder.ToString(), this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize);
DataTable dt = incometContractBll.GetTbByParamSort("", search, "", "", "", "", "", "", userId, stringBuilder.ToString(), page, rows);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
strRes2 += "{\"ContractId\":\"" + dr["ContractId"] + "\",\"ContractCode\":\"" + dr["ContractCode"] + "\",\"ContractName\":\"" + dr["ContractName"] + "\",\"prjName\":\"" + dr["prjName"] + "\",\"sign\":\"" + dr["sign"] + "\",\"TypeName\":\"" + dr["TypeName"] + "\",\"SignedTime\":\"" + Common2.GetTime(dr["SignedTime"]) + "\"},";
}
string strRes = " [{\"total\":\"" + dt.Rows.Count + "\",\"data\":[" + strRes2.Substring(0, strRes2.Length - 1) + strRes3;
return(strRes);
}
else
{
return("");
}
}
public System.Collections.Generic.List <DataTable> GetData()
{
System.Collections.Generic.List <DataTable> list = new System.Collections.Generic.List <DataTable>();
DataTable depAllList = this.PrjMilestoneDetailSer.GetDepAllList(this.name);
DataTable dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("项目编号");
dataTable.Columns.Add("项目名称");
dataTable.Columns.Add("上报时间");
dataTable.Columns.Add("部门名称");
dataTable.Columns.Add("项目负责人");
dataTable.Columns.Add("项目储备额");
dataTable.Columns.Add("当年预测");
dataTable.Columns.Add("储备转换率");
dataTable.Columns.Add("明年预测");
dataTable.Columns.Add("初步接洽");
dataTable.Columns.Add("提供样品");
dataTable.Columns.Add("样品质量被接纳");
dataTable.Columns.Add("投标");
dataTable.Columns.Add("中标");
dataTable.Columns.Add("下订单");
dataTable.Columns.Add("交货");
dataTable.Columns.Add("销售确认");
dataTable.Columns.Add("项目失败");
dataTable.Columns.Add("工程总数");
for (int i = 0; i < depAllList.Rows.Count; i++)
{
DataRow dataRow = dataTable.NewRow();
dataRow["序号"] = i + 1;
dataRow["项目编号"] = depAllList.Rows[i][1].ToString();
dataRow["项目名称"] = depAllList.Rows[i][2].ToString();
dataRow["上报时间"] = depAllList.Rows[i][6].ToString();
dataRow["部门名称"] = depAllList.Rows[i][5].ToString();
dataRow["项目负责人"] = depAllList.Rows[i][4].ToString();
dataRow["项目储备额"] = depAllList.Rows[i][8].ToString();
dataRow["当年预测"] = depAllList.Rows[i][9].ToString();
dataRow["储备转换率"] = Common2.FormatRate(depAllList.Rows[i][10]);
dataRow["明年预测"] = depAllList.Rows[i][11].ToString();
dataRow["初步接洽"] = depAllList.Rows[i][12].ToString();
dataRow["提供样品"] = depAllList.Rows[i][13].ToString();
dataRow["样品质量被接纳"] = depAllList.Rows[i][14].ToString();
dataRow["投标"] = depAllList.Rows[i][15].ToString();
dataRow["中标"] = depAllList.Rows[i][16].ToString();
dataRow["下订单"] = depAllList.Rows[i][17].ToString();
dataRow["交货"] = depAllList.Rows[i][18].ToString();
dataRow["销售确认"] = depAllList.Rows[i][19].ToString();
dataRow["项目失败"] = depAllList.Rows[i][20].ToString();
dataRow["工程总数"] = System.Convert.ToInt32(depAllList.Rows[i][13]) + System.Convert.ToInt32(depAllList.Rows[i][14]) + System.Convert.ToInt32(depAllList.Rows[i][15]) + System.Convert.ToInt32(depAllList.Rows[i][16]) + System.Convert.ToInt32(depAllList.Rows[i][17]) + System.Convert.ToInt32(depAllList.Rows[i][18]) + System.Convert.ToInt32(depAllList.Rows[i][19]) + System.Convert.ToInt32(depAllList.Rows[i][20]) + System.Convert.ToInt32(depAllList.Rows[i][12]);
dataTable.Rows.Add(dataRow);
}
string[] values = new string[]
{
"合计",
"",
"",
"",
"",
"",
this.hfldStoreAmount.Value,
this.hfldForeCast.Value,
Common2.FormatRate(decimal.Divide(System.Convert.ToDecimal(this.hfldForeCast.Value), System.Convert.ToDecimal(this.hfldStoreAmount.Value))).ToString(),
this.hfldNextForeCast.Value,
this.hfldStone1.Value,
this.hfldStone2.Value,
this.hfldStone3.Value,
this.hfldStone4.Value,
this.hfldStone5.Value,
this.hfldStone6.Value,
this.hfldStone7.Value,
this.hfldStone8.Value,
this.hfldStone9.Value,
(System.Convert.ToInt32(this.hfldStone1.Value) + System.Convert.ToInt32(this.hfldStone2.Value) + System.Convert.ToInt32(this.hfldStone3.Value) + System.Convert.ToInt32(this.hfldStone4.Value) + System.Convert.ToInt32(this.hfldStone5.Value) + System.Convert.ToInt32(this.hfldStone6.Value) + System.Convert.ToInt32(this.hfldStone7.Value) + System.Convert.ToInt32(this.hfldStone8.Value) + System.Convert.ToInt32(this.hfldStone9.Value)).ToString()
};
dataTable.Rows.Add(values);
list.Add(dataTable);
return(list);
}
private DataTable GetExportData()
{
DataTable subProject = this.GetSubProject(0, 0);
DataTable dataTable = subProject.Clone();
dataTable.Columns["MonthDiffRate"].DataType = typeof(string);
dataTable.Columns["DiffRate"].DataType = typeof(string);
for (int i = 0; i < subProject.Rows.Count; i++)
{
DataRow dataRow = dataTable.NewRow();
dataRow["NUM"] = Common2.FormatDecimal(subProject.Rows[i]["NUM"]);
dataRow["TaskCode"] = Common2.FormatDecimal(subProject.Rows[i]["TaskCode"]);
dataRow["TaskName"] = Common2.FormatDecimal(subProject.Rows[i]["TaskName"]);
dataRow["PlanTotal"] = Common2.FormatDecimal(subProject.Rows[i]["PlanTotal"]);
dataRow["ActualTotal"] = Common2.FormatDecimal(subProject.Rows[i]["ActualTotal"]);
dataRow["DiffTotal"] = Common2.FormatDecimal(subProject.Rows[i]["DiffTotal"]);
dataRow["DiffRate"] = Common2.FormatRate(subProject.Rows[i]["DiffRate"]);
dataRow["PlanMonthTotal"] = Common2.FormatDecimal(subProject.Rows[i]["PlanMonthTotal"]);
dataRow["ActualMonthTotal"] = Common2.FormatDecimal(subProject.Rows[i]["ActualMonthTotal"]);
dataRow["MonthDiffTotal"] = Common2.FormatDecimal(subProject.Rows[i]["MonthDiffTotal"]);
dataRow["MonthDiffRate"] = Common2.FormatRate(subProject.Rows[i]["MonthDiffRate"]);
dataTable.Rows.Add(dataRow);
}
DataRow dataRow2 = dataTable.NewRow();
dataRow2["NUM"] = "合计";
dataRow2["PlanMonthTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(PlanMonthTotal)", string.Empty));
dataRow2["ActualMonthTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(ActualMonthTotal)", string.Empty));
dataRow2["MonthDiffTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(MonthDiffTotal)", string.Empty));
if ((decimal)dataRow2["PlanMonthTotal"] != 0m)
{
dataRow2["MonthDiffRate"] = Common2.FormatRate((decimal)dataRow2["MonthDiffTotal"] / (decimal)dataRow2["PlanMonthTotal"]);
}
else
{
dataRow2["MonthDiffRate"] = Common2.FormatRate(0);
}
dataRow2["PlanTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(PlanTotal)", string.Empty));
dataRow2["ActualTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(ActualTotal)", string.Empty));
dataRow2["DiffTotal"] = Common2.FormatDecimal(dataTable.Compute("SUM(DiffTotal)", string.Empty));
if ((decimal)dataRow2["PlanTotal"] != 0m)
{
dataRow2["DiffRate"] = Common2.FormatRate((decimal)dataRow2["DiffTotal"] / (decimal)dataRow2["PlanTotal"]);
}
else
{
dataRow2["DiffRate"] = Common2.FormatRate(0);
}
dataTable.Rows.Add(dataRow2);
dataTable.Columns.Remove("TaskId");
dataTable.Columns.Remove("OrderNumber");
dataTable.Columns["NUM"].ColumnName = "序号";
dataTable.Columns["TaskCode"].ColumnName = "任务编码";
dataTable.Columns["TaskName"].ColumnName = "任务名称";
dataTable.Columns["PlanTotal"].ColumnName = " 目标成本 ";
dataTable.Columns["ActualTotal"].ColumnName = " 实际成本 ";
dataTable.Columns["DiffTotal"].ColumnName = " 降低额 ";
dataTable.Columns["DiffRate"].ColumnName = " 降低率 ";
dataTable.Columns["PlanMonthTotal"].ColumnName = "目标成本";
dataTable.Columns["ActualMonthTotal"].ColumnName = "实际成本";
dataTable.Columns["MonthDiffTotal"].ColumnName = "降低额";
dataTable.Columns["MonthDiffRate"].ColumnName = "降低率";
return(dataTable);
}
void View_OnBookCreate(ref bool iscreated)
{
JianLi3Data.DataClasses1DataContext db = JianLiLinq.Default.DB;
string filesubpath;
// 更新数据库
if (isBookInLib)
{
book = (from b in db.Books
where b.BookName == View.BookTitle
select b).Single();
book.BookName = View.BookTitle;
book.BookPublishHouse = View.PublishHouse;
book.BookRate = View.BookRate;
if (book.BookCover == null)
{
Common2.UpdateBookCover(ref book, LocalPath);
}
JianLi3Data.File f = new JianLi3Data.File();
f.UploadDate = DateTime.Now;
// 确定子文件路径
if (book.Keywords.KeywordSubPath != null)
{
f.FilePath = book.Keywords.KeywordSubPath + "\\" + Path.GetFileName(LocalPath);
}
else
{
f.FilePath = Path.GetFileName(LocalPath);
}
// 文件最终位置
filesubpath = f.FilePath;
f.FileVersion = View.BookVersion;
f.Book = book;
f.FileDesc = View.FileDescription;
db.Files.InsertOnSubmit(f);
f.FilePath = JianLi3FileServiceManager.Default.MoveToLib(LocalPath, f);
// 更新数据库
db.SubmitChanges();
}
else
{
List <Keywords> bookkeywords = new List <Keywords>();
if (View.BookKeywords == "")
{
MessageBox.Show("没有给书籍设定关键字，无法完成归类，请使用“添加”按钮！");
return;
}
string[] keywordpaths = View.BookKeywords.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string kp in keywordpaths)
{
string[] ks = kp.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
if (ks.Length <= 1)
{
throw new Exception("关键字不该存在于顶层，需要类别。");
}
Keywords k = JianLiLinq.Default.CreateOrGetKeyword(kp);
if (!bookkeywords.Contains(k))
{
bookkeywords.Add(k);
}
}
Book b = new Book();
JianLi3Data.File f = new JianLi3Data.File();
f.UploadDate = DateTime.Now;
b.BookName = View.BookTitle;
b.BookPublishHouse = View.PublishHouse;
b.BookRate = View.BookRate;
b.BookSubTitle = View.BookSubTitle;
b.BookDefaultKeyword = bookkeywords[0].KeywordID;
b.BookType = BookHelper.BookTypeConvert(View.BookType);
Common2.UpdateBookCover(ref b, LocalPath, false);
if (bookkeywords[0].KeywordSubPath != null)
{
f.FilePath = bookkeywords[0].KeywordSubPath + "\\" + Path.GetFileName(LocalPath);
}
else
{
f.FilePath = Path.GetFileName(LocalPath);
}
f.FileVersion = View.BookVersion;
f.Book = b;
f.BookResource = View.IsResource;
f.FileDesc = View.FileDescription;
f.UserID = DataSettings.Default.User.UserID;
db.Books.InsertOnSubmit(b);
db.Files.InsertOnSubmit(f);
db.SubmitChanges();
b.File = f;// 出现循环的时候，还需要这么搞一下？
db.SubmitChanges();
foreach (Keywords k in bookkeywords)
{
BookKeywords bk = new BookKeywords();
bk.Book = b;
bk.Keywords = k;
b.BookKeywords.Add(bk);
db.BookKeywords.InsertOnSubmit(bk);
}
f.FilePath = JianLi3FileServiceManager.Default.MoveToLib(LocalPath, f);
// 更新数据库
db.SubmitChanges();
}
iscreated = true;
}
[WebMethod]//标示为web服务方法属性
public static string getList(string userId, string userType, string status, int rows, int page, string search)
{
string strRes2 = "";
string strRes3 = "]}]";
System.DateTime startDate = new System.DateTime(1753, 1, 1);
System.DateTime endDate = new System.DateTime(9999, 12, 31);
decimal startMoney = new decimal(-999999999999999L);
decimal endMoney = new decimal(999999999999999L);
//this.payoutContract.SelectLedger(startDate, endDate, startMoney, endMoney, this.txtContractCode.Text.Trim(), this.txtContractName.Text.Trim(), this.txtConType.Text.Trim(), this.txtProject.Text.Trim(), base.UserCode, text, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize);
DataTable dt = payoutContract.SelectLedger(startDate, endDate, startMoney, endMoney, "", search, "", "", userId, "", page, rows);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
strRes2 += "{\"ContractId\":\"" + dr["ContractID"] + "\",\"ContractCode\":\"" + dr["ContractCode"] + "\",\"ContractName\":\"" + dr["ContractName"] + "\",\"prjName\":\"" + dr["PrjName"] + "\",\"fictitious\":\"" + dr["fictitious"] + "\",\"TypeName\":\"" + dr["TypeName"] + "\",\"SignDate\":\"" + Common2.GetTime(dr["SignDate"]) + "\"},";
}
string strRes = " [{\"total\":\"" + dt.Rows.Count + "\",\"data\":[" + strRes2.Substring(0, strRes2.Length - 1) + strRes3;
return(strRes);
}
else
{
return("");
}
}
public int OutDepositoryConfirm(string acode, string yhdm)
{
DataTable table = AllocationAction.GetAllocation_StockList("sma.acode='" + acode + "' and flowstate=1 ");
DataTable materialDetailsOfDeposity = new DataTable();
int num = 0;
decimal num2 = 0M;
TreasuryPermitBll bll = new TreasuryPermitBll();
for (int i = 0; i < table.Rows.Count; i++)
{
decimal num4 = 0M;
bool flag = bll.IsPermitBool(table.Rows[i]["tcodea"].ToString(), yhdm);
object materialNumberOfDepository = AllocationAction.GetMaterialNumberOfDepository(table.Rows[i]["tcodea"].ToString(), " scode='" + table.Rows[i]["scode"].ToString() + "' and sprice='" + table.Rows[i]["sprice"].ToString() + "' and corp='" + table.Rows[i]["corp"].ToString() + "' ");
if (!flag)
{
num = -3;
break;
}
if (materialNumberOfDepository != null)
{
num4 = decimal.Parse(materialNumberOfDepository.ToString());
}
num2 = decimal.Parse(table.Rows[i]["number"].ToString());
if (num4 < num2)
{
num = -2;
break;
}
}
switch (num)
{
case -2:
case -3:
return(num);
default:
for (int j = 0; j < table.Rows.Count; j++)
{
decimal num6 = 0M;
num6 = decimal.Parse(table.Rows[j]["number"].ToString());
materialDetailsOfDeposity = AllocationAction.GetMaterialDetailsOfDeposity("tcode='" + table.Rows[j]["tcodea"].ToString() + "' and scode='" + table.Rows[j]["scode"].ToString() + "' and sprice='" + table.Rows[j]["sprice"].ToString() + "' and corp='" + table.Rows[j]["corp"].ToString() + "' order by intime asc ");
for (int k = 0; k < materialDetailsOfDeposity.Rows.Count; k++)
{
decimal num8 = 0M;
num8 = decimal.Parse(materialDetailsOfDeposity.Rows[k]["snumber"].ToString());
if (num8 > num6)
{
if (AllocationAction.UpdateNumberOfTreasury(materialDetailsOfDeposity.Rows[k]["tsid"].ToString(), num8 - num6) <= 0)
{
num = -1;
}
else
{
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
break;
}
if (num8 == num6)
{
if (new TreasuryStock().Delete(materialDetailsOfDeposity.Rows[k]["tsid"].ToString()) <= 0)
{
num = -1;
}
else
{
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
break;
}
if (num8 < num6)
{
if (new TreasuryStock().Delete(materialDetailsOfDeposity.Rows[k]["tsid"].ToString()) <= 0)
{
num = -1;
break;
}
num6 -= num8;
Common2.AlarmMethod(table.Rows[j]["tcodea"].ToString(), table.Rows[j]["scode"].ToString());
}
}
if (num == -1)
{
break;
}
num = 1;
}
break;
}
if (num == 1)
{
AllocationAction.UpdateState(true, false, acode, "Out");
}
return(num);
}
private void bindModel(string ic)
{
this.upload.InnerHtml = this.FilesBind(ic);
AccountLogic accountLogic = new AccountLogic();
string userNameByUserCode = accountLogic.GetUserNameByUserCode(this.Session["yhdm"].ToString());
this.ltadduser.Text = userNameByUserCode;
this.ltadddate.Text = string.Format("{0:d}", DateTime.Now);
PrjLoadModel prjLoadModel = new PrjLoadModel();
PrjLoadLogic prjLoadLogic = new PrjLoadLogic();
if (ic.Length == 36)
{
prjLoadModel = prjLoadLogic.GetModel(new Guid(ic));
if (prjLoadModel != null)
{
this.ltrprjname.Text = prjLoadModel.PrjName;
this.ltrAccountNum.Text = prjLoadModel.LoanCode;
this.ltrLoanCause.Text = prjLoadModel.LoanCause;
this.ltrLoanDate.Text = string.Format("{0:d}", prjLoadModel.LoanDate);
this.ltrLoanFund.Text = string.Format("{0:0.000}", double.Parse(prjLoadModel.LoanFund.ToString()));
this.ltrLoanMan.Text = prjLoadModel.LoanmanName;
this.ltrLoanRate.Text = string.Format("{0:0.00}", double.Parse(prjLoadModel.LoanRate.ToString()) * 100.0) + "%";
this.ltrPlanReturnDate.Text = string.Format("{0:d}", prjLoadModel.PlanReturnDate);
this.ltrFlowState.Text = Common2.GetState(prjLoadModel.FlowState.ToString());
if (prjLoadModel.FlowState.ToString() == "1")
{
this.trrepayment.Style.Add("display", "");
Fund_Loan_Repayment fund_Loan_Repayment = new Fund_Loan_Repayment();
DataTable repaymentInfoByLLoanID = fund_Loan_Repayment.GetRepaymentInfoByLLoanID(ic);
if (repaymentInfoByLLoanID.Rows.Count > 0)
{
DataRow dataRow = repaymentInfoByLLoanID.Rows[0];
int arg_24D_0 = (int)dataRow["syday"];
if (prjLoadModel.ReturnState == 0)
{
this.lbRepayment.Text = "未还清";
this.lbRepayment.Style.Add("color", "red");
}
else
{
if (prjLoadModel.ReturnState == 1)
{
this.lbRepayment.Text = "已还清";
this.lbRepayment.Style.Add("color", "#008B45");
}
}
}
}
string text = string.Empty;
text = prjLoadModel.Remark;
if (!string.IsNullOrEmpty(text) && text.Length > 180)
{
int num = prjLoadModel.Remark.Length / 180;
for (int i = 1; i <= num; i++)
{
int num2 = 180 * i;
if (num2 == 180)
{
num2 = 175;
}
text = text.Insert(num2, "<br/>");
}
}
this.ltrRemark.Text = text;
}
}
}
public System.Collections.Generic.List <DataTable> GetData()
{
string sWhere = string.Concat(new object[]
{
" AND MONTH(RptDate)=",
System.Convert.ToInt32(this.month) + 1,
" AND YEAR(RptDate)=",
System.Convert.ToInt32(this.year)
});
System.Collections.Generic.List <DataTable> list = new System.Collections.Generic.List <DataTable>();
DataTable count = this.PrjMilestoneDetailSer.GetCount(sWhere, this.name);
DataTable dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("项目负责人");
dataTable.Columns.Add("项目储备额");
dataTable.Columns.Add("当年预测");
dataTable.Columns.Add("储备转换率");
dataTable.Columns.Add("明年预测");
dataTable.Columns.Add("初步接洽");
dataTable.Columns.Add("提供样品");
dataTable.Columns.Add("样品质量被接纳");
dataTable.Columns.Add("投标");
dataTable.Columns.Add("中标");
dataTable.Columns.Add("下订单");
dataTable.Columns.Add("交货");
dataTable.Columns.Add("销售确认");
dataTable.Columns.Add("项目失败");
dataTable.Columns.Add("工程总数");
for (int i = 0; i < count.Rows.Count; i++)
{
DataRow dataRow = dataTable.NewRow();
dataRow["序号"] = i + 1;
dataRow["项目负责人"] = count.Rows[i][1].ToString();
dataRow["项目储备额"] = count.Rows[i][3].ToString();
dataRow["当年预测"] = count.Rows[i][4].ToString();
if (System.Convert.ToDecimal(count.Rows[i][3]) != 0m)
{
dataRow["储备转换率"] = Common2.FormatRate(System.Convert.ToDecimal(count.Rows[i][4]) / System.Convert.ToDecimal(count.Rows[i][3]));
}
else
{
dataRow["储备转换率"] = Common2.FormatRate("0");
}
dataRow["明年预测"] = count.Rows[i][5].ToString();
dataRow["初步接洽"] = count.Rows[i][6].ToString();
dataRow["提供样品"] = count.Rows[i][7].ToString();
dataRow["样品质量被接纳"] = count.Rows[i][8].ToString();
dataRow["投标"] = count.Rows[i][9].ToString();
dataRow["中标"] = count.Rows[i][10].ToString();
dataRow["下订单"] = count.Rows[i][11].ToString();
dataRow["交货"] = count.Rows[i][12].ToString();
dataRow["销售确认"] = count.Rows[i][13].ToString();
dataRow["项目失败"] = count.Rows[i][14].ToString();
dataRow["工程总数"] = System.Convert.ToInt32(count.Rows[i][13]) + System.Convert.ToInt32(count.Rows[i][14]) + System.Convert.ToInt32(count.Rows[i][6]) + System.Convert.ToInt32(count.Rows[i][7]) + System.Convert.ToInt32(count.Rows[i][8]) + System.Convert.ToInt32(count.Rows[i][9]) + System.Convert.ToInt32(count.Rows[i][10]) + System.Convert.ToInt32(count.Rows[i][11]) + System.Convert.ToInt32(count.Rows[i][12]);
dataTable.Rows.Add(dataRow);
}
list.Add(dataTable);
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
this.btnSave.Attributes["onclick"] = "return CheckEmpty()";
if (DateTime.Now.DayOfWeek >= DayOfWeek.Friday)
{
this.txtWPlanDate.Text = Common2.GetTime(DateTime.Now.AddDays((double)(5 - Convert.ToInt32(DateTime.Now.DayOfWeek))));
}
else
{
this.txtWPlanDate.Text = Common2.GetTime(DateTime.Now.AddDays((double)(-(double)(Convert.ToInt32(DateTime.Now.DayOfWeek) + 2))));
}
if (base.Request.QueryString["Action"] == "Add")
{
this.txtReportUser.Text = new MainPlanAndAction().BackUserName(base.UserCode);
this.txtPart.Text = MainPlanAndAction.BackDeptOrID(base.UserCode)[1];
this.txtDuty.Text = new MainPlanAndAction().BackUserName(base.UserCode);
string text = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00");
string sqlString = string.Concat(new string[]
{
"select max(WkpUserCode) from pm_workplan_weekplan where wkpreporttype=",
base.Request.QueryString["planType"].ToString(),
"and wkpreportuser='******'and WkpUserCode LIKE '%",
text,
"%'"
});
DataTable dataTable = publicDbOpClass.DataTableQuary(sqlString);
if (dataTable.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dataTable.Rows[0][0].ToString()))
{
this.txtWPcode.Text = text + "001";
}
else
{
int num = Convert.ToInt32(dataTable.Rows[0][0].ToString().Substring(8, 3)) + 1;
if (num < 10)
{
this.txtWPcode.Text = text + "00" + num.ToString();
}
else
{
if (num < 100)
{
this.txtWPcode.Text = text + "0" + num.ToString();
}
else
{
this.txtWPcode.Text = text + num.ToString();
}
}
}
}
else
{
this.txtWPcode.Text = text + "001";
}
}
if (base.Request["action"] == null)
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "", "alert('参数错误,本页无法正常显示')", true);
return;
}
if (base.Request["action"] == "Edit")
{
MainPlan model = new MainPlanAndAction().GetModel(new Guid(base.Request.QueryString["wkpId"]));
MainPlanAndAction mainPlanAndAction = new MainPlanAndAction();
this.txtWPcode.ReadOnly = true;
this.txtWPcode.ToolTip = "单号是不允许编辑的";
this.txtWPcode.Text = model.WkpUserCode;
this.txtPart.Text = mainPlanAndAction.BackDept(model.WkpDeptId);
this.txtReportUser.Text = mainPlanAndAction.BackUserName(model.WkpReportUser);
string sqlString2 = "select wkpremarks from pm_workplan_plansummary where wkpid='" + new Guid(base.Request.QueryString["wkpid"].ToString()) + "'";
DataTable dataTable2 = publicDbOpClass.DataTableQuary(sqlString2);
this.txtProduce.Text = ((dataTable2.Rows.Count > 0) ? PlanDetailAction.DeCodeStr(dataTable2.Rows[0][0].ToString()) : "");
this.txtWPlanDate.Text = Common2.GetTime(model.WkpRecordDate);
string sqlString3 = "select * from pm_workplan_weekplandetails where WkpId='" + base.Request.QueryString["wkpId"].ToString() + "'";
DataTable dataTable3 = publicDbOpClass.DataTableQuary(sqlString3);
int count = dataTable3.Rows.Count;
int count2 = dataTable3.Columns.Count;
this.hdnDataCount.Value = count.ToString();
List <PlanDetail> planDemos = new PlanDetailAction().GetPlanDemos(new Guid(base.Request.QueryString["wkpId"]));
if (count > 0)
{
this.txtContent.Text = PlanDetailAction.DeCodeStr(planDemos[0].WkpContents);
this.txtDuty.Text = planDemos[0].WkpChief;
this.txtResponsibility.Text = planDemos[0].WkpPersons;
this.BeginDate.Text = planDemos[0].WkpStartTime.ToShortDateString();
this.EndDate.Text = planDemos[0].WkpEndTime.ToShortDateString();
for (int i = 1; i < count; i++)
{
for (int j = 0; j < count2; j++)
{
if (j == count2 - 1)
{
HtmlInputHidden expr_581 = this.hdnvalue;
expr_581.Value = expr_581.Value + dataTable3.Rows[i][j].ToString() + "?";
}
else
{
if (j == 3 || j == 4)
{
HtmlInputHidden expr_5C5 = this.hdnvalue;
expr_5C5.Value = expr_5C5.Value + DateTime.Parse(dataTable3.Rows[i][j].ToString()) + "|";
}
else
{
if (j == 2)
{
HtmlInputHidden expr_60B = this.hdnvalue;
expr_60B.Value = expr_60B.Value + PlanDetailAction.DeCodeStr(dataTable3.Rows[i][j].ToString()) + "|";
}
else
{
HtmlInputHidden expr_647 = this.hdnvalue;
expr_647.Value = expr_647.Value + dataTable3.Rows[i][j].ToString() + "|";
}
}
}
}
}
}
}
}
}
protected void Bind_gvwStorage(string strWhere)
{
Common2.BindGvTable(this.ReportAlocationDataSource(strWhere), this.gvwStorage, false);
}
private void InitUpdateAndQuery()
{
string userCode = this.Session["yhdm"].ToString();
DataTable dataTable = PersonnelAction.QueryPersonnelById(userCode);
if (dataTable != null && dataTable.Rows.Count == 1)
{
this.lblBllProducer.Text = dataTable.Rows[0]["v_xm"].ToString();
}
this.materialWant.GetModel(this.wantplanCode);
this.lblPrintDate.Text = System.DateTime.Now.ToShortDateString();
PayoutContractModel model = this.payoutContract.GetModel(ContractManage_PayoutContract_ParyoutContractQuery.contractID);
if (model != null)
{
this.bindTarget(ContractManage_PayoutContract_ParyoutContractQuery.contractID);
this.txtProject.Text = model.PrjName;
this.txtPrjType.Text = this.GetPrjTypeName(new System.Guid(model.PrjGuid));
this.txtContractCode.Text = model.ContractCode;
this.txtContractName.Text = model.ContractName;
this.txtPreMoney.Text = ((!model.PrepayMoney.HasValue) ? string.Empty : model.PrepayMoney.ToString());
this.txtContractMoney.Text = ((!model.ContractMoney.HasValue) ? string.Empty : model.ContractMoney.ToString());
this.txtModifiedMoney.Text = ((!model.ModifiedMoney.HasValue) ? string.Empty : model.ModifiedMoney.ToString());
this.contractType.Text = this.getContractName(model.TypeID);
IncometContractBll incometContractBll = new IncometContractBll();
IncometContractModel model2 = incometContractBll.GetModel(model.InContractID);
if (model2 != null)
{
PrjInfoModel arg_1CE_0 = model2.Project;
this.txtIncomeContract.Text = ((model2.ContractName == null) ? "" : model2.ContractName);
}
else
{
this.txtIncomeContract.Text = "";
}
this.txtAName.Text = model.AName;
this.txtBName.Text = model.CorpName;
this.txtAddress.Text = model.Address;
this.txtSignDate.Text = ((!model.SignDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.SignDate).ToShortDateString());
DataTable table = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=27 and ParentCodeID=0");
DataTable table2 = Common2.GetTable("dbo.XPM_Basic_CodeList", "where typeId=25 and ParentCodeID=0");
if (table.Rows.Count > 0)
{
foreach (DataRow dataRow in table.Rows)
{
if (dataRow["NoteID"].ToString() == model.BalanceMode)
{
this.txtBalanceMode.Text = dataRow["CodeName"].ToString();
}
}
}
if (table2.Rows.Count > 0)
{
foreach (DataRow dataRow2 in table2.Rows)
{
if (dataRow2["NoteID"].ToString() == model.PayMode)
{
this.txtdropPayMode.Text = dataRow2["CodeName"].ToString();
}
}
}
this.txtStartDate.Text = ((!model.StartDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.StartDate).ToShortDateString());
this.txtEndDate.Text = ((!model.EndDate.HasValue) ? string.Empty : System.Convert.ToDateTime(model.EndDate).ToShortDateString());
this.txtPaymentCondition.Text = model.PaymentCondition;
this.txtMainItem.Text = model.MainItem;
this.txtNotes.Text = model.Notes;
this.txtCapitalNumber.Text = ((model.CapitalNumber == null) ? "" : model.CapitalNumber.ToString());
this.txtfinanceNumber.Text = ((model.FinanceNumber == null) ? "" : model.FinanceNumber.ToString());
this.txtfinanceProject.Text = ((model.FinanceProject == null) ? "" : model.FinanceProject.ToString());
this.Literal1.Text = this.FilesBind(1901, model.ContractID);
if (model.ContractMoney.ToString() == "")
{
this.txtCapitalNumber.Text = ConverRMB.Convert(0m);
}
else
{
decimal number = System.Convert.ToDecimal(model.ContractMoney);
this.txtCapitalNumber.Text = ConverRMB.Convert(number);
}
if (model.ModifiedMoney.ToString() == "")
{
this.txtCapitalizationModifiedMoney.Text = ConverRMB.Convert(0m);
}
else
{
decimal number2 = System.Convert.ToDecimal(model.ModifiedMoney);
this.txtCapitalizationModifiedMoney.Text = ConverRMB.Convert(number2);
}
string key;
switch (key = model.ConState.ToString())
{
case "0":
this.txtTypeName.Text = "执 行";
return;
case "1":
this.txtTypeName.Text = "中 止";
return;
case "2":
this.txtTypeName.Text = "保 内";
return;
case "3":
this.txtTypeName.Text = "保 外";
return;
case "4":
this.txtTypeName.Text = "解 除";
return;
case "5":
this.txtTypeName.Text = "终 止";
return;
}
this.txtTypeName.Text = "----";
}
}
public void getMonthPlanInfo()
{
DateTime dateTime = Convert.ToDateTime(this.QueryDateCtrl1.Month + "-01");
this.hdnYear.Value = dateTime.Year.ToString();
this.hdnMonth.Value = dateTime.Month.ToString();
string text = string.Empty;
this.hfplantype.Value = this.plantype;
if (this.plantype == "payout")
{
this.FileUpload1.Class = "MonthPlanPayOut";
text = "支出";
}
else
{
if (this.plantype == "income")
{
this.FileUpload1.Class = "MonthPlanIncome";
text = "收入";
}
}
this.FileUpload1.RecordCode = this.hdfMonthPalnID.Value;
this.lblTitle.Text = string.Concat(new string[]
{
this.prjName,
" ",
dateTime.ToString("yyyy年MM月"),
"资金",
text,
"计划"
});
bool flag = false;
if (!string.IsNullOrEmpty(this.hdfMonthPalnID.Value))
{
flag = this.FA.IsExitFundPlanMainInfo(this.plantype, this.hdfMonthPalnID.Value, this.PrjGuid.ToString());
}
if (flag)
{
Fund_Plan_MonthMainInfo mainInfoByMonthPlanID = this.FA.GetMainInfoByMonthPlanID(this.hdfMonthPalnID.Value);
this.txtPlanMonth.Text = string.Concat(new object[]
{
mainInfoByMonthPlanID.PlanYear,
"年",
mainInfoByMonthPlanID.PlanMonth,
"月"
});
this.txtProName.Value = mainInfoByMonthPlanID.PrjName;
this.hdfcontrcn.Value = mainInfoByMonthPlanID.PrjGuid.ToString();
this.txtadduser.Text = mainInfoByMonthPlanID.OperatorName;
this.hdfMonthPalnID.Value = mainInfoByMonthPlanID.MonthPlanID.ToString();
this.txtadddate.Text = Common2.GetTime(mainInfoByMonthPlanID.OperateTime);
this.txtRemark.Text = mainInfoByMonthPlanID.Remark;
}
else
{
this.txtPlanMonth.Text = dateTime.ToString("yyyy年MM月");
this.txtProName.Value = this.prjName;
AccountLogic accountLogic = new AccountLogic();
this.txtadduser.Text = accountLogic.GetUserNameByUserCode(this.Session["yhdm"].ToString());
this.txtadddate.Text = Common2.GetTime(DateTime.Now);
}
this.BindPlanDetail();
}