public DataTable getShopCollectTime()
{
string strSql = "SELECT * FROM ShopCollectTime";
DataTable dt = SqlDbmanager.queryBySql(SqlExtension.GetSelectSqlCmdByParams(strSql));
return(dt);
}
public bool insertShopCollectTime(ShopCollectTime obj)
{
if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetInsertSqlCmd("ShopCollectTime", obj)))
{
return(true);
}
return(false);
}
public bool deleteShopCollectTime(ShopCollectTime obj)
{
if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetDeleteSqlCmd("ShopCollectTime", obj, new List <string> {
"SCT02=@SCT02", "SCT03=@SCT03", "SCT04=@SCT04"
})))
{
return(true);
}
return(false);
}
public int insertShopCollectTime(List <ShopCollectTime> times)
{
var cmdList = new List <SqlCommand>();
foreach (var time in times)
{
cmdList.Add(SqlExtension.GetInsertSqlCmd("ShopCollectTime", time));
}
return(SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList));
}
public bool deleteShopCollectDaily(ShopCollectDaily obj)
{
if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetDeleteSqlCmd("ShopCollectDaily", obj, new List <string> {
"SCD02=@SCD02"
})))
{
return(true);
}
return(false);
}
public int insertShopCollectDaily(List <ShopCollectDaily> shopCollects)
{
var cmdList = new List <SqlCommand>();
foreach (var shopcollect in shopCollects)
{
cmdList.Add(SqlExtension.GetInsertSqlCmd("ShopCollectDaily", shopcollect));
}
return(SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList));
}
public List <ShopCollectTime> getShopCollectTime(DataTable dt)
{
List <ShopCollectTime> rval = SqlExtension.ToList <ShopCollectTime>(dt) as List <ShopCollectTime>;
return(rval);
}
public List <ShopCollectDaily> getShopCollectDaily(DataTable dt)
{
List <ShopCollectDaily> rval = SqlExtension.ToList <ShopCollectDaily>(dt) as List <ShopCollectDaily>;
return(rval);
}