/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hotel_app.Model.hhyyz_dx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update hhyyz_dx set "); strSql.Append("yydh=@yydh,"); strSql.Append("qymc=@qymc,"); strSql.Append("hy_action_flage=@hy_action_flage,"); strSql.Append("msm_content=@msm_content,"); strSql.Append("enable=@enable,"); strSql.Append("dxycsj=@dxycsj,"); strSql.Append("msm_content_2=@msm_content_2,"); strSql.Append("msm_content_3=@msm_content_3,"); strSql.Append("msm_content_4=@msm_content_4,"); strSql.Append("msm_content_5=@msm_content_5"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@hy_action_flage", SqlDbType.VarChar, 50), new SqlParameter("@msm_content", SqlDbType.VarChar, 5000), new SqlParameter("@enable", SqlDbType.Bit, 1), new SqlParameter("@dxycsj", SqlDbType.Int, 4), new SqlParameter("@msm_content_2", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_3", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_4", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_5", SqlDbType.VarChar, 1000), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.yydh; parameters[1].Value = model.qymc; parameters[2].Value = model.hy_action_flage; parameters[3].Value = model.msm_content; parameters[4].Value = model.enable; parameters[5].Value = model.dxycsj; parameters[6].Value = model.msm_content_2; parameters[7].Value = model.msm_content_3; parameters[8].Value = model.msm_content_4; parameters[9].Value = model.msm_content_5; parameters[10].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hotel_app.Model.hhyyz_dx model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into hhyyz_dx("); strSql.Append("yydh,qymc,hy_action_flage,msm_content,enable,dxycsj,msm_content_2,msm_content_3,msm_content_4,msm_content_5)"); strSql.Append(" values ("); strSql.Append("@yydh,@qymc,@hy_action_flage,@msm_content,@enable,@dxycsj,@msm_content_2,@msm_content_3,@msm_content_4,@msm_content_5)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@hy_action_flage", SqlDbType.VarChar, 50), new SqlParameter("@msm_content", SqlDbType.VarChar, 5000), new SqlParameter("@enable", SqlDbType.Bit, 1), new SqlParameter("@dxycsj", SqlDbType.Int, 4), new SqlParameter("@msm_content_2", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_3", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_4", SqlDbType.VarChar, 1000), new SqlParameter("@msm_content_5", SqlDbType.VarChar, 1000) }; parameters[0].Value = model.yydh; parameters[1].Value = model.qymc; parameters[2].Value = model.hy_action_flage; parameters[3].Value = model.msm_content; parameters[4].Value = model.enable; parameters[5].Value = model.dxycsj; parameters[6].Value = model.msm_content_2; parameters[7].Value = model.msm_content_3; parameters[8].Value = model.msm_content_4; parameters[9].Value = model.msm_content_5; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hotel_app.Model.hhyyz_dx GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,yydh,qymc,hy_action_flage,msm_content,enable,dxycsj,msm_content_2,msm_content_3,msm_content_4,msm_content_5 from hhyyz_dx "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Hotel_app.Model.hhyyz_dx model = new Hotel_app.Model.hhyyz_dx(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["yydh"] != null && ds.Tables[0].Rows[0]["yydh"].ToString() != "") { model.yydh = ds.Tables[0].Rows[0]["yydh"].ToString(); } if (ds.Tables[0].Rows[0]["qymc"] != null && ds.Tables[0].Rows[0]["qymc"].ToString() != "") { model.qymc = ds.Tables[0].Rows[0]["qymc"].ToString(); } if (ds.Tables[0].Rows[0]["hy_action_flage"] != null && ds.Tables[0].Rows[0]["hy_action_flage"].ToString() != "") { model.hy_action_flage = ds.Tables[0].Rows[0]["hy_action_flage"].ToString(); } if (ds.Tables[0].Rows[0]["msm_content"] != null && ds.Tables[0].Rows[0]["msm_content"].ToString() != "") { model.msm_content = ds.Tables[0].Rows[0]["msm_content"].ToString(); } if (ds.Tables[0].Rows[0]["enable"] != null && ds.Tables[0].Rows[0]["enable"].ToString() != "") { if ((ds.Tables[0].Rows[0]["enable"].ToString() == "1") || (ds.Tables[0].Rows[0]["enable"].ToString().ToLower() == "true")) { model.enable = true; } else { model.enable = false; } } if (ds.Tables[0].Rows[0]["dxycsj"] != null && ds.Tables[0].Rows[0]["dxycsj"].ToString() != "") { model.dxycsj = int.Parse(ds.Tables[0].Rows[0]["dxycsj"].ToString()); } if (ds.Tables[0].Rows[0]["msm_content_2"] != null && ds.Tables[0].Rows[0]["msm_content_2"].ToString() != "") { model.msm_content_2 = ds.Tables[0].Rows[0]["msm_content_2"].ToString(); } if (ds.Tables[0].Rows[0]["msm_content_3"] != null && ds.Tables[0].Rows[0]["msm_content_3"].ToString() != "") { model.msm_content_3 = ds.Tables[0].Rows[0]["msm_content_3"].ToString(); } if (ds.Tables[0].Rows[0]["msm_content_4"] != null && ds.Tables[0].Rows[0]["msm_content_4"].ToString() != "") { model.msm_content_4 = ds.Tables[0].Rows[0]["msm_content_4"].ToString(); } if (ds.Tables[0].Rows[0]["msm_content_5"] != null && ds.Tables[0].Rows[0]["msm_content_5"].ToString() != "") { model.msm_content_5 = ds.Tables[0].Rows[0]["msm_content_5"].ToString(); } return(model); } else { return(null); } }
//发送短信 //当预订和登记时,ddsj和lksj才有效,其它时留空就行 //hykh,xf只有在退房时才有用到 //fx房型只有在删除时才有用 public string Hhygl_SendMsm(string phoneNo, string msm_title, string yydh, string qymc, string hyAction, string timeNow, string ddsj, string lksj, string fx, string hykh, string xf, string xxzs) { string result = common_file.common_app.get_failure; if (String.IsNullOrEmpty(phoneNo) || String.IsNullOrEmpty(hyAction) || String.IsNullOrEmpty(xxzs) || System.Text.RegularExpressions.Regex.IsMatch(phoneNo, @"^[1]+[3,4,5,6,8]+\d{9}")) { return(result); } else { try { Hotel_app.cn.b2m.eucp.sdkhttp.SDKService msm = new Hotel_app.cn.b2m.eucp.sdkhttp.SDKService(); string serialNo = ConfigurationManager.AppSettings["msm_serialNo"].ToString(); string msm_key = ConfigurationManager.AppSettings["msm_key"].ToString(); string[] phoneStr = phoneNo.Split(new char[] { '|' }); string sms_temp_0 = ""; //短消息的内容 string sms_temp_1 = ""; //短消息的内容 string sms_temp_2 = ""; //短消息的内容 string sms_temp_3 = ""; //短消息的内容 string sms_temp_4 = ""; //短消息的内容 int tc_time = 0; //延迟发送时间,以分钟计算 string time_SendMsm = ""; //为空时保持空,表示马上发送 if (!timeNow.ToString().Equals("")) { time_SendMsm = timeNow; } Model.hhyyz_dx M_Hhhyzz_dx = new Hotel_app.Model.hhyyz_dx(); List <Model.hhyyz_dx> list_0 = new List <Hotel_app.Model.hhyyz_dx>(); BLL.hhyyz_dx B_hhyzz_dx = new Hotel_app.BLL.hhyyz_dx(); list_0 = B_hhyzz_dx.GetModelList(" yydh='" + yydh + "' and hy_action_flage='" + hyAction + "'"); string content = "";//最后发送的消息 System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (list_0 != null && list_0.Count > 0) { M_Hhhyzz_dx = list_0[0]; tc_time = M_Hhhyzz_dx.dxycsj; if (!time_SendMsm.Equals("")) { time_SendMsm = (DateTime.Parse(time_SendMsm)).AddMinutes(tc_time).ToString();//发送时间 } sms_temp_0 = M_Hhhyzz_dx.msm_content; sms_temp_1 = M_Hhhyzz_dx.msm_content_2; sms_temp_2 = M_Hhhyzz_dx.msm_content_3; sms_temp_3 = M_Hhhyzz_dx.msm_content_4; sms_temp_4 = M_Hhhyzz_dx.msm_content_5; // sb.Append(M_Hhhyzz_dx.msm_content); if (hyAction == common_file.common_hyAction.hy_Action_djNew) { sb.Append(sms_temp_0); sb.Append("[" + qymc + "]"); //sb.Append(sms_temp_1); //sb.Append(":"); // sb.Append(ddsj + "到" + lksj); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//登记新增 if (hyAction == common_file.common_hyAction.hy_Action_djxg) { sb.Append(sms_temp_0); sb.Append("[" + qymc + "]"); sb.Append(sms_temp_1); //sb.Append("您当前的入住时间为:"); //sb.Append(ddsj + "到" + lksj); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//登记修改 if (hyAction == common_file.common_hyAction.hy_Action_HyNew) { sb.Append(sms_temp_0); sb.Append("卡号" + phoneNo); sb.Append(",密码123456,"); sb.Append(sms_temp_1); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//新增会员 if (hyAction == common_file.common_hyAction.hy_Action_hytf) { sb.Append(sms_temp_0); sb.Append(sms_temp_1); sb.Append(xf + ","); sb.Append(sms_temp_2); sb.Append(msm_title);//总积分存在这里,传值的时候 sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//会员退房 if (hyAction == common_file.common_hyAction.hy_Action_ydNew) { sb.Append(sms_temp_0); sb.Append(","); sb.Append(sms_temp_1); //sb.Append(":"); //sb.Append(ddsj + "到" + lksj); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//预订新增 if (hyAction == common_file.common_hyAction.hy_Action_ydxg) { sb.Append(sms_temp_0); sb.Append(","); sb.Append(msm_title); sb.Append(sms_temp_1); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//预订修改 if (hyAction == common_file.common_hyAction.hy_Action_yddel) { sb.Append(sms_temp_0); sb.Append("(" + qymc + ")"); sb.Append(sms_temp_1); sb.Append("您当前预订单的入住时间为"); sb.Append(ddsj + "-" + lksj); //sb.Append(" fx "); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); }//预订删除 //会员升级 if (hyAction == common_file_server.common_hyAction.hy_Action_promoteType) { sb.Append(sms_temp_0); sb.Append("(" + qymc + ")"); sb.Append("您升级后的积分余额为"); sb.Append(msm_title + "。"); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); } if (hyAction == common_file.common_hyAction.hy_Action_hyqr) { sb.Append(sms_temp_0); sb.Append(sms_temp_1); sb.Append(sms_temp_2); sb.Append(sms_temp_3); sb.Append(sms_temp_4); } } content = sb.ToString(); if (!time_SendMsm.Equals("")) { time_SendMsm = DateTime.Parse(time_SendMsm.ToString()).ToString("yyyyMMddHHmmss"); } if (!content.Equals("")) { object resultCode = msm.sendSMS(serialNo, msm_key, time_SendMsm.ToString(), phoneStr, content, "", "GBK", 5); if (resultCode != null && int.Parse(resultCode.ToString()) <= 0) { result = common_file.common_app.get_suc; } } } catch { //return result; } } return(result); }