public DataTable getShopCollectTime()
{
string strSql = "SELECT * FROM ShopCollectTime";
DataTable dt = SqlDbmanager.queryBySql(SqlExtension.GetSelectSqlCmdByParams(strSql));
return(dt);
}
public DataTable GetShopCollectDt(ShopCollectDailyFilter shopCollectDailyFilter)
{
SqlCommand cmd = new SqlCommand();
string strSql = @"SELECT
SCD03 AS '日期',
SCD04 AS '店取短名',
SCD05 AS '郵遞區號',
SCD06 AS '地址1',
SCD07 AS '地址2',
SCD08 AS '店家名稱',
SCD09 AS '包裹放置天數',
SCD10 AS '店取類型',
SCD13 AS '國家'
FROM ShopCollectDaily
WHERE SCD12=1 AND SCD03 BETWEEN @ST AND @ET AND SCD13=@CODE ";
if (!string.IsNullOrEmpty(shopCollectDailyFilter.ShortName))
{
strSql += " AND SCD04=@SCD04";
cmd.Parameters.Add(SafeSQL.CreateInputParam("SCD04", SqlDbType.VarChar, shopCollectDailyFilter.ShortName));
}
if (!string.IsNullOrEmpty(shopCollectDailyFilter.PostCode))
{
strSql += " AND SCD05=@SCD05";
cmd.Parameters.Add(SafeSQL.CreateInputParam("SCD05", SqlDbType.VarChar, shopCollectDailyFilter.PostCode));
}
cmd.CommandText = strSql;
cmd.Parameters.Add(SafeSQL.CreateInputParam("ST", SqlDbType.Date, shopCollectDailyFilter.STime.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(SafeSQL.CreateInputParam("ET", SqlDbType.Date, shopCollectDailyFilter.ETime.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(SafeSQL.CreateInputParam("CODE", SqlDbType.VarChar, shopCollectDailyFilter.Country));
return(SqlDbmanager.queryBySql(cmd, System.Web.Configuration.WebConfigurationManager.ConnectionStrings["NormalConn"].ConnectionString));
}
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));
}
