public bool insertNewEntity(TransferringOrder b)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Date", SqlDbType.NVarChar), new SqlParameter("@OutHouseID", SqlDbType.Int), new SqlParameter("@InHouseID", SqlDbType.Int), new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@Quantity", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Float), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Operator", SqlDbType.NVarChar), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@Ticket", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.NVarChar) };
parameters[0].Value = b.Date;
parameters[1].Value = b.OutHouseID;
parameters[2].Value = b.InHouseID;
parameters[3].Value = b.ProductsID;
parameters[4].Value = b.Quantity;
parameters[5].Value = b.Price;
parameters[6].Value = b.UserName;
parameters[7].Value = b.Operator;
parameters[8].Value = b.TradeDate;
parameters[9].Value = b.Ticket;
parameters[10].Value = b.Description;
parameters[11].Value = b.State;
parameters[12].Value = b.ID;
SQLHelper.RunProcedure("p_TransferringOrder_insertNewEntity", parameters, out rowsAffected);
return(1 == rowsAffected);
}
protected void AddSubmit_Click(object sender, EventArgs e)
{
string str0 = TransferringOrderID.Text.ToString();
string str1 = Date.Text.ToString();
string str2 = Operator.Text.ToString();
string str3 = TradeDate.Text.ToString();
string str4 = Ticket.Text.ToString();
string str5 = Description.Text.ToString();
int n1 = int.Parse(OutHouseID.Text.ToString());
int n2 = int.Parse(InHouseID.Text.ToString());
int n3 = int.Parse(ProductsID.Text.ToString());
int n4 = int.Parse(Quantity.Text.ToString());
TransferringOrder t = new TransferringOrder();
t.Date = str1;
t.Description = str5;
t.ID = str0;
t.InHouseID = n2;
t.Operator = str2;
t.OutHouseID = n1;
t.ProductsID = n3;
t.Quantity = n4;
t.State = 0;
t.Ticket = str4;
t.TradeDate = str3;
t.UserName = getUserName();
if (Leyp.SQLServerDAL.Stock.Factory.gerTransferringOrderDAL().insertNewEntity(t))
{
Panel1.Visible = false;
Panel2.Visible = true;
}
else
{
Panel1.Visible = false;
Panel2.Visible = true; HyperLink1.Text = "操作失败！返回列表";
}
}
