/// <summary>
/// 根据编号查询表内容
/// </summary>
/// <param name="Item">D_Plan表model</param>
public static void GetPlan(ref Model.Plan.D_Plan Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
SqlDataReader dr = null;
SqlParameter[] prams ={
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code),
};
try
{
db.GetDataReader(visitor, prams, out dr, "Select_D_PlanByCode");
if (dr.Read())
{
Item.Plan_Item = dr["Plan_Item"].ToString();
Item.Plan_Send = dr["Plan_Send"].ToString();
Item.Plan_Specs = dr["Plan_Specs"].ToString();
Item.Plan_Accept = dr["Plan_Accept"].ToString();
Item.Plan_CountWay = dr["Plan_CountWay"].ToString();
Item.Plan_Type = dr["Plan_Type"].ToString();
Item.Plan_Num = Convert.ToDecimal(dr["Plan_Num"]);
Item.Plan_SpareNum = Convert.ToDecimal(dr["Plan_SpareNum"]);
Item.Plan_Money = Convert.ToDecimal(dr["Plan_Money"]);
Item.Plan_SpareMoney = Convert.ToDecimal(dr["Plan_SpareMoney"]);
Item.Remark = dr["Remark"].ToString();
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
dr.Close();
db.Dispose();
}
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="Item">model</param>
/// <returns></returns>
public static string AddData(Model.Plan.D_Plan Item)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
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("@Plan_Code", SqlDbType.VarChar,50, Item.Plan_Code),
db.MakeInParam("@Plan_CountWay", SqlDbType.VarChar,50, Item.Plan_CountWay),
db.MakeInParam("@Plan_Item", SqlDbType.VarChar,50, Item.Plan_Item),
db.MakeInParam("@Plan_Specs", SqlDbType.VarChar,50, Item.Plan_Specs),
db.MakeInParam("@Plan_Type", SqlDbType.VarChar,50, Item.Plan_Type),
db.MakeInParam("@Plan_Send", SqlDbType.VarChar,50, Item.Plan_Send),
db.MakeInParam("@Plan_Accept", SqlDbType.VarChar,50, Item.Plan_Accept),
db.MakeInParam("@Plan_Num", SqlDbType.Decimal,50, Item.Plan_Num),
db.MakeInParam("@Plan_SpareNum", SqlDbType.Decimal,50, Item.Plan_SpareNum),
db.MakeInParam("@Plan_Money", SqlDbType.Decimal,50, Item.Plan_Money),
db.MakeInParam("@Plan_SpareMoney", SqlDbType.Decimal,50, Item.Plan_SpareMoney),
db.MakeInParam("@Remark", SqlDbType.VarChar,50, Item.Remark),
db.MakeInParam("@Begin_Time", SqlDbType.VarChar,50, Item.Begin_Time),
db.MakeInParam("@End_Time", SqlDbType.VarChar,50, Item.End_Time),
};
try
{
bSuc = db.TransactSql(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";
}
/// <summary>
/// 是否作废数据
/// </summary>
/// <param name="ID">表ID</param>
/// <param name="Used">是否作废</param>
/// <returns>"0101"表示成功，"0"表示失败</returns>
public static string Update_Used(string Code, int Used)
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
bool bSuc = false;
int nEffectRows = 0;
SqlParameter[] prams ={
db.MakeInParam("@Plan_Used", SqlDbType.Bit,8, Used),
db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50,Code),
};
try
{
bSuc = db.TransactSql(visitor, "Used", prams, out nEffectRows);
}
catch (Exception ex) { throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
if (bSuc && nEffectRows > 0)
return "0101";
else
return "0";
}
/// <summary>
/// 查询出所有的类型
/// </summary>
/// <returns>DataSet</returns>
public static DataSet SelectType()
{
DataBase db = new DataBase();
DataBaseVisitor visitor = new DAL.Plan.PlanVisitor();
DataSet ds = new DataSet();
try
{
ds = db.ReturnDataSet(visitor, "Select_Type", "D_Type");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
finally
{
db.Dispose();
}
return ds;
}
