/// <summary>
/// 得到一个对象实体
/// </summary>
public VAN_OA.Model.EFrom.tb_FundsUse GetModel_File(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" fileName,fileType,fileNo ");
strSql.Append(" from tb_FundsUse ");
strSql.Append(" where tb_FundsUse.Id=" + id + "");
VAN_OA.Model.EFrom.tb_FundsUse model = null;
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
if (dataReader.Read())
{
model = new tb_FundsUse();
object ojb;
ojb = dataReader["fileName"];
if (ojb != null && ojb != DBNull.Value)
{
model.fileName = ojb.ToString();
}
ojb = dataReader["fileType"];
if (ojb != null && ojb != DBNull.Value)
{
model.fileType = ojb.ToString();
}
ojb = dataReader["fileNo"];
if (ojb != null && ojb != DBNull.Value)
{
model.fileNo = (byte[])ojb;
}
}
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
if (base.Request["ProId"] != null)
{
if (Request["allE_id"] == null)//单据增加
{
}
else//单据审批
{
#region 加载 请假单数据
tb_FundsUseService fundsSer = new tb_FundsUseService();
tb_FundsUse fundsModel = fundsSer.GetModel(Convert.ToInt32(Request["allE_id"]));
lblDepartName.Text = fundsModel.DepartName;
lblDateTime.Text = fundsModel.datetiem.ToString();
lblName.Text = fundsModel.LoginName;
lblTotal.Text = fundsModel.total.ToString();
lblUseTo.Text = fundsModel.useTo;
lblType.Text = fundsModel.type;
lblTotalDa.Text = ConvertMoney(fundsModel.total);
lblIdea.Text = fundsModel.Idea;
lblInvoce.Text = fundsModel.Invoce;
lblHouseNo.Text = fundsModel.HouseNo;
lblDepartName1.Text = fundsModel.DepartName;
lblDate1.Text = fundsModel.datetiem.ToString();
lblName1.Text = fundsModel.LoginName;
lblTotal1.Text = fundsModel.total.ToString();
lblUseTo1.Text = fundsModel.useTo;
lblTyp1.Text = fundsModel.type;
lblDaTotal1.Text = ConvertMoney(fundsModel.total);
lblIdea1.Text = fundsModel.Idea;
lblInvoce1.Text = fundsModel.Invoce;
lblHouseN01.Text = fundsModel.HouseNo;
lblDepartName2.Text = fundsModel.DepartName;
lblDate2.Text = fundsModel.datetiem.ToString();
lblName2.Text = fundsModel.LoginName;
lblTotal2.Text = fundsModel.total.ToString();
lblUserTo2.Text = fundsModel.useTo;
lblType2.Text = fundsModel.type;
lblDaTotal2.Text = ConvertMoney(fundsModel.total);
lblIdea2.Text = fundsModel.Idea;
lblInvoce2.Text = fundsModel.Invoce;
lblHouseNo2.Text = fundsModel.HouseNo;
#endregion
}
}
}
}
