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