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)); }
public static DataTable GetSubStore(Model.Office.HumanManager.DeptModel model) { return(XBase.Data.Office.LogisticsDistributionManager.SubProductSendPriceDBHelper.GetSubStore(model)); }