/// <summary> /// 插入 /// </summary> /// <param name="PWtable"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public bool insertPWarehouseTable_titleBll(PWarehouseTable_title PWtable, string SQLCommand) { if (pwd.insertPWarehouseTable_titleDal(PWtable, SQLCommand) > 0) { return(true); } else { return(false); } }
PWarehouseTable_title GetPWarehouseTable_title(string Fid) { PWarehouseTable_title pwtable = new PWarehouseTable_title() { ID = Guid.NewGuid().ToString(), WarehouseName = txt_Name.Text.Trim(), FID = Fid }; return(pwtable); }
/// <summary> /// 插入 /// </summary> /// <param name="PWtable"></param> /// <param name="SQLCommand"></param> /// <returns></returns> public int insertPWarehouseTable_titleDal(PWarehouseTable_title PWtable, string SQLCommand) { string sql = SQLhelp.GetSQLCommand(SQLCommand); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 80) { Value = PWtable.ID }, new SqlParameter("@WarehouseName", SqlDbType.VarChar, 100) { Value = PWtable.WarehouseName }, new SqlParameter("@FID", SqlDbType.VarChar, 80) { Value = PWtable.FID } }; return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms)); }