public static DataTable GetSubStore(Model.Office.HumanManager.DeptModel model)
        {
            StringBuilder sbSql = new StringBuilder();

            sbSql.Append("SELECT * FROM officedba.DeptInfo WHERE ");
            sbSql.Append(" CompanyCD=@CompanyCD and SaleFlag=1");
            SqlParameter[] Paras = { new SqlParameter("@CompanyCD", SqlDbType.VarChar) };
            Paras[0].Value = model.CompanyCD;
            return(SqlHelper.ExecuteSql(sbSql.ToString(), Paras));
        }
Пример #2
0
 public static DataTable GetSubStore(Model.Office.HumanManager.DeptModel model)
 {
     return(XBase.Data.Office.LogisticsDistributionManager.SubProductSendPriceDBHelper.GetSubStore(model));
 }