protected void Page_Load(object sender, EventArgs e)
{
id = MyCommFun.Obj2Int(MXRequest.GetQueryString("id"));
ModelInfo = bll.GetModelToPrint(id);
if (ModelInfo != null)
{
//金额大小写转换
je = RMBUtil.CmycurD(ModelInfo.Amount);
}
else
{
ModelInfo = new Model.T_Bill();
}
base.ClientScript.RegisterStartupScript(base.ClientScript.GetType(), "myscript", "<script> PrintTable();</script>");
}
private void ShowInfo(int _id)
{
//获取实体对象
ModelInfo = bll.GetModel(_id);
//收料编号
txt_BNum.Text = ModelInfo.BNum;
//存放仓库
ddl_WareHouse.SelectedValue = ModelInfo.WareHouse;
//客户姓名
txt_CustomerName.Text = ModelInfo.CustomerName;
//移动电话
txt_Mobile.Text = ModelInfo.Mobile;
//固定电话
txt_Tel.Text = ModelInfo.Tel;
//代发银行
ddl_BankName.SelectedValue = ModelInfo.BankName;
//银行账号
txt_BankAccount.Text = ModelInfo.BankAccount;
//户名
txt_AccountName.Text = ModelInfo.AccountName;
//产品名称ID
ddl_ProductName.SelectedValue = MyCommFun.ObjToStr(ModelInfo.ProjectId);
//产品规格ID
ddl_ProductStandard.SelectedValue = MyCommFun.ObjToStr(ModelInfo.ProductStandardId);
//单位
txt_Unit.Text = ModelInfo.Unit;
//毛重
txt_GrossWeight.Text = MyCommFun.ObjToStr(ModelInfo.GrossWeight);
//皮重
txt_Tare.Text = MyCommFun.ObjToStr(ModelInfo.Tare);
//净重
txt_NetWeight.Value = MyCommFun.ObjToStr(ModelInfo.NetWeight);
//价格
txt_Price.Text = MyCommFun.ObjToStr(ModelInfo.Price);
//金额
txt_Amount.Value = MyCommFun.ObjToStr(ModelInfo.Amount);
//备注
this.txt_Remark.Text = ModelInfo.Remark;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Model.T_Bill model)
{
return(dal.Insert(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.T_Bill model)
{
return(dal.Update(model));
}
public static Model.T_Bill FillModelByRow(DataRow row)
{
Model.T_Bill model = new Model.T_Bill();
if (row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
model.BNum = row["BNum"].ToString
();
model.WareHouse = row["WareHouse"].ToString
();
model.CustomerName = row["CustomerName"].ToString
();
model.CardNumber = row["CardNumber"].ToString
();
model.Mobile = row["Mobile"].ToString
();
model.Tel = row["Tel"].ToString
();
model.BankName = row["BankName"].ToString
();
model.BankAccount = row["BankAccount"].ToString
();
model.AccountName = row["AccountName"].ToString
();
model.ProductName = row["ProductName"].ToString
();
model.ProductStandard = row["ProductStandard"].ToString
();
model.Unit = row["Unit"].ToString
();
if (row["GrossWeight"].ToString() != "")
{
model.GrossWeight = decimal.Parse(row["GrossWeight"].ToString());
}
if (row["Tare"].ToString() != "")
{
model.Tare = decimal.Parse(row["Tare"].ToString());
}
if (row["NetWeight"].ToString() != "")
{
model.NetWeight = decimal.Parse(row["NetWeight"].ToString());
}
if (row["Price"].ToString() != "")
{
model.Price = decimal.Parse(row["Price"].ToString());
}
if (row["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(row["Amount"].ToString());
}
model.Remark = row["Remark"].ToString
();
model.PricingMan = row["PricingMan"].ToString
();
if (row["LoanMark"].ToString() != "")
{
model.LoanMark = int.Parse(row["LoanMark"].ToString());
}
model.LoanMan = row["LoanMan"].ToString
();
if (row["LoanDate"].ToString() != "")
{
model.LoanDate = DateTime.Parse(row["LoanDate"].ToString());
}
model.LoanType = row["LoanType"].ToString
();
model.LoanRemark = row["LoanRemark"].ToString
();
if (row["DeleteMark"].ToString() != "")
{
model.DeleteMark = int.Parse(row["DeleteMark"].ToString());
}
if (row["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(row["AddTime"].ToString());
}
model.AddPerson = row["AddPerson"].ToString
();
if (row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
model.ModifyPerson = row["ModifyPerson"].ToString
();
model.U1 = row["U1"].ToString
();
model.U2 = row["U2"].ToString
();
if (row["U3"].ToString() != "")
{
model.U3 = decimal.Parse(row["U3"].ToString());
}
if (row["U4"].ToString() != "")
{
model.U4 = decimal.Parse(row["U4"].ToString());
}
if (row["CustomerID"].ToString() != "")
{
model.CustomerID = int.Parse(row["CustomerID"].ToString());
}
if (row["ProjectId"].ToString() != "")
{
model.ProjectId = int.Parse(row["ProjectId"].ToString());
}
if (row["ProductStandardId"].ToString() != "")
{
model.ProductStandardId = int.Parse(row["ProductStandardId"].ToString());
}
return(model);
}
