/// <summary>
/// 插入
/// </summary>
/// <param name="pware"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool insertPWarehouseTable_PickingOutBll(PWarehouseTable_PickingOut pware, string SQLCommand)
{
if (pwareDal.insertPWarehouseTable_PickingOutDal(pware, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
PWarehouseTable_PickingOut GetPWarehouseTable_PickingOut()
{
PWarehouseTable_PickingOut pw = new PWarehouseTable_PickingOut();
pw.PurchaseReceiptID = DateTime.Now.ToString("yyyyMMddHHmmssfff");
pw.PurchaseNo = TxtBox_PurchaseNo.Text.Trim();
pw.SupplierName = TxtBox_SupplierName.Text.Trim();
pw.BatchNo = TxtBox_BatchNo.Text.Trim();
pw.MaterialCode = TxtBox_MaterialCode.Text.Trim();
pw.MaterialName = TxtBox_MaterialName.Text.Trim();
pw.MaterialSpecifications = TxtBox_MaterialSpecifications.Text.Trim();
pw.ProductQuantity = ip_ProductQuantity.Value;
pw.note = TxtBox_note.Text.Trim();
pw.StorageAddress = "";
pw.UserName = UsersHelp.Userslist[0].UserName;
return(pw);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="pware"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPWarehouseTable_PickingOutDal(PWarehouseTable_PickingOut pware, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@PurchaseReceiptID", SqlDbType.VarChar, 100)
{
Value = pware.PurchaseReceiptID
},
new SqlParameter("@PurchaseNo", SqlDbType.VarChar, 80)
{
Value = pware.PurchaseNo
},
new SqlParameter("@SupplierName", SqlDbType.VarChar, 80)
{
Value = pware.SupplierName
},
new SqlParameter("@BatchNo", SqlDbType.VarChar, 80)
{
Value = pware.BatchNo
},
new SqlParameter("@MaterialCode", SqlDbType.VarChar, 80)
{
Value = pware.MaterialCode
},
new SqlParameter("@MaterialName", SqlDbType.VarChar, 80)
{
Value = pware.MaterialName
},
new SqlParameter("@MaterialSpecifications", SqlDbType.VarChar, 80)
{
Value = pware.MaterialSpecifications
},
new SqlParameter("@ProductQuantity", SqlDbType.Int)
{
Value = pware.ProductQuantity
},
new SqlParameter("@note", SqlDbType.VarChar, 200)
{
Value = pware.note
},
new SqlParameter("@StorageAddress", SqlDbType.VarChar, 255)
{
Value = pware.StorageAddress
},
new SqlParameter("@UserName", SqlDbType.VarChar, 50)
{
Value = pware.UserName
},
};
try
{
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
catch (Exception)
{
throw;
}
}
