//门店下载网上预定确定后转入住明细添加到该表 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); }