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