/// <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; }