/// <summary>
/// 对象实体绑定数据
/// </summary>
public VAN_OA.Model.EFrom.Tb_ProjectInvs ReaderBind(IDataReader dataReader)
{
Model.EFrom.Tb_ProjectInvs model = new Model.EFrom.Tb_ProjectInvs();
object ojb;
ojb = dataReader["Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Id = (int)ojb;
}
ojb = dataReader["PId"];
if (ojb != null && ojb != DBNull.Value)
{
model.PId = (int)ojb;
}
ojb = dataReader["BuyTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.BuyTime = (DateTime)ojb;
}
model.InvModel = dataReader["InvModel"].ToString();
model.InvName = dataReader["InvName"].ToString();
model.InvUnit = dataReader["InvUnit"].ToString();
ojb = dataReader["InvNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvNum = (decimal)ojb;
}
ojb = dataReader["InvPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvPrice = (decimal)ojb;
}
ojb = dataReader["InvCarPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvCarPrice = (decimal)ojb;
}
ojb = dataReader["InvTaskPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvTaskPrice = (decimal)ojb;
}
ojb = dataReader["InvManPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvManPrice = (decimal)ojb;
}
model.Remark = dataReader["Remark"].ToString();
ojb = dataReader["Total"];
if (ojb != null && ojb != DBNull.Value)
{
model.Total = Convert.ToDecimal(ojb);
}
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtBuyTime.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写购买日期！');</script>");
txtBuyTime.Focus();
return;
}
else
{
try
{
Convert.ToDateTime(txtBuyTime.Text);
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('购买日期格式错误！');</script>");
txtBuyTime.Focus();
return;
}
}
if (txtInvName.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('材料名称不能为空！');</script>");
txtInvName.Focus();
return;
}
if (txtInvNum.Text.Trim() == "")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量不能为空！');</script>");
txtInvName.Focus();
return;
}
else
{
try
{
Convert.ToDecimal(txtInvNum.Text);
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数量格式错误！');</script>");
txtBuyTime.Focus();
return;
}
try
{
if (txtInvPrice.Text != "")
{
Convert.ToDecimal(txtInvPrice.Text);
}
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('材料费格式错误！');</script>");
txtInvPrice.Focus();
return;
}
try
{
if (txtInvCarPrice.Text != "")
{
Convert.ToDecimal(txtInvCarPrice.Text);
}
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('运费格式错误！');</script>");
txtInvCarPrice.Focus();
return;
}
try
{
if (txtInvTaskPrice.Text != "")
{
Convert.ToDecimal(txtInvTaskPrice.Text);
}
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('会务费格式错误！');</script>");
txtInvTaskPrice.Focus();
return;
}
try
{
if (txtInvManPrice.Text != "")
{
Convert.ToDecimal(txtInvManPrice.Text);
}
}
catch (Exception)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('管理费格式错误！');</script>");
txtInvManPrice.Focus();
return;
}
}
DateTime BuyTime = DateTime.Parse(this.txtBuyTime.Text);
decimal total = 0;
string InvModel = this.txtInvModel.Text;
string InvName = this.txtInvName.Text;
string InvUnit = this.txtInvUnit.Text;
decimal InvNum = decimal.Parse(this.txtInvNum.Text);
decimal? InvPrice = null;
if (txtInvPrice.Text != "")
{
InvPrice = decimal.Parse(this.txtInvPrice.Text);
total += decimal.Parse(this.txtInvPrice.Text);
}
decimal?InvCarPrice = null;
if (txtInvCarPrice.Text != "")
{
InvCarPrice = decimal.Parse(this.txtInvCarPrice.Text);
total += decimal.Parse(this.txtInvCarPrice.Text);
}
decimal?InvTaskPrice = null;
if (txtInvTaskPrice.Text != "")
{
InvTaskPrice = decimal.Parse(this.txtInvTaskPrice.Text);
total += decimal.Parse(this.txtInvTaskPrice.Text);
}
decimal?InvManPrice = null;
if (txtInvManPrice.Text != "")
{
InvManPrice = decimal.Parse(this.txtInvManPrice.Text);
total += decimal.Parse(this.txtInvManPrice.Text);
}
string Remark = this.txtRemark.Text;
Model.EFrom.Tb_ProjectInvs model = new Model.EFrom.Tb_ProjectInvs();
model.Total = total;
model.BuyTime = BuyTime;
model.InvModel = InvModel;
model.InvName = InvName;
model.InvUnit = InvUnit;
model.InvNum = InvNum;
model.InvPrice = InvPrice;
model.InvCarPrice = InvCarPrice;
model.InvTaskPrice = InvTaskPrice;
model.InvManPrice = InvManPrice;
model.Remark = Remark;
if (ViewState["state"] != null)
{
if (ViewState["state"].ToString() == "add")
{
List <Tb_ProjectInvs> POOrders = Session["ProInvs"] as List <Tb_ProjectInvs>;
POOrders.Add(model);
Session["ProInvs"] = POOrders;
setTotal(POOrders);
gvList.DataSource = POOrders;
gvList.DataBind();
this.txtBuyTime.Text = "";
this.txtInvModel.Text = "";
this.txtInvName.Text = "";
this.txtInvUnit.Text = "";
this.txtInvNum.Text = "";
this.txtInvPrice.Text = "";
this.txtInvCarPrice.Text = "";
this.txtInvTaskPrice.Text = "";
this.txtInvManPrice.Text = "";
this.txtRemark.Text = "";
ViewState["state"] = "add";
return;
}
if (ViewState["state"].ToString() == "edit" && ViewState["index"] != null)
{
int index = Convert.ToInt32(ViewState["index"]);
if (Session["ProInvs"] != null)
{
List <Tb_ProjectInvs> POOrders = Session["ProInvs"] as List <Tb_ProjectInvs>;
Tb_ProjectInvs modelPro = POOrders[index];
model.Id = modelPro.Id;
model.IfUpdate = true;
POOrders[index] = model;
Session["ProInvs"] = POOrders;
setTotal(POOrders);
gvList.DataSource = POOrders;
gvList.DataBind();
}
}
}
btnAdd.Enabled = true;
btnSave.Enabled = false;
btnCancel.Enabled = false;
}
/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <VAN_OA.Model.EFrom.Tb_ProjectInvs> GetListArray_Rep(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM Tb_ProjectInv_View ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by ProNo desc ");
List <VAN_OA.Model.EFrom.Tb_ProjectInvs> list = new List <VAN_OA.Model.EFrom.Tb_ProjectInvs>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
Model.EFrom.Tb_ProjectInvs model = new Model.EFrom.Tb_ProjectInvs();
object ojb;
ojb = dataReader["Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Id = (int)ojb;
}
//ojb = dataReader["PId"];
//if (ojb != null && ojb != DBNull.Value)
//{
// model.PId = (int)ojb;
//}
ojb = dataReader["BuyTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.BuyTime = (DateTime)ojb;
}
model.InvModel = dataReader["InvModel"].ToString();
model.InvName = dataReader["InvName"].ToString();
model.InvUnit = dataReader["InvUnit"].ToString();
ojb = dataReader["InvNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvNum = (decimal)ojb;
}
ojb = dataReader["InvPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvPrice = (decimal)ojb;
}
ojb = dataReader["InvCarPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvCarPrice = (decimal)ojb;
}
ojb = dataReader["InvTaskPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvTaskPrice = (decimal)ojb;
}
ojb = dataReader["InvManPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.InvManPrice = (decimal)ojb;
}
model.Remark = dataReader["Remark"].ToString();
ojb = dataReader["CreateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateTime = (DateTime)ojb;
}
model.ProNo = dataReader["ProNo"].ToString();
model.ProName = dataReader["ProName"].ToString();
ojb = dataReader["loginName"];
if (ojb != null && ojb != DBNull.Value)
{
model.LoginName = ojb.ToString();
}
ojb = dataReader["State"];
if (ojb != null && ojb != DBNull.Value)
{
model.State = ojb.ToString();
}
ojb = dataReader["Total"];
if (ojb != null && ojb != DBNull.Value)
{
model.Total = Convert.ToDecimal(ojb);
}
ojb = dataReader["guestName"];
if (ojb != null && ojb != DBNull.Value)
{
model.GuestName = ojb.ToString();
}
ojb = dataReader["efState"];
if (ojb != null && ojb != DBNull.Value)
{
model.EfState = ojb.ToString();
}
list.Add(model);
}
}
}
return(list);
}