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(); }