public string Hhygl_add_edit_delete_app(string id, string yydh, string qymc, string hykh, string hyrx, string hykh_bz, string krxm, string krgj, string krmz, string yxzj, string zjhm, string krsr, string krxb, string krdh, string krsj, string krEmail, string krdz, string krzy, string krdw, string qzrx, string qzhm, string zjyxq, string tlyxq, string tjrq, string lzka, string bz, string hyjf, string shxg, string xgsj, string parent_hykh, string hymm, string xsy, string czy, string add_edit_delete, string xxzs) { string s = common_file.common_app.get_failure; Hhygl.Hhygl_add_edit Hhygl_add_edit_new = new Hhygl.Hhygl_add_edit(); s = Hhygl_add_edit_new.Hhygl_add_edit_delete_app(id, yydh, qymc, hykh, hyrx, hykh_bz, krxm, krgj, krmz, yxzj, zjhm, krsr, krxb, krdh, krsj, krEmail, krdz, krzy, krdw, qzrx, qzhm, zjyxq, tlyxq, tjrq, lzka, bz, hyjf, shxg, xgsj, parent_hykh, hymm, xsy, czy, add_edit_delete, xxzs); return(s); }
public static string hymm = md5("123456", 32);//会员密码 public static void Form_hygl_add_edit(string id, string ad_edit, Fmain MdiFmain) { if (Hhygl_add_edit_new == null || Hhygl_add_edit_new.IsDisposed) { Hhygl_add_edit_new = new Hotel_app.Hhygl.Hhygl_add_edit(); Hhygl_add_edit_new.MdiParent = MdiFmain; Hhygl_add_edit_new.Show(); } Hhygl_add_edit_new.Activate(); Hhygl_add_edit_new.Hhygl_1(id, ad_edit); }
/// <summary> /// 结帐成功后更新积分 /// </summary> /// <param name="hykh"></param> /// <param name="lsbh"></param> /// <param name="sk_tt"></param> /// <param name="Score"></param> private void IncHYScore(string jzbh, string lsbh, string sk_tt, string hhykh_bz, string yydh, string qymc, string phoneNo, string czsj) { if (sk_tt == "sk" && hhykh_bz.Trim() != "") { Hhygl.Hhygl_verifyCode Hhygl_verifyCode_new = new Hhygl.Hhygl_verifyCode(); string hykh = ""; //会员唯一识别号 string hyrx = ""; //银卡 string krxm = ""; string parent_hykh = ""; decimal jbxs_temp = 1; decimal sjjfs = 0; //升级所需的积分数 decimal bcxfs = 0; //本次产生的积分数 decimal jfxs = 0; //积分系统 string lsbh_df = common_file.common_ddbh.ddbh("df", "lsbhdfdate", "lsbhdfcounter", 6); //读出会员类型 DataSet ds777 = B_common.GetList(" select * from Hhygl ", " id>=0 and hykh_bz='" + hhykh_bz + "'"); if (ds777 != null && ds777.Tables[0].Rows.Count > 0) { if (ds777.Tables[0].Rows[0]["hyrx"].ToString().Equals(common_file_server.common_app.hyrx_yk))//是银卡类型 { //统计其积分 hyrx = ds777.Tables[0].Rows[0]["hyrx"].ToString(); hykh = ds777.Tables[0].Rows[0]["hykh"].ToString(); krxm = ds777.Tables[0].Rows[0]["krxm"].ToString(); parent_hykh = ds777.Tables[0].Rows[0]["parent_hykh"].ToString(); } if (ds777.Tables[0].Rows[0]["hyrx"].ToString().Equals(common_file_server.common_app.hyrx_jk)) { hyrx = ds777.Tables[0].Rows[0]["hyrx"].ToString(); hykh = ds777.Tables[0].Rows[0]["hykh"].ToString(); krxm = ds777.Tables[0].Rows[0]["krxm"].ToString(); parent_hykh = ds777.Tables[0].Rows[0]["parent_hykh"].ToString(); } } DataSet ds_1000 = B_common.GetList(" select * from Hhyjf_bl ", " hyrx='" + hyrx + "'"); if (ds_1000 != null && ds_1000.Tables[0].Rows.Count > 0) { jfxs = decimal.Parse(ds_1000.Tables[0].Rows[0]["jfbl"].ToString()); } else { jfxs = 1; } SqlParameter[] parms1 = new SqlParameter[4]; parms1[0] = new SqlParameter("@jzbh", SqlDbType.VarChar, 300); parms1[1] = new SqlParameter("@xfdr", SqlDbType.VarChar, 300); parms1[2] = new SqlParameter("@lsbh", SqlDbType.VarChar, 300); parms1[3] = new SqlParameter("@TotalFF", SqlDbType.Decimal); parms1[0].Value = jzbh; parms1[1].Value = common_zw.dr_ff; parms1[2].Value = lsbh; parms1[3].Direction = ParameterDirection.Output; DbHelperSQL.RunProcedure("GetHyFfByJzbh", parms1); bcxfs = decimal.Parse(parms1[3].Value.ToString()) * common_file_server.common_app.hyrx_yk_xs; DataSet ds888 = B_common.GetList(" select * from Hhyjb ", " id>=0 and hyrx='" + common_file_server.common_app.hyrx_jk + "'"); if (ds888 != null && ds888.Tables[0].Rows.Count > 0) { //统计其积分 sjjfs = decimal.Parse(ds888.Tables[0].Rows[0]["dfjf"].ToString()); jbxs_temp = decimal.Parse(ds888.Tables[0].Rows[0]["jbxs"].ToString()); } SqlParameter[] parms = new SqlParameter[6]; parms[0] = new SqlParameter("@hykh", SqlDbType.VarChar, 300); parms[1] = new SqlParameter("@sjjfs", SqlDbType.Decimal); parms[2] = new SqlParameter("@sjjfxe", SqlDbType.Decimal); parms[3] = new SqlParameter("@hyrx", SqlDbType.VarChar, 100); parms[4] = new SqlParameter("@JifenTotalYe", SqlDbType.Decimal); parms[5] = new SqlParameter("@shsj", SqlDbType.Bit, 2); parms[0].Value = hykh; parms[1].Value = sjjfs; parms[2].Value = decimal.Parse(common_file_server.common_app.hyykTojkjfsx); parms[3].Value = common_file_server.common_app.hyrx_jk; parms[4].Direction = ParameterDirection.Output; parms[5].Direction = ParameterDirection.Output; DbHelperSQL.RunProcedure("GetHyJifenByHykh", parms); decimal JifenTotalYe = decimal.Parse(parms[4].Value.ToString()); //如果启用会员短信提醒,则发送短信 if (hhygl_shqr.hygl_shqr_add(yydh)) { Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, JifenTotalYe.ToString(), yydh, qymc, common_hyAction.hy_Action_hytf, "", "", "", "", hhykh_bz, (bcxfs * jfxs).ToString(), common_app.xxzs); } decimal sjjfs_temp = decimal.Parse(ConfigurationManager.AppSettings["hyykToJkjf"].ToString()); //升级所需要的积分数 if ((JifenTotalYe >= sjjfs_temp) && hyrx.Equals(common_file_server.common_app.hyrx_yk)) { //进行升级,减去相应积分(调用以前的升级方法) Hhygl.Hhyjf_df Hhyjf_df_new = new Hhygl.Hhyjf_df(); Hhyjf_df_new.Hhyjfdf_add_edit("", yydh, qymc, hykh, hhykh_bz, krxm, sjjfs.ToString(), common_file_server.common_app.hyykTojk, "1", lsbh_df, parent_hykh, common_app.get_add, common_app.xxzs); Hhygl.Hhygl_add_edit Hhygl_add_edit_new = new Hhygl.Hhygl_add_edit(); B_common.ExecuteSql(" update Hhygl set shxg=1, scsj=getdate(),xgsj=getdate(),hyrx='" + common_file_server.common_app.hyrx_jk + "' where hykh='" + hykh + "'"); //如果启用会员短信提醒,则发送升级提醒 if (hhygl_shqr.hygl_shqr_add(yydh)) { Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, (JifenTotalYe - sjjfs_temp).ToString(), yydh, qymc, common_file_server.common_hyAction.hy_Action_promoteType, DateTime.Now.ToString(), "", "", "", hhykh_bz, "", common_app.xxzs); } } } }