//门店下载网上预定确定后转入住明细添加到该表
public string Qyqskyd_ydzlzmx_ad(DataSet DS_Qyqskyd_ydzlzmx_downloadData)
{
string ss = common_file.common_app.get_failure;
BLL.Qyqskyd_ydzlzmx B_Qyqskyd_ydzlzmx = new BLL.Qyqskyd_ydzlzmx();
Model.Qyqskyd_ydzlzmx M_Qyqskyd_ydzlzmx = new Model.Qyqskyd_ydzlzmx();
foreach (DataRow dr in DS_Qyqskyd_ydzlzmx_downloadData.Tables[0].Rows)
{
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@fjrb", SqlDbType.VarChar, 50),
new SqlParameter("@fjbh", SqlDbType.VarChar, 50),
new SqlParameter("@sjjg", SqlDbType.Decimal, 9),
new SqlParameter("@ddsj", SqlDbType.DateTime),
new SqlParameter("@lksj", SqlDbType.DateTime),
new SqlParameter("@ddrq", SqlDbType.DateTime),
new SqlParameter("@lkrq", SqlDbType.DateTime),
new SqlParameter("@lzrx", SqlDbType.VarChar, 50),
new SqlParameter("@lzfs", SqlDbType.Decimal, 9),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@scsj", SqlDbType.DateTime)
};
parameters[0].Value = dr["yydh"];
parameters[1].Value = dr["qymc"];
parameters[2].Value = dr["lsbh"];
parameters[3].Value = dr["fjrb"];
parameters[4].Value = dr["fjbh"];
parameters[5].Value = Convert.ToDecimal(dr["sjjg"]);
parameters[6].Value = Convert.ToDateTime(dr["ddsj"]);
parameters[7].Value = Convert.ToDateTime(dr["lksj"]);
parameters[8].Value = Convert.ToDateTime(dr["ddrq"]);
parameters[9].Value = Convert.ToDateTime(dr["lkrq"]);
parameters[10].Value = dr["lzrx"];
parameters[11].Value = Convert.ToDecimal(dr["lzfs"]);
parameters[12].Value = true;
parameters[13].Value = Convert.ToDateTime(dr["scsj"]);
int result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Qyqskyd_ydzlzmx_ADD", parameters);
//成功继续
if (result > 0)
{
ss = common_file.common_app.get_suc;
continue;
}
//否则中断
else
{
ss = common_file.common_app.get_failure;
break;
}
}
return(ss);
}
//用于网上预定门店确认后转入住的明细Qyqskyd_ydzlzmx
public static string InsertToQttyd_ydzlzmx()
{
string ss = common_app.get_failure;
Model.Qyqskyd_ydzlzmx M_Qyqskyd_ydzlzmx = new Model.Qyqskyd_ydzlzmx();
BLL.Qyqskyd_ydzlzmx B_Qyqskyd_ydzlzmx = new BLL.Qyqskyd_ydzlzmx();
DataSet DS_UploadData = B_Qyqskyd_ydzlzmx.GetList(" shsc='0' ");
if (DS_UploadData != null && DS_UploadData.Tables[0].Rows.Count > 0)
{
try
{
//调用webservices(整体成功后才修改本地的状态)
url = common_file.Common.ReadXML("add", "url") + "/Qyddj/Qyddj_app.asmx";
object[] obj = new object[1];
obj[0] = DS_UploadData;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qyqskyd_ydzlzmx_ad", obj);
if (result.ToString() == common_app.get_suc)
{
Common_Shsc.Updatshsc(DS_UploadData, "Qyqskyd_ydzlzmx");//修改本地shsc=1
}
}
//错误生成之后,写错误日志，执行重启操作
catch (Exception ee)
{
//开始写日志
errorInfo = ee.Message.ToString();
postion = "向中心服务器表:Qttyd_ydzxqr 插入数据之后的过程";
Common.WriteLog(errorInfo, postion);
}
}
return(ss);
}
