/// <summary>
/// 查询出所有的数据
/// </summary>
/// <returns>DataSet</returns>
public static DataSet SelectAll()
{
DataBase db = new DataBase();
DAL.DataBaseVisitor visitor = new DAL.Port.PortVisitor();
DataSet ds = new DataSet();
try
{
ds = db.ReturnDataSet(visitor, "Select", "D_Base");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ds;
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string AddData(Model.Port.PortModel port, int Iport)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Port.PortVisitor();
bool bSuc = false;
int nEffectRows = 0;
//long id = BLL.PublicFun.PublicFun.MaxId("D_Plan");
SqlParameter[] prams ={
//db.MakeInParam("@ID", SqlDbType.BigInt,12, BLL.PublicFun.PublicFun.MaxId("D_Plan")),
db.MakeInParam("@fcustid", SqlDbType.Int,4, port.Fcustid),
db.MakeInParam("@FDeptID", SqlDbType.Int,4, port.FDeptID),
db.MakeInParam("@fitemid", SqlDbType.Int,4, port.Fitemid),
db.MakeInParam("@FUnitID", SqlDbType.Int,4, port.FUnitID),
db.MakeInParam("@FFManagerID", SqlDbType.Int,4, port.FFManagerID),
db.MakeInParam("@FSManagerID", SqlDbType.Int,4, port.FSManagerID),
db.MakeInParam("@FDCStockID", SqlDbType.Int,4, port.FDCStockID),
db.MakeInParam("@fbiller", SqlDbType.Int,4, port.Fbiller),
db.MakeInParam("@FQty", SqlDbType.Decimal,50, port.FQty),
db.MakeInParam("@FPrice", SqlDbType.Decimal,50, port.FPrice),
db.MakeInParam("@FAmount", SqlDbType.Decimal,50, port.FAmount),
db.MakeInParam("@FDate", SqlDbType.DateTime,50, port.FDate),
};
try
{
if (Iport == 0)
bSuc = db.PortTransactSql1(visitor, "Insert", prams, out nEffectRows);
if (Iport == 1)
bSuc = db.PortTransactSql2(visitor, "Insert", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
