//用于网上预定门店确认后,向中心服务器表:Qttyd_ydzxqr 插入数据,并修改本地Qttyd_ydzxqr表的shsc为1 public static string InsertToQttyd_ydzxqr() { string ss = common_app.get_failure; Model.Qyqskyd_ydzxqr M_Qyqskyd_ydzxqr = new Model.Qyqskyd_ydzxqr(); BLL.Qyqskyd_ydzxqr B_Qyqskyd_ydzxqr = new BLL.Qyqskyd_ydzxqr(); DataSet DS_UploadData = B_Qyqskyd_ydzxqr.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_ydzxqr_ad", obj); if (result.ToString() == common_app.get_suc) { Common_Shsc.Updatshsc(DS_UploadData, "Qyqskyd_ydzxqr");//修改本地shsc=1 } } //错误生成之后,写错误日志,执行重启操作 catch (Exception ee) { //开始写日志 errorInfo = ee.Message.ToString(); postion = "向中心服务器表:Qttyd_ydzxqr 插入数据之后的过程"; Common.WriteLog(errorInfo, postion); } } return(ss); }
//门店下载网上预定确定后添加到该表 public string Qyqskyd_ydzxqr_ad(DataSet DS_Qyqskyd_ydzxqr_downloadData) { string ss = common_file.common_app.get_failure; BLL.Qyqskyd_ydzxqr B_Qyqskyd_ydzxqr = new BLL.Qyqskyd_ydzxqr(); Model.Qyqskyd_ydzxqr M_Qyqskyd_ydzxqr = new Model.Qyqskyd_ydzxqr(); foreach (DataRow dr in DS_Qyqskyd_ydzxqr_downloadData.Tables[0].Rows) { SqlParameter[] parameters = { new SqlParameter("@lsbh", SqlDbType.VarChar, 100), new SqlParameter("@qrzt", SqlDbType.VarChar, 50), new SqlParameter("@qrsj", SqlDbType.DateTime), new SqlParameter("@qryy", SqlDbType.VarChar, 200), new SqlParameter("@czy", SqlDbType.VarChar, 50), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@scsj", SqlDbType.DateTime), new SqlParameter("@fjrb", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@yydh", SqlDbType.VarChar, 50) }; parameters[0].Value = dr["lsbh"]; parameters[1].Value = dr["qrzt"]; parameters[2].Value = Convert.ToDateTime(dr["qrsj"]); parameters[3].Value = dr["qryy"]; parameters[4].Value = dr["czy"]; parameters[5].Value = true; parameters[6].Value = Convert.ToDateTime(dr["scsj"]); parameters[7].Value = dr["fjrb"]; parameters[8].Value = dr["qymc"]; parameters[9].Value = dr["yydh"]; int result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Qyqskyd_ydzxqr_ADD", parameters); //成功继续 if (result > 0) { ss = common_file.common_app.get_suc; continue; } //否则中断 else { ss = common_file.common_app.get_failure; break; } } return(ss); }