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 = "操作失败!返回列表"; } }