//门店下载网上预定数据后，修改订单状态
public string yddj_ydownloadDataStatus(DataSet DS_yddj_downloadData)
{
string ss = common_file.common_app.get_failure;
BLL.Web_skyd B_Web_skyd = new BLL.Web_skyd();
Model.Web_skyd M_Web_skyd = new Model.Web_skyd();
foreach (DataRow dr in DS_yddj_downloadData.Tables[0].Rows)
{
string id = dr[0].ToString();
M_Web_skyd.id = Convert.ToInt32(id);
int result = 0;
//执行存储过程修改状态
SqlParameter[] pa = { new SqlParameter("@id", SqlDbType.VarChar) };
pa[0].Value = dr[0].ToString();
result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "ydownloadDataStatus", pa);
//成功继续
if (result > 0)
{
ss = common_file.common_app.get_suc;
continue;
}
//否则中断
else
{
ss = common_file.common_app.get_failure;
break;
}
}
return(ss);
}
//供特定门店下载预定中心的信息
public DataSet yddj_download_DS(string qymc, out int rows, out bool status)
{
DataSet DS_skyd = new DataSet();
rows = 0;
status = false;
BLL.Web_skyd B_Web_skyd = new BLL.Web_skyd();
DS_skyd = B_Web_skyd.GetList("qymc='" + qymc + "' and sfqr='1' and shsc='0'");
if (DS_skyd != null)
{
rows = DS_skyd.Tables[0].Rows.Count;
status = true;
}
return(DS_skyd);
}
