/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_VerificationRecordEntity ut) { ProjID_Hidden.Value = ut.FundID.ToString(); Protype_Hidden.Value = ut.ProjID.ToString(); if (!ut.ProjID.Equals(0)) { ProjID_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectBudgetFormat(BusinessFacadeShanlitech_Location.T_ProjectBudgetDisp(ut.ProjID)); } imag_Fapiao.ImageUrl = ut.InvoiceFolder; ContractFolder_Image.ImageUrl = ut.ContractFolder; PayAmount_Input.Text = PayAmount_Disp.Text = ut.PayAmount.ToString(); Undertaker_Disp.Text = BusinessFacade.sys_UserDisp(ut.Undertaker).U_LoginName; if (!string.IsNullOrEmpty(ut.CreateTime.ToString())) { CreateTime_Disp.Text = ut.CreateTime.ToString(); } else { CreateTime_Disp.Text = DateTime.Now.ToString(); } Check_Disp.Text = BusinessFacade.sys_UserDisp(ut.Checker).U_LoginName; if (!string.IsNullOrEmpty(ut.CheckTime.ToString())) { CheckTime_Disp.Text = ut.CheckTime.ToString(); } else { CheckTime_Disp.Text = DateTime.Now.ToString(); } Approver_Disp.Text = BusinessFacade.sys_UserDisp(Convert.ToInt32(ut.Approver)).U_LoginName; if (!string.IsNullOrEmpty(ut.ApprovalTime.ToString())) { ApproverTime_Disp.Text = ut.ApprovalTime.ToString(); } else { ApproverTime_Disp.Text = DateTime.Now.ToString(); } ShenHeNote_Disp.Text = ut.ShenHeNote; PiZhunNote_Disp.Text = ut.PiZhunNote; CunDangNote_Disp.Text = ut.CunDangNote; }
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_VerificationRecordEntity ut) { ProjID_Hidden.Value = ut.FundID.ToString(); Protype_Hidden.Value = ut.ProjID.ToString(); if (!ut.ProjID.Equals(0)) { ProjID_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectBudgetFormat(BusinessFacadeShanlitech_Location.T_ProjectBudgetDisp(ut.ProjID)); } //imag_Fapiao.ImageUrl = ut.InvoiceFolder; //ContractFolder_Image.ImageUrl = ut.ContractFolder; ////PayAmount_Input.Text = // PayAmount_Disp.Text = ut.PayAmount.ToString(); Undertaker_Disp.Text = BusinessFacade.sys_UserDisp(ut.Undertaker).U_LoginName; if (!string.IsNullOrEmpty(ut.CreateTime.ToString())) { CreateTime_Disp.Text = ut.CreateTime.ToString(); } else { CreateTime_Disp.Text = DateTime.Now.ToString(); } CheckState_Disp.Text = InnitList(ut.TransferState); ShenHeState_Disp.Text = ut.ShenHeNote; }
/// <summary> /// 新增/删除/修改 T_VerificationRecordEntity (核销申请单) /// </summary> /// <param name="fam">T_VerificationRecordEntity实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public static Int32 T_VerificationRecordInsertUpdateDelete(T_VerificationRecordEntity fam) { return DataProvider.Instance().T_VerificationRecordInsertUpdateDelete(fam); }
/// <summary> /// 根据ID返回 T_VerificationRecordEntity实体类 单笔资料 (核销申请单) /// </summary> /// <param name="ID">ID ID</param> /// <returns>返回 T_VerificationRecordEntity实体类 ID为0则无记录</returns> public static T_VerificationRecordEntity T_VerificationRecordDisp(Int32 ID) { T_VerificationRecordEntity fam = new T_VerificationRecordEntity(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = string.Format(" Where {0}.{1} = {2}", "T_VerificationRecord", "ID", ID); int RecordCount = 0; List<T_VerificationRecordEntity> lst = T_VerificationRecordList(qp, out RecordCount); if (RecordCount > 0) { fam = lst[0]; } return fam; }
/// <summary> /// 将记录集转为T_VerificationRecordEntity实体类 (核销申请单) /// </summary> /// <param name="dr">记录集</param> /// <param name="Fileds">字段名列表</param> /// <returns>T_VerificationRecordEntity</returns> protected T_VerificationRecordEntity PopulateT_VerificationRecordEntity(IDataReader dr, Dictionary<string, string> Fileds) { T_VerificationRecordEntity nc = new T_VerificationRecordEntity(); if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID if (Fileds.ContainsKey("FundID") && !Convert.IsDBNull(dr["FundID"])) nc.FundID = Convert.ToInt32(dr["FundID"]); // 所属经费申请单 if (Fileds.ContainsKey("ProjID") && !Convert.IsDBNull(dr["ProjID"])) nc.ProjID = Convert.ToInt32(dr["ProjID"]); // 所属项目 if (Fileds.ContainsKey("InvoiceFolder") && !Convert.IsDBNull(dr["InvoiceFolder"])) nc.InvoiceFolder = Convert.ToString(dr["InvoiceFolder"]).Trim(); // 发票联 if (Fileds.ContainsKey("ContractFolder") && !Convert.IsDBNull(dr["ContractFolder"])) nc.ContractFolder = Convert.ToString(dr["ContractFolder"]).Trim(); // 合同协议 if (Fileds.ContainsKey("Undertaker") && !Convert.IsDBNull(dr["Undertaker"])) nc.Undertaker = Convert.ToInt32(dr["Undertaker"]); // 承办人 if (Fileds.ContainsKey("Checker") && !Convert.IsDBNull(dr["Checker"])) nc.Checker = Convert.ToInt32(dr["Checker"]); // 申请人 if (Fileds.ContainsKey("Approver") && !Convert.IsDBNull(dr["Approver"])) nc.Approver = Convert.ToInt64(dr["Approver"]); // 批准人 if (Fileds.ContainsKey("TransferState") && !Convert.IsDBNull(dr["TransferState"])) nc.TransferState = Convert.ToInt32(dr["TransferState"]); // 流转状态(0为申请状态,1为审核状态,2为批准状态) if (Fileds.ContainsKey("State") && !Convert.IsDBNull(dr["State"])) nc.State = Convert.ToInt32(dr["State"]); // 存档状态(0为流转状态,1为存档状态,9为删除) if (Fileds.ContainsKey("CreateTime") && !Convert.IsDBNull(dr["CreateTime"])) nc.CreateTime = Convert.ToDateTime(dr["CreateTime"]); // 创建时间 if (Fileds.ContainsKey("CheckTime") && !Convert.IsDBNull(dr["CheckTime"])) nc.CheckTime = Convert.ToDateTime(dr["CheckTime"]); // 审核时间 if (Fileds.ContainsKey("ApprovalTime") && !Convert.IsDBNull(dr["ApprovalTime"])) nc.ApprovalTime = Convert.ToDateTime(dr["ApprovalTime"]); // 批准时间 if (Fileds.ContainsKey("PayAmount") && !Convert.IsDBNull(dr["PayAmount"])) nc.PayAmount = Convert.ToDouble(dr["PayAmount"]); // 实际支出 if (Fileds.ContainsKey("IntegrityCheckCode") && !Convert.IsDBNull(dr["IntegrityCheckCode"])) nc.IntegrityCheckCode = Convert.ToString(dr["IntegrityCheckCode"]).Trim(); // 信息完整性校验码 if (Fileds.ContainsKey("ShenHeNote") && !Convert.IsDBNull(dr["ShenHeNote"])) nc.ShenHeNote = Convert.ToString(dr["ShenHeNote"]).Trim(); // 审核状态备注 if (Fileds.ContainsKey("PiZhunNote") && !Convert.IsDBNull(dr["PiZhunNote"])) nc.PiZhunNote = Convert.ToString(dr["PiZhunNote"]).Trim(); // 批准状态备注 if (Fileds.ContainsKey("CunDangNote") && !Convert.IsDBNull(dr["CunDangNote"])) nc.CunDangNote = Convert.ToString(dr["CunDangNote"]).Trim(); // CunDangNote return nc; }
/// <summary> /// 新增/删除/修改 T_VerificationRecordEntity (核销申请单) /// </summary> /// <param name="fam">T_VerificationRecord实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public abstract Int32 T_VerificationRecordInsertUpdateDelete(T_VerificationRecordEntity fam);
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_VerificationRecordEntity ut) { ProjID_Hidden.Value = ut.FundID.ToString(); Protype_Hidden.Value = ut.ProjID.ToString(); if (!ut.ProjID.Equals(0)) { ProjID_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectBudgetFormat(BusinessFacadeShanlitech_Location.T_ProjectBudgetDisp(ut.ProjID)); } ShenHeNote_Disp.Text = ut.ShenHeNote; CunDangNote_Disp.Text = ut.CunDangNote; }
protected void Button2_Click(object sender, EventArgs e) { string Checkbox_Value = (string)Common.sink("Checkbox", MethodType.Post, 2000, 1, DataType.Str); string[] Checkbox_Value_Array = Checkbox_Value.Split(','); Int32 IDX = 0; for (int i = 0; i < Checkbox_Value_Array.Length; i++) { if (Int32.TryParse(Checkbox_Value_Array[i], out IDX)) { T_VerificationRecordEntity et = new T_VerificationRecordEntity(); et.DataTable_Action_ = DataTable_Action.Delete; et.ID = IDX; BusinessFacadeShanlitech_Location.T_VerificationRecordInsertUpdateDelete(et); } } EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_VerificationRecordEntity ut) { FundID_Input.Text = FundID_Disp.Text = ut.FundID.ToString(); ProjID_Input.Text = ProjID_Disp.Text = ut.ProjID.ToString(); InvoiceFolder_Input.Text = InvoiceFolder_Disp.Text = ut.InvoiceFolder.ToString(); ContractFolder_Input.Text = ContractFolder_Disp.Text = ut.ContractFolder.ToString(); Undertaker_Input.Text = Undertaker_Disp.Text = ut.Undertaker.ToString(); Checker_Input.Text = Checker_Disp.Text = ut.Checker.ToString(); Approver_Input.Text = Approver_Disp.Text = ut.Approver.ToString(); TransferState_Input.Text = TransferState_Disp.Text = ut.TransferState.ToString(); State_Input.Text = State_Disp.Text = ut.State.ToString(); CreateTime_Input.Text = CreateTime_Disp.Text = ut.CreateTime.ToString(); CheckTime_Input.Text = CheckTime_Disp.Text = ut.CheckTime.ToString(); ApprovalTime_Input.Text = ApprovalTime_Disp.Text = ut.ApprovalTime.ToString(); PayAmount_Input.Text = PayAmount_Disp.Text = ut.PayAmount.ToString(); IntegrityCheckCode_Input.Text = IntegrityCheckCode_Disp.Text = ut.IntegrityCheckCode.ToString(); }