private void efwSimpleButton4_Click(object sender, EventArgs e)
{
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_TM_TM14_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txtCost_idx.EditValue).ToString();
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Major_Code", MySqlDbType.VarChar));
cmd.Parameters["i_Major_Code"].Value = cmbMajor_Code.EditValue;
cmd.Parameters["i_Major_Code"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Large_Code", MySqlDbType.VarChar));
cmd.Parameters["i_Large_Code"].Value = cmbLarge_Code.EditValue;
cmd.Parameters["i_Large_Code"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Middle_Code", MySqlDbType.VarChar));
cmd.Parameters["i_Middle_Code"].Value = txtMiddle_Code.EditValue;
cmd.Parameters["i_Middle_Code"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Middle_Name", MySqlDbType.VarChar));
cmd.Parameters["i_Middle_Name"].Value = txtMiddle_Name.EditValue;
cmd.Parameters["i_Middle_Name"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Small_Code", MySqlDbType.VarChar));
//cmd.Parameters["i_Small_Code"].Value = cmbSmall_Code.EditValue;
cmd.Parameters["i_Small_Code"].Value = "01";
cmd.Parameters["i_Small_Code"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Sort", MySqlDbType.Int32));
cmd.Parameters["i_Sort"].Value = Convert.ToInt32(txtSort.EditValue).ToString();
cmd.Parameters["i_Sort"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_use_yn", MySqlDbType.VarChar));
cmd.Parameters["i_use_yn"].Value = tbUse_YN.EditValue;
cmd.Parameters["i_use_yn"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Remark", MySqlDbType.VarChar));
cmd.Parameters["i_Remark"].Value = txtCustRemark.EditValue;
cmd.Parameters["i_Remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.Int32));
cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtCost_idx.EditValue = cmd.Parameters["o_idx"].Value.ToString();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
AccCode();
}
}
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DN_DN01_SAVE_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_id", MySqlDbType.Int32));
cmd.Parameters["i_id"].Value = Convert.ToInt32(txtID.EditValue);
cmd.Parameters["i_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_zipcode", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_zipcode"].Value = txtO_Receive_ZipCode.EditValue;
cmd.Parameters["i_o_receive_zipcode"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_address", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_address"].Value = txtO_Receive_Address.EditValue;
cmd.Parameters["i_o_receive_address"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_name", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_name"].Value = txtO_Receive_Name.EditValue;
cmd.Parameters["i_o_receive_name"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_contact", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_contact"].Value = txtO_Receive_Contact.EditValue;
cmd.Parameters["i_o_receive_contact"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_message", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_message"].Value = txtO_Receive_Message.EditValue;
cmd.Parameters["i_o_receive_message"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_zipcode1", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_zipcode1"].Value = txtO_Receive_ZipCode1.EditValue;
cmd.Parameters["i_o_receive_zipcode1"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_address1", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_address1"].Value = txtO_Receive_Address1.EditValue;
cmd.Parameters["i_o_receive_address1"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_name1", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_name1"].Value = txtO_Receive_Name1.EditValue;
cmd.Parameters["i_o_receive_name1"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_contact1", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_contact1"].Value = txtO_Receive_Contact1.EditValue;
cmd.Parameters["i_o_receive_contact1"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_o_receive_message1", MySqlDbType.VarChar));
cmd.Parameters["i_o_receive_message1"].Value = txtO_Receive_Message1.EditValue;
cmd.Parameters["i_o_receive_message1"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
cmd.Parameters["i_remark"].Value = txtRemark.EditValue;
cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Delivery_Num", MySqlDbType.VarChar));
cmd.Parameters["i_Delivery_Num"].Value = txtO_Delivery_Num.EditValue;
cmd.Parameters["i_Delivery_Num"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
}
private void Cancel()
{
if (txtchk_type.EditValue.ToString() == "F")
{
MessageAgent.MessageShow(MessageType.Confirm, "배송완료된 주문 번호입니다.");
return;
}
if (txtchk_type.EditValue.ToString() == "D")
{
MessageAgent.MessageShow(MessageType.Confirm, "배송중인 주문 번호입니다.");
return;
}
if (txtchk_type.EditValue.ToString() == "E")
{
MessageAgent.MessageShow(MessageType.Confirm, "구매완료된 주문 번호입니다.");
return;
}
// if (txtchk_type.EditValue.ToString() == "C")
// {
// MessageAgent.MessageShow(MessageType.Confirm, "취소 처리된 주문 번호입니다.");
// return;
// }
if (txtchk_type.EditValue.ToString() == "B")
{
MessageAgent.MessageShow(MessageType.Confirm, "반품완료된 주문 번호입니다.");
return;
}
if (txtchk_type.EditValue.ToString() == "Z")
{
MessageAgent.MessageShow(MessageType.Confirm, "품절취소된 주문 번호입니다.");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "취소/반품 승인을 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DN_DN01_SAVE_03", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_o_code", MySqlDbType.VarChar));
cmd.Parameters["i_o_code"].Value = txto_mcode.EditValue;
cmd.Parameters["i_o_code"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
}
// MS SQL 머니 차감
//int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_DN_DN01_SAVE_04"
// , this.txtO_Code.EditValue
// );
//if (retVal > 0)-
//{
// MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
//}
//DataSet ds = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_DN_DN01_SAVE_04"
// , this.txtO_Code.EditValue
// );
MessageAgent.MessageShow(MessageType.Informational, "주문 취소 되었습니다.");
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows[0]["ERRC"].ToString() == "ERR")
// {
// MessageAgent.MessageShow(MessageType.Error, ds.Tables[0].Rows[0]["ERRM"].ToString());
// }
// else
// {
// MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
// }
//}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Open1();
}
}
private void EfwSimpleButton4_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.txtU_NAME1.Text))
{
return;
}
if (string.IsNullOrEmpty(this.cbDORAMD_TYPE.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " 프리/로컬 MD 구분을 선택하세요!");
return;
}
if (cbDORAMD_TYPE.EditValue.ToString() == "1")
{
MessageAgent.MessageShow(MessageType.Warning, " 지역구는 로컬MD만 지정 가능합니다");
return;
}
if (cmbSAREA1.EditValue == null)
{
MessageAgent.MessageShow(MessageType.Warning, " 시/도/구군을 선택하세요 ");
return;
}
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP06_DELETE_04", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txtAREAIDX.EditValue);
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_idx", MySqlDbType.Int32));
cmd.Parameters["i_md_idx"].Value = Convert.ToInt32(txtIDX1.EditValue);
cmd.Parameters["i_md_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_sido", MySqlDbType.VarChar));
cmd.Parameters["i_sido"].Value = cmbTAREA1.EditValue;
cmd.Parameters["i_sido"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gugun", MySqlDbType.VarChar));
cmd.Parameters["i_gugun"].Value = cmbSAREA1.EditValue;
cmd.Parameters["i_gugun"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_return", MySqlDbType.VarChar));
cmd.Parameters["o_return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["o_Return"].Value.ToString() != "")
{
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
finally
{
EfwSimpleButton1_Click(null, null);
}
Open3();
}
/// <summary>
/// 点击事件
/// </summary>
/// <param name="requestMessage"></param>
/// <returns></returns>
public override IResponseMessageBase OnEvent_ClickRequest(RequestMessageEvent_Click requestMessage)
{
IResponseMessageBase reponseMessage = null;
//菜单点击，需要跟创建菜单时的Key匹配
switch (requestMessage.EventKey)
{
case "OneClick":
{
//这个过程实际已经在OnTextOrEventRequest中完成，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了底部按钮。\r\n为了测试微信软件换行bug的应对措施，这里做了一个——\r\n换行";
}
break;
case "SubClickRoot_Text":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了子菜单按钮。";
}
break;
case "SubClickRoot_News":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "您点击了子菜单图文按钮",
Description = "您点击了子菜单图文按钮，这是一条图文信息。这个区域是Description内容\r\n可以使用\\r\\n进行换行。",
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg",
Url = "http://sdk.weixin.senparc.com"
});
//随机添加一条图文，或只输出一条图文信息
if (DateTime.Now.Second % 2 == 0)
{
strongResponseMessage.Articles.Add(new Article()
{
Title = "这是随机产生的第二条图文信息，用于测试多条图文的样式",
Description = "这是随机产生的第二条图文信息，用于测试多条图文的样式",
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg",
Url = "http://sdk.weixin.senparc.com"
});
}
}
break;
case "SubClickRoot_Music":
{
//上传缩略图
var accessToken = Senparc.Weixin.MP.Containers.AccessTokenContainer.TryGetAccessToken(appId, appSecret);
var uploadResult = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.thumb,
Server.GetMapPath("~/Images/Logo.thumb.jpg"));
//PS：缩略图官方没有特别提示文件大小限制，实际测试哪怕114K也会返回文件过大的错误，因此尽量控制在小一点（当前图片39K）
//设置音乐信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageMusic>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Music.Title = "天籁之音";
strongResponseMessage.Music.Description = "真的是天籁之音";
strongResponseMessage.Music.MusicUrl = "https://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.HQMusicUrl = "https://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.ThumbMediaId = uploadResult.thumb_media_id;
}
break;
case "SubClickRoot_Image":
{
//上传图片
var accessToken = Senparc.Weixin.MP.Containers.AccessTokenContainer.TryGetAccessToken(appId, appSecret);
var uploadResult = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.image,
Server.GetMapPath("~/Images/Logo.jpg"));
//设置图片信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageImage>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Image.MediaId = uploadResult.media_id;
}
break;
case "SubClickRoot_Agent": //代理消息
{
//获取返回的XML
DateTime dt1 = DateTime.Now;
reponseMessage = MessageAgent.RequestResponseMessage(this, agentUrl, agentToken, RequestDocument.ToString());
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
DateTime dt2 = DateTime.Now;
if (reponseMessage is ResponseMessageNews)
{
(reponseMessage as ResponseMessageNews)
.Articles[0]
.Description += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
}
break;
case "Member": //托管代理会员信息
{
//原始方法为：MessageAgent.RequestXml(this,agentUrl, agentToken, RequestDocument.ToString());//获取返回的XML
reponseMessage = this.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
}
break;
case "OAuth": //OAuth授权测试
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试",
Description = "选择下面两种不同的方式进行测试，区别在于授权成功后，最后停留的页面。",
//Url = "http://sdk.weixin.senparc.com/oauth2",
//PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试（不带returnUrl），测试环境可使用",
Description = "OAuth2.0测试（不带returnUrl）",
Url = "http://sdk.weixin.senparc.com/oauth2",
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
var returnUrl = "/OAuth2/TestReturnUrl";
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试（带returnUrl），生产环境强烈推荐使用",
Description = "OAuth2.0测试（带returnUrl）",
Url = "http://sdk.weixin.senparc.com/oauth2?returnUrl=" + returnUrl.UrlEncode(),
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
reponseMessage = strongResponseMessage;
}
break;
case "Description":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = GetWelcomeInfo();
reponseMessage = strongResponseMessage;
}
break;
case "SubClickRoot_PicPhotoOrAlbum":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信拍照】按钮。系统将会弹出拍照或者相册发图。";
}
break;
case "SubClickRoot_ScancodePush":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信扫码】按钮。";
}
break;
case "ConditionalMenu_Male":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：男。";
}
break;
case "ConditionalMenu_Femle":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：女。";
}
break;
case "GetNewMediaId": //获取新的MediaId
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
try
{
var result = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadForeverMedia(appId, Server.GetMapPath("~/Images/logo.jpg"));
strongResponseMessage.Content = result.media_id;
}
catch (Exception e)
{
strongResponseMessage.Content = "发生错误：" + e.Message;
Senparc.Weixin.WeixinTrace.SendCustomLog("调用UploadForeverMedia()接口发生异常", e.Message);
}
}
break;
default:
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = "您点击了按钮，EventKey：" + requestMessage.EventKey;
reponseMessage = strongResponseMessage;
}
break;
}
return(reponseMessage);
}
private void efwSimpleButton6_Click(object sender, EventArgs e)
{
{
if (string.IsNullOrEmpty(this.txtUserName.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " ID를 입력하세요");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
using (MySqlConnection con = new MySqlConnection(ConstantLib.Dev_Conn))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP17_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_id", MySqlDbType.Int32));
cmd.Parameters["i_id"].Value = Convert.ToInt32(txtID.EditValue);
cmd.Parameters["i_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_username", MySqlDbType.VarChar));
cmd.Parameters["i_username"].Value = txtUserName.EditValue;
cmd.Parameters["i_username"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_u_name", MySqlDbType.VarChar));
cmd.Parameters["i_u_name"].Value = txtU_Name.EditValue;
cmd.Parameters["i_u_name"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_u_cell", MySqlDbType.VarChar));
cmd.Parameters["i_u_cell"].Value = txtU_Cell.EditValue;
cmd.Parameters["i_u_cell"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_u_email", MySqlDbType.VarChar));
cmd.Parameters["i_u_email"].Value = txtU_Email.EditValue;
cmd.Parameters["i_u_email"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_region", MySqlDbType.VarChar));
cmd.Parameters["i_region"].Value = cmbRegion.EditValue;
cmd.Parameters["i_region"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_region_area", MySqlDbType.VarChar));
cmd.Parameters["i_region_area"].Value = cmbRegion_Area.EditValue;
cmd.Parameters["i_region_area"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_enabled", MySqlDbType.VarChar));
cmd.Parameters["i_enabled"].Value = chkEnabled.EditValue;
cmd.Parameters["i_enabled"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_u_id", MySqlDbType.VarChar));
cmd.Parameters["i_u_id"].Value = txtU_ID.EditValue;
cmd.Parameters["i_u_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Search();
}
}
}
public override IResponseMessageBase OnEvent_ClickRequest(RequestMessageEvent_Click requestMessage)
{
IResponseMessageBase reponseMessage = null;
//菜单点击，需要跟创建菜单时的Key匹配
switch (requestMessage.EventKey)
{
case "OneClick":
{
//这个过程实际已经在OnTextOrEventRequest中完成，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了底部按钮。\r\n为了测试微信软件换行bug的应对措施，这里做了一个——\r\n换行";
}
break;
case "telphone":
{
//这个过程实际已经在OnTextOrEventRequest中完成，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "02168409571";
}
break;
case "SubClickRoot_Text":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了子菜单按钮。";
}
break;
case "SubClickRoot_News":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "您点击了子菜单图文按钮222",
Description = "您点击了子菜单图文按钮，这是一条图文信息33。",
PicUrl = "http://weixin.senparc.com/Images/qrcode.jpg",
Url = "http://weixin.senparc.com"
});
}
break;
//case "SubClickRoot_Music":
// {
// //上传缩略图
// var accessToken = CommonAPIs.AccessTokenContainer.TryGetToken(appId, appSecret);
// var uploadResult = AdvancedAPIs.Media.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.thumb,
// Server.GetMapPath("~/Images/Logo.jpg"));
// //设置音乐信息
// var strongResponseMessage = CreateResponseMessage<ResponseMessageMusic>();
// reponseMessage = strongResponseMessage;
// strongResponseMessage.Music.Title = "天籁之音";
// strongResponseMessage.Music.Description = "真的是天籁之音";
// strongResponseMessage.Music.MusicUrl = "http://weixin.senparc.com/Content/music1.mp3";
// strongResponseMessage.Music.HQMusicUrl = "http://weixin.senparc.com/Content/music1.mp3";
// strongResponseMessage.Music.ThumbMediaId = uploadResult.thumb_media_id;
// }
// break;
//case "SubClickRoot_Image":
// {
// //上传图片
// var accessToken = CommonAPIs.AccessTokenContainer.TryGetToken(appId, appSecret);
// var uploadResult = AdvancedAPIs.Media.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.image,
// Server.GetMapPath("~/Images/Logo.jpg"));
// //设置图片信息
// var strongResponseMessage = CreateResponseMessage<ResponseMessageImage>();
// reponseMessage = strongResponseMessage;
// strongResponseMessage.Image.MediaId = uploadResult.media_id;
// }
// break;
case "SubClickRoot_Agent": //代理消息
{
//获取返回的XML
DateTime dt1 = DateTime.Now;
reponseMessage = MessageAgent.RequestResponseMessage(this, agentUrl, agentToken, RequestDocument.ToString());
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
DateTime dt2 = DateTime.Now;
if (reponseMessage is ResponseMessageNews)
{
(reponseMessage as ResponseMessageNews)
.Articles[0]
.Description += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
}
break;
case "Member": //托管代理会员信息
{
//原始方法为：MessageAgent.RequestXml(this,agentUrl, agentToken, RequestDocument.ToString());//获取返回的XML
reponseMessage = this.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
}
break;
case "Description":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "您点击了子菜单图文按钮111",
Description = "您点击了子菜单图文按钮，这是一条图文信息。",
PicUrl = "http://weixin.senparc.com/Images/qrcode.jpg",
Url = "http://weixin.senparc.com"
});
}
break;
case "SubClickRoot_PicPhotoOrAlbum":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信拍照】按钮。系统将会弹出拍照或者相册发图。";
}
break;
case "SubClickRoot_ScancodePush":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信扫码】按钮。";
}
break;
default:
{
reponseMessage = this.Robet(requestMessage.EventKey);
}
break;
}
return(reponseMessage);
}
/// <summary>
/// 处理文字请求
/// </summary>
/// <returns></returns>
public override IResponseMessageBase OnTextRequest(RequestMessageText requestMessage)
{
//TODO:这里的逻辑可以交给Service处理具体信息，参考OnLocationRequest方法或/Service/LocationSercice.cs
#region 书中例子
//if (requestMessage.Content == "你好")
//{
// var responseMessage = base.CreateResponseMessage<ResponseMessageNews>();
// var title = "Title";
// var description = "Description";
// var picUrl = "PicUrl";
// var url = "Url";
// responseMessage.Articles.Add(new Article()
// {
// Title = title,
// Description = description,
// PicUrl = picUrl,
// Url = url
// });
// return responseMessage;
//}
//else if (requestMessage.Content == "Senparc")
//{
// //相似处理逻辑
//}
//else
//{
// //...
//}
#endregion
//方法一（v0.1），此方法调用太过繁琐，已过时（但仍是所有方法的核心基础），建议使用方法二到四
//var responseMessage =
// ResponseMessageBase.CreateFromRequestMessage(RequestMessage, ResponseMsgType.Text) as
// ResponseMessageText;
//方法二（v0.4）
//var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageText>(RequestMessage);
//方法三（v0.4），扩展方法，需要using Senparc.Weixin.MP.Helpers;
//var responseMessage = RequestMessage.CreateResponseMessage<ResponseMessageText>();
//方法四（v0.6+），仅适合在HandlerMessage内部使用，本质上是对方法三的封装
//注意：下面泛型ResponseMessageText即返回给客户端的类型，可以根据自己的需要填写ResponseMessageNews等不同类型。
var responseMessage = base.CreateResponseMessage <ResponseMessageText>();
if (requestMessage.Content == null)
{
}
else if (requestMessage.Content == "约束")
{
responseMessage.Content =
@"您正在进行微信内置浏览器约束判断测试。您可以：
<a href=""http://sdk.weixin.senparc.com/FilterTest/"">点击这里</a>进行客户端约束测试（地址：http://sdk.weixin.senparc.com/FilterTest/），如果在微信外打开将直接返回文字。
或：
<a href=""http://sdk.weixin.senparc.com/FilterTest/Redirect"">点击这里</a>进行客户端约束测试（地址：http://sdk.weixin.senparc.com/FilterTest/Redirect），如果在微信外打开将重定向一次URL。";
}
else if (requestMessage.Content == "托管" || requestMessage.Content == "代理")
{
//开始用代理托管，把请求转到其他服务器上去，然后拿回结果
//甚至也可以将所有请求在DefaultResponseMessage()中托管到外部。
DateTime dt1 = DateTime.Now; //计时开始
var agentXml = RequestDocument.ToString();
#region 暂时转发到SDK线上Demo
agentUrl = "http://sdk.weixin.senparc.com/weixin";
agentToken = WebConfigurationManager.AppSettings["WeixinToken"];//Token
//修改内容，防止死循环
var agentDoc = XDocument.Parse(agentXml);
agentDoc.Root.Element("Content").SetValue("代理转发文字：" + requestMessage.Content);
agentDoc.Root.Element("CreateTime").SetValue(DateTimeHelper.GetWeixinDateTime(DateTime.Now)); //修改时间，防止去重
agentDoc.Root.Element("MsgId").SetValue("123"); //防止去重
agentXml = agentDoc.ToString();
#endregion
var responseXml = MessageAgent.RequestXml(this, agentUrl, agentToken, agentXml);
//获取返回的XML
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
/* 如果有WeiweihiKey，可以直接使用下面的这个MessageAgent.RequestWeiweihiXml()方法。
* WeiweihiKey专门用于对接www.weiweihi.com平台，获取方式见：https://www.weiweihi.com/ApiDocuments/Item/25#51
*/
//var responseXml = MessageAgent.RequestWeiweihiXml(weiweihiKey, RequestDocument.ToString());//获取Weiweihi返回的XML
DateTime dt2 = DateTime.Now; //计时结束
//转成实体。
/* 如果要写成一行，可以直接用：
* responseMessage = MessageAgent.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
* 或
*
*/
var msg = string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
var agentResponseMessage = responseXml.CreateResponseMessage();
if (agentResponseMessage is ResponseMessageText)
{
(agentResponseMessage as ResponseMessageText).Content += msg;
}
else if (agentResponseMessage is ResponseMessageNews)
{
(agentResponseMessage as ResponseMessageNews).Articles[0].Description += msg;
}
return(agentResponseMessage);//可能出现多种类型，直接在这里返回
}
else if (requestMessage.Content == "测试" || requestMessage.Content == "退出")
{
/*
* 这是一个特殊的过程，此请求通常来自于微微嗨（http://www.weiweihi.com）的“盛派网络小助手”应用请求（https://www.weiweihi.com/User/App/Detail/1），
* 用于演示微微嗨应用商店的处理过程，由于微微嗨的应用内部可以单独设置对话过期时间，所以这里通常不需要考虑对话状态，只要做最简单的响应。
*/
if (requestMessage.Content == "测试")
{
//进入APP测试
responseMessage.Content = "您已经进入【盛派网络小助手】的测试程序，请发送任意信息进行测试。发送文字【退出】退出测试对话。10分钟内无任何交互将自动退出应用对话状态。";
}
else
{
//退出APP测试
responseMessage.Content = "您已经退出【盛派网络小助手】的测试程序。";
}
}
else if (requestMessage.Content == "AsyncTest")
{
//异步并发测试（提供给单元测试使用）
DateTime begin = DateTime.Now;
int t1, t2, t3;
System.Threading.ThreadPool.GetAvailableThreads(out t1, out t3);
System.Threading.ThreadPool.GetMaxThreads(out t2, out t3);
System.Threading.Thread.Sleep(TimeSpan.FromSeconds(4));
DateTime end = DateTime.Now;
var thread = System.Threading.Thread.CurrentThread;
responseMessage.Content = string.Format("TId:{0}\tApp:{1}\tBegin:{2:mm:ss,ffff}\tEnd:{3:mm:ss,ffff}\tTPool：{4}",
thread.ManagedThreadId,
HttpContext.Current != null ? HttpContext.Current.ApplicationInstance.GetHashCode() : -1,
begin,
end,
t2 - t1
);
}
else if (requestMessage.Content.ToUpper() == "OPEN")
{
var openResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageNews>();
openResponseMessage.Articles.Add(new Article()
{
Title = "开放平台微信授权测试",
Description = @"点击进入Open授权页面。
授权之后，您的微信所收到的消息将转发到第三方（盛派网络小助手）的服务器上，并获得对应的回复。
测试完成后，您可以登陆公众号后台取消授权。",
Url = "http://sdk.weixin.senparc.com/OpenOAuth/JumpToMpOAuth"
});
return(openResponseMessage);
}
else if (requestMessage.Content == "错误")
{
var errorResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
//因为没有设置errorResponseMessage.Content，所以这小消息将无法正确返回。
return(errorResponseMessage);
}
else if (requestMessage.Content == "容错")
{
Thread.Sleep(1500);//故意延时1.5秒，让微信多次发送消息过来，观察返回结果
var faultTolerantResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
faultTolerantResponseMessage.Content = string.Format("测试容错，MsgId：{0}，Ticks：{1}", requestMessage.MsgId,
DateTime.Now.Ticks);
return(faultTolerantResponseMessage);
}
else if (requestMessage.Content.ToUpper() == "TM")//异步模板消息设置
{
var openId = requestMessage.FromUserName;
var checkCode = Guid.NewGuid().ToString("n").Substring(0, 3);//为了防止openId泄露造成骚扰，这里启用验证码
TemplateMessageCollection[checkCode] = openId;
responseMessage.Content = string.Format(@"新的验证码为：{0}，请在网页上输入。网址：http://sdk.weixin.senparc.com/AsyncMethods", checkCode);
}
else if (requestMessage.Content.ToUpper() == "OPENID") //返回OpenId及用户信息
{
var openId = requestMessage.FromUserName; //获取OpenId
var userInfo = AdvancedAPIs.UserApi.Info(appId, openId, Language.zh_CN);
responseMessage.Content = string.Format(
"您的OpenID为：{0}\r\n昵称：{1}\r\n性别：{2}\r\n地区（国家/省/市）：{3}/{4}/{5}\r\n关注时间：{6}\r\n关注状态：{7}",
requestMessage.FromUserName, userInfo.nickname, (Sex)userInfo.sex, userInfo.country, userInfo.province, userInfo.city, DateTimeHelper.GetDateTimeFromXml(userInfo.subscribe_time), userInfo.subscribe);
}
else if (requestMessage.Content.ToUpper() == "EX")
{
var ex = new WeixinException("openid:" + requestMessage.FromUserName + ":这是一条测试异常信息");//回调过程在global的ConfigWeixinTraceLog()方法中
responseMessage.Content = "请等待异步模板消息发送到此界面上（自动延时数秒）。\r\n当前时间：" + DateTime.Now.ToString();
}
else if (requestMessage.Content.ToUpper() == "MUTE")
{
return(new SuccessResponseMessage());
base.TextResponseMessage = "success";
responseMessage = null;
}
else
{
var result = new StringBuilder();
result.AppendFormat("您刚才发送了文字信息：{0}\r\n\r\n", requestMessage.Content);
if (CurrentMessageContext.RequestMessages.Count > 1)
{
result.AppendFormat("您刚才还发送了如下消息（{0}/{1}）：\r\n", CurrentMessageContext.RequestMessages.Count,
CurrentMessageContext.StorageData);
for (int i = CurrentMessageContext.RequestMessages.Count - 2; i >= 0; i--)
{
var historyMessage = CurrentMessageContext.RequestMessages[i];
result.AppendFormat("{0} 【{1}】{2}\r\n",
historyMessage.CreateTime.ToShortTimeString(),
historyMessage.MsgType.ToString(),
(historyMessage is RequestMessageText)
? (historyMessage as RequestMessageText).Content
: "[非文字类型]"
);
}
result.AppendLine("\r\n");
}
result.AppendFormat("如果您在{0}分钟内连续发送消息，记录将被自动保留（当前设置：最多记录{1}条）。过期后记录将会自动清除。\r\n",
WeixinContext.ExpireMinutes, WeixinContext.MaxRecordCount);
result.AppendLine("\r\n");
result.AppendLine(
"您还可以发送【位置】【图片】【语音】【视频】等类型的信息（注意是这几种类型，不是这几个文字），查看不同格式的回复。\r\nSDK官方地址：http://sdk.weixin.senparc.com");
responseMessage.Content = result.ToString();
}
return(responseMessage);
}
/// <summary>
/// 执行NeuChar判断过程，获取响应消息
/// </summary>
/// <param name="requestMessage"></param>
/// <param name="messageHandler"></param>
/// <param name="accessTokenOrApi"></param>
/// <returns></returns>
public async Task <IResponseMessageBase> ExecuteAsync <TC, TRequest, TResponse>(IRequestMessageBase requestMessage, IMessageHandlerWithContext <TC, TRequest, TResponse> messageHandler,
string accessTokenOrApi)
where TC : class, IMessageContext <TRequest, TResponse>, new()
where TRequest : class, IRequestMessageBase
where TResponse : class, IResponseMessageBase
{
//SenparcTrace.SendCustomLog("neuchar trace","1");
//if (accessTokenOrApi == null)
//{
// throw new ArgumentNullException(nameof(accessTokenOrApi));
//}
if (messageHandler == null)
{
throw new ArgumentNullException(nameof(messageHandler));
}
var messageHandlerEnlightener = messageHandler.MessageEntityEnlightener;
var appDataNode = messageHandler.CurrentAppDataNode;
IResponseMessageBase responseMessage = null;
//SenparcTrace.SendCustomLog("neuchar trace", "3");
//进行APP特殊处理
//判断状态
var context = await messageHandler.GetCurrentMessageContext();
AppDataItem currentAppDataItem = null;
switch (context.AppStoreState)
{
case AppStoreState.None: //未进入任何应用
case AppStoreState.Exit:
currentAppDataItem = null;
break;
case AppStoreState.Enter:
//判断是否已过期
if (context.CurrentAppDataItem != null)
{
if (context.LastActiveTime.HasValue && context.LastActiveTime.Value.AddMinutes(context.CurrentAppDataItem.MessageKeepTime) < SystemTime.Now)
{
//没有上一条活动，或者对话已过期，则设置为退出状态
context.AppStoreState = AppStoreState.None;
context.CurrentAppDataItem = null; //退出清空
await messageHandler.GlobalMessageContext.UpdateMessageContextAsync(context); //储存到缓存
}
else
{
//继续保持应用状态
currentAppDataItem = context.CurrentAppDataItem;
if (requestMessage is IRequestMessageText || requestMessage is IRequestMessageEventKey requestClick)
{
var content = (requestMessage is IRequestMessageText requestText) ? requestText.Content : (requestMessage as IRequestMessageEventKey).EventKey;
if (!context.CurrentAppDataItem.MessageExitWord.IsNullOrEmpty() && context.CurrentAppDataItem.MessageExitWord.Equals(content, StringComparison.OrdinalIgnoreCase))
{
//执行退出命令
context.AppStoreState = AppStoreState.None;
context.CurrentAppDataItem = null; //退出清空
//currentAppDataItem = context.CurrentAppDataItem;//当前消息仍然转发（最后一条退出消息）
await messageHandler.GlobalMessageContext.UpdateMessageContextAsync(context); //储存到缓存
}
}
}
}
else
{
//已经进入App状态，但是没有标记退出，此处强制退出
context.AppStoreState = AppStoreState.None;
await messageHandler.GlobalMessageContext.UpdateMessageContextAsync(context); //储存到缓存
}
break;
default:
break;
}
//TODO:暂时限定类型
if (currentAppDataItem == null)
{
if (requestMessage is IRequestMessageText || requestMessage is IRequestMessageEventKey requestClick)
{
var content = (requestMessage is IRequestMessageText requestText) ? requestText.Content : (requestMessage as IRequestMessageEventKey).EventKey;
currentAppDataItem = appDataNode.Config.AppDataItems
.FirstOrDefault(z => z.ExpireDateTime > SystemTime.Now && !z.MessageEnterWord.IsNullOrEmpty() && z.MessageEnterWord.Equals(content, StringComparison.OrdinalIgnoreCase));
if (currentAppDataItem != null && currentAppDataItem.MessageKeepTime > 0)
{
//初次进入应用
context.AppStoreState = AppStoreState.Enter;
context.CurrentAppDataItem = currentAppDataItem;
await messageHandler.GlobalMessageContext.UpdateMessageContextAsync(context);//储存到缓存
}
}
}
if (currentAppDataItem != null) //已经锁定某个App
{
//NeuralSystem.Instance.NeuCharDomainName = "https://www.neuchar.com";
//转发AppData消息
var neuCharUrl = $"{NeuralSystem.Instance.NeuCharDomainName}/App/Weixin?appId={currentAppDataItem.Id}&neuralAppId={appDataNode.NeuralAppId}";
try
{
responseMessage = MessageAgent.RequestResponseMessage(messageHandler, neuCharUrl, "Senparc", requestMessage.ConvertEntityToXmlString());
}
catch (Exception ex)
{
Senparc.CO2NET.Trace.SenparcTrace.SendCustomLog("NeuChar 远程调用 APP 失败", ex.Message);
}
}
//APP特殊处理结束
if (responseMessage != null)
{
if (messageHandler.MessageEntityEnlightener.PlatformType == PlatformType.WeChat_MiniProgram && responseMessage is IResponseMessageText)
{
//小程序
messageHandler.ApiEnlightener.SendText(accessTokenOrApi, messageHandler.WeixinOpenId, (responseMessage as IResponseMessageText).Content);
return(new SuccessResponseMessage());
}
else
{
return(responseMessage);
}
}
//处理普通消息回复
switch (requestMessage.MsgType)
{
case RequestMsgType.Text:
{
try
{
//SenparcTrace.SendCustomLog("neuchar trace", "3.1");
var textRequestMessage = requestMessage as IRequestMessageText;
//遍历所有的消息设置
foreach (var messagePair in Config.MessagePair.Where(z => z.Request.Type == RequestMsgType.Text))
{
//遍历每一个消息设置中的关键词
var pairSuccess = messagePair.Request.Keywords.Exists(keyword => keyword.Equals(textRequestMessage.Content, StringComparison.OrdinalIgnoreCase));
if (pairSuccess)
{
responseMessage = await GetResponseMessage(requestMessage, messagePair.Responses, messageHandler, accessTokenOrApi);
}
if (responseMessage != null)
{
break;
}
}
}
catch (Exception ex)
{
SenparcTrace.SendCustomLog("neuchar text error", ex.Message + "\r\n|||\r\n" + (ex.InnerException != null ? ex.InnerException.ToString() : ""));
}
}
break;
case RequestMsgType.Image:
{
var imageRequestMessage = requestMessage as IRequestMessageImage;
//遍历所有的消息设置
foreach (var messagePair in Config.MessagePair.Where(z => z.Request.Type == RequestMsgType.Image))
{
responseMessage = await GetResponseMessage(requestMessage, messagePair.Responses, messageHandler, accessTokenOrApi);
if (responseMessage != null)
{
break;
}
}
}
break;
case RequestMsgType.Event:
{
//菜单或其他系统事件
if (requestMessage is IRequestMessageEvent eventRequestMessage)
{
var eventType = eventRequestMessage.EventName.ToUpper();
//构造返回结果
List <Response> responses = new List <Response>();
switch (eventType)
{
case "CLICK" when requestMessage is IRequestMessageEventKey clickRequestMessage:
{
//TODO:暂时只支持CLICK，因此在这里遍历
foreach (var messagePair in Config.MessagePair.Where(z => z.Request.Type == RequestMsgType.Event))
{
var pairSuccess = messagePair.Request.Keywords.Exists(keyword => keyword.Equals(clickRequestMessage.EventKey, StringComparison.OrdinalIgnoreCase));
if (pairSuccess)
{
try
{
responseMessage = await GetResponseMessage(requestMessage, messagePair.Responses, messageHandler, accessTokenOrApi);
}
catch (Exception ex)
{
SenparcTrace.SendCustomLog("CLICK 跟踪 1.1", ex.Message + "\r\n" + ex.StackTrace);
}
}
if (responseMessage != null)
{
break;
}
}
}
break;
default:
break;
}
}
else
{
//下级模块中没有正确处理 requestMessage 类型
}
}
break;
default:
//不作处理
//throw new UnknownRequestMsgTypeException("NeuChar未支持的的MsgType请求类型："+ requestMessage.MsgType, null);
break;
}
//SenparcTrace.SendCustomLog("neuchar trace", "4");
return(responseMessage);
}
public override void Search()
{
try
{
string sP_SHOW_TYPE = string.Empty;
// using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Dev))
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DN_DN01_SELECT_01", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("i_sdate", MySqlDbType.VarChar, 8);
cmd.Parameters[0].Value = dtS_DATE.EditValue3;
cmd.Parameters.Add("i_edate", MySqlDbType.VarChar, 8);
cmd.Parameters[1].Value = dtE_DATE.EditValue3;
cmd.Parameters.Add("i_type", MySqlDbType.VarChar, 50);
cmd.Parameters[2].Value = cmbORDER_SEARCH.EditValue;
cmd.Parameters.Add("i_search", MySqlDbType.VarChar, 50);
cmd.Parameters[3].Value = txtI_SEARCH.EditValue;
if (rbP_SHOW_TYPE.EditValue.ToString() != "Y" && rbP_SHOW_TYPE.EditValue.ToString() != "N")
{
sP_SHOW_TYPE = null;
}
else
{
sP_SHOW_TYPE = rbP_SHOW_TYPE.EditValue.ToString();
}
// efwRadioGroup1.Properties.Items[efwRadioGroup1.SelectedIndex].Valuellllll.ToString()
cmd.Parameters.Add("i_is_order", MySqlDbType.VarChar, 10);
cmd.Parameters[4].Value = sP_SHOW_TYPE;
cmd.Parameters.Add("i_order_mall_type", MySqlDbType.VarChar, 10);
cmd.Parameters[5].Value = cmbMALL_TYPE.EditValue;
//Console.WriteLine(" i_sdate ---> [" + cmd.Parameters[0].Value + "]" );
//Console.WriteLine(" i_edate ---> [" + cmd.Parameters[1].Value + "]");
//Console.WriteLine(" i_type ---> [" + cmd.Parameters[2].Value + "]");
//Console.WriteLine(" i_search ---> [" + cmd.Parameters[3].Value + "]");
//Console.WriteLine(" i_is_order ---> [" + cmd.Parameters[4].Value + "]");
//Console.WriteLine(" i_order_mall_type ---> [" + cmd.Parameters[5].Value + "]");
cmd.Parameters.Add("i_o_type1", MySqlDbType.VarChar, 10);
cmd.Parameters[6].Value = chkI.EditValue;
cmd.Parameters.Add("i_o_type2", MySqlDbType.VarChar, 10);
cmd.Parameters[7].Value = chkO.EditValue;
cmd.Parameters.Add("i_o_type3", MySqlDbType.VarChar, 10);
cmd.Parameters[8].Value = chkP.EditValue;
cmd.Parameters.Add("i_o_type4", MySqlDbType.VarChar, 10);
cmd.Parameters[9].Value = chkD.EditValue;
cmd.Parameters.Add("i_o_type5", MySqlDbType.VarChar, 10);
cmd.Parameters[10].Value = chkF.EditValue;
cmd.Parameters.Add("i_o_type6", MySqlDbType.VarChar, 10);
cmd.Parameters[11].Value = chkE.EditValue;
cmd.Parameters.Add("i_o_type7", MySqlDbType.VarChar, 10);
cmd.Parameters[12].Value = chkC.EditValue;
cmd.Parameters.Add("i_o_type8", MySqlDbType.VarChar, 10);
cmd.Parameters[13].Value = chkZ.EditValue;
cmd.Parameters.Add("i_o_type9", MySqlDbType.VarChar, 10);
cmd.Parameters[14].Value = chkX.EditValue;
cmd.Parameters.Add("i_o_type10", MySqlDbType.VarChar, 10);
cmd.Parameters[15].Value = chkT.EditValue;
cmd.Parameters.Add("i_o_type11", MySqlDbType.VarChar, 10);
cmd.Parameters[16].Value = chkA.EditValue;
cmd.Parameters.Add("i_o_type12", MySqlDbType.VarChar, 10);
cmd.Parameters[17].Value = chkB.EditValue;
cmd.Parameters.Add("i_g_prod", MySqlDbType.VarChar, 10);
cmd.Parameters[18].Value = rbG_Prod.EditValue;
//cmbOrderDate
cmd.Parameters.Add("i_order_date", MySqlDbType.VarChar, 10);
cmd.Parameters[19].Value = cmbOrderDate.EditValue;
cmd.Parameters.Add("i_o_pay_type", MySqlDbType.VarChar, 1);
cmd.Parameters[20].Value = rbo_pay_type.EditValue;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable ds = new DataTable();
sda.Fill(ds);
efwGridControl1.DataBind(ds);
this.efwGridControl1.MyGridView.BestFitColumns();
}
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
// 저장
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
if (txtYN.EditValue.ToString() == "Y")
{
MessageAgent.MessageShow(MessageType.Warning, " 이체 처리 되었습니다. 신규 버튼을 눌른후 다시 저장 하세요. ");
return;
}
if (cmbDonut_Type.EditValue.ToString() == "0")
{
MessageAgent.MessageShow(MessageType.Warning, " 차감 머니 종류를 선택하세요. ");
return;
}
if (cmbDonut_Type1.EditValue.ToString() == "0")
{
MessageAgent.MessageShow(MessageType.Warning, " 적립 머니 종류를 선택하세요. ");
return;
}
string shold_money;
if (cmbDonut_Type.EditValue.ToString() == "GD")
{
shold_money = lblGD_MONEY.Text;
}
else if (cmbDonut_Type.EditValue.ToString() == "TD")
{
shold_money = lblTD_MONEY.Text;
}
else
{
shold_money = lblDM_MONEY.Text;
}
if (Convert.ToInt32(shold_money.Replace(",", "")) < Convert.ToInt32(txtdonut_count.EditValue.ToString().Replace(",", "")))
{
MessageAgent.MessageShow(MessageType.Warning, " 보유금액보다 이체할 금액이 더 많습니다. ");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DT_DT01_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_sender", MySqlDbType.VarChar));
cmd.Parameters["i_sender"].Value = txtU_Id.EditValue;
cmd.Parameters["i_sender"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_send_login_id", MySqlDbType.VarChar));
cmd.Parameters["i_send_login_id"].Value = txtLogin_Id.EditValue;
cmd.Parameters["i_send_login_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_send_donut_type", MySqlDbType.VarChar));
cmd.Parameters["i_send_donut_type"].Value = cmbDonut_Type.EditValue;
cmd.Parameters["i_send_donut_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_receiver", MySqlDbType.VarChar));
cmd.Parameters["i_receiver"].Value = txtU_Id1.EditValue;
cmd.Parameters["i_receiver"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_rec_login_id", MySqlDbType.VarChar));
cmd.Parameters["i_rec_login_id"].Value = txtLogin_Id1.EditValue;
cmd.Parameters["i_rec_login_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_rec_donut_type", MySqlDbType.VarChar));
cmd.Parameters["i_rec_donut_type"].Value = cmbDonut_Type1.EditValue;
cmd.Parameters["i_rec_donut_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_donut_count", MySqlDbType.Int32));
cmd.Parameters["i_donut_count"].Value = Convert.ToInt32(txtdonut_count.EditValue);
cmd.Parameters["i_donut_count"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_hold_money", MySqlDbType.Int32));
cmd.Parameters["i_hold_money"].Value = Convert.ToInt32(shold_money.Replace(",", ""));
cmd.Parameters["i_hold_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_send_message", MySqlDbType.VarChar));
cmd.Parameters["i_send_message"].Value = txtsend_message.EditValue;
cmd.Parameters["i_send_message"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_receive_message", MySqlDbType.VarChar));
cmd.Parameters["i_receive_message"].Value = txtreceive_message.EditValue;
cmd.Parameters["i_receive_message"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
txtYN.Text = "Y";
Search();
MoneySet();
}
}
//private void efwGridControl1_Click(object sender, EventArgs e)
//{
//}
private void setCmb()
{
try
{
//Dictionary<string, string> myRecord;
string strQueruy1 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'MALL_TYPE' and Use_YN = 'Y' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbMALL_TYPE, strQueruy1);
cmbMALL_TYPE.EditValue = "";
string strQueruy2 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'ORDER_SEARCH' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbORDER_SEARCH, strQueruy2);
cmbORDER_SEARCH.EditValue = "1";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00025' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbChange_type, codeArray);
}
cmbChange_type.EditValue = "";
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00032' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbOrderDate, codeArray);
}
cmbOrderDate.EditValue = "1";
}
public override IResponseMessageBase OnEvent_ClickRequest(RequestMessageEvent_Click requestMessage)
{
IResponseMessageBase reponseMessage = null;
//菜单点击，需要跟创建菜单时的Key匹配
switch (requestMessage.EventKey)
{
case "OneClick":
{
//这个过程实际已经在OnTextOrEventRequest中完成，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "hello world！！！！您点击了底部按钮。\r\n为了测试微信软件换行bug的应对措施，这里做了一个——\r\n换行";
}
break;
case "SubClickRoot_Text":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "hello祖爷 你好啊！！！！您点击了子菜单按钮。";
}
break;
case "SubClickRoot_News":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "祖爷 你好啊！！！！您点击了子菜单图文按钮",
Description = "您点击了子菜单图文按钮，这是一条图文信息。呵呵呵",
PicUrl = "http://weixin.senparc.com/Images/qrcode.jpg",
Url = "http://weixin.senparc.com"
});
strongResponseMessage.Articles.Add(new Article()
{
Title = "2祖爷 你好啊！！！！您点击了子菜单图文按钮",
Description = "您点击了子菜单图文按钮，这是一条图文信息。呵呵呵",
PicUrl = "http://weixin.senparc.com/Images/qrcode.jpg",
Url = "http://weixin.senparc.com"
});
}
break;
case "SubClickRoot_Music":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageMusic>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Music.MusicUrl = "http://weixin.senparc.com/Content/music1.mp3";
}
break;
case "SubClickRoot_Image":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageImage>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Image.MediaId = "Mj0WUTZeeG9yuBKhGP7iR5n1xUJO9IpTjGNC4buMuswfEOmk6QSIRb_i98do5nwo";
}
break;
case "SubClickRoot_Agent": //代理消息
{
//获取返回的XML
DateTime dt1 = DateTime.Now;
reponseMessage = MessageAgent.RequestResponseMessage(this, agentUrl, agentToken, RequestDocument.ToString());
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
DateTime dt2 = DateTime.Now;
if (reponseMessage is ResponseMessageNews)
{
(reponseMessage as ResponseMessageNews)
.Articles[0]
.Description += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
}
break;
case "Member": //托管代理会员信息
{
//原始方法为：MessageAgent.RequestXml(this,agentUrl, agentToken, RequestDocument.ToString());//获取返回的XML
reponseMessage = this.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
}
break;
case "OAuth": //OAuth授权测试
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试",
Description = "点击【查看全文】进入授权页面。\r\n注意：此页面仅供测试（是专门的一个临时测试账号的授权，并非Senparc.Weixin.MP SDK官方账号，所以如果授权后出现错误页面数正常情况），测试号随时可能过期。请将此DEMO部署到您自己的服务器上，并使用自己的appid和secret。",
Url = "http://weixin.senparc.com/oauth2",
PicUrl = "http://weixin.senparc.com/Images/qrcode.jpg"
});
reponseMessage = strongResponseMessage;
}
break;
case "Description":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = GetWelcomeInfo();
reponseMessage = strongResponseMessage;
}
break;
default:
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = "您点击了按钮，EventKey：" + requestMessage.EventKey;
reponseMessage = strongResponseMessage;
}
break;
}
return(reponseMessage);
}
private void efwSimpleButton9_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtAcc_Code.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "계정코드를 선택하세요!");
return;
}
if (cmbCompany.EditValue.ToString() == "")
{
MessageAgent.MessageShow(MessageType.Warning, " 회사구분을 선택하세요!");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_TM_TM14_SAVE_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txtidx.EditValue).ToString();
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_company", MySqlDbType.VarChar));
cmd.Parameters["i_company"].Value = cmbCompany.EditValue;
cmd.Parameters["i_company"].Direction = ParameterDirection.Input;
string sAcc_Date = string.Empty;
sAcc_Date = txtAcc_Date.EditValue.ToString();
sAcc_Date = sAcc_Date.Substring(0, 4) + "-" + sAcc_Date.Substring(5, 2) + "-" + sAcc_Date.Substring(8, 2) + " " + sAcc_Date.Substring(13, 8);
cmd.Parameters.Add(new MySqlParameter("i_acc_date", MySqlDbType.DateTime));
cmd.Parameters["i_acc_date"].Value = Convert.ToDateTime(sAcc_Date);
cmd.Parameters["i_acc_date"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_acc_code", MySqlDbType.VarChar));
cmd.Parameters["i_acc_code"].Value = txtAcc_Code.EditValue;
cmd.Parameters["i_acc_code"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_amt", MySqlDbType.Int32));
cmd.Parameters["i_amt"].Value = Convert.ToInt32(txtAmt.EditValue).ToString();
cmd.Parameters["i_amt"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_summary", MySqlDbType.VarChar));
cmd.Parameters["i_summary"].Value = txtSummary.EditValue;
cmd.Parameters["i_summary"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
cmd.Parameters["i_remark"].Value = txtRemark.EditValue;
cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.Int32));
cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtidx.EditValue = cmd.Parameters["o_idx"].Value.ToString();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Search();
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtidx.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "배스트샵을 선택하세요 !");
return;
}
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.DefaultExt = "jpg";
openFileDialog.FileName = "*.jpg";
openFileDialog.Filter = "이미지파일|*.jpg";
openFileDialog.Title = "이미지파일 가져오기";
string sftpURL = "14.63.165.36";
string sUserName = "******";
string sPassword = "******";
int nPort = 22023;
string sftpDirectory = "/domalifefiles/files/gshop_best_poto/" + Convert.ToString(txtgshop_id.EditValue);
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
Cursor = Cursors.WaitCursor;
txtafter_url.EditValue = openFileDialog.FileName;
picBest_Pic2.LoadAsync(openFileDialog.FileName);
}
catch (Exception ex)
{
MessageBox.Show("이미지파일이 문제가 있습니다." + "\r\n" + ex.ToString());
}
finally
{
Cursor = Cursors.Default;
}
// 폴더생성
DirectoryInfo di = new DirectoryInfo(@"c:\temp");
if (di.Exists == false)
{
di.Create();
}
// 선택된 파일을 위에서 만든 폴더에 이름을 바꿔 저장
string sOldFile = txtafter_url.EditValue.ToString();
string sFileName = Convert.ToString(System.DateTime.Now.ToString("yyyyMMddhhmmss")) + ".jpg";
string sNewFile = "c:\\temp\\" + sFileName;
System.IO.File.Copy(sOldFile, sNewFile);
string LocalDirectory = "C:\\temp"; //Local directory from where the files will be uploaded
Sftp sSftp = new Sftp(sftpURL, sUserName, sPassword);
sSftp.Connect(nPort);
// 저장 경로에 있는지 체크
string sFtpPath = "/domalifefiles/files/gshop_best_poto/";
string sFtpPath2 = "/domalifefiles/files/gshop_best_poto/" + Convert.ToString(txtgshop_id.EditValue);
ArrayList ay = sSftp.GetFileList(sFtpPath);
bool isdir = false;
for (int i = 0; i < ay.Count; i++)
{
// string sChk = ay[i].ToString();
if (ay[i].ToString() == Convert.ToString(txtgshop_id.EditValue).ToString())
{
isdir = true;
}
}
if (isdir == false)
{
sSftp.Mkdir(sFtpPath2);
}
sSftp.Put(LocalDirectory + "/" + sFileName, sftpDirectory + "/" + sFileName);
sSftp.Close();
txtafter_url.EditValue = "https://media.domalife.net/files/gshop_best_poto/" + Convert.ToString(txtgshop_id.EditValue) + "/" + sFileName;
}
}
private void Open1()
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_MM_MM14_SELECT_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_p_id", MySqlDbType.Int32));
cmd.Parameters["i_p_id"].Value = Convert.ToInt32(txtP_Id.EditValue);
cmd.Parameters["i_p_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_doma_rate", MySqlDbType.Int32));
cmd.Parameters["o_doma_rate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_vip_rate", MySqlDbType.Int32));
cmd.Parameters["o_vip_rate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_chef_rate", MySqlDbType.Int32));
cmd.Parameters["o_chef_rate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_md_rate", MySqlDbType.Int32));
cmd.Parameters["o_md_rate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_gshop_rate", MySqlDbType.Int32));
cmd.Parameters["o_gshop_rate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_doma_money", MySqlDbType.VarChar));
cmd.Parameters["o_doma_money"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_vip_money", MySqlDbType.VarChar));
cmd.Parameters["o_vip_money"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_chef_money", MySqlDbType.VarChar));
cmd.Parameters["o_chef_money"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_md_money", MySqlDbType.VarChar));
cmd.Parameters["o_md_money"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_gshop_money", MySqlDbType.VarChar));
cmd.Parameters["o_gshop_money"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtdoma_rate.EditValue = cmd.Parameters["o_doma_rate"].Value.ToString();
txtvip_rate.EditValue = cmd.Parameters["o_vip_rate"].Value.ToString();
txtchef_rate.EditValue = cmd.Parameters["o_chef_rate"].Value.ToString();
txtmd_rate.EditValue = cmd.Parameters["o_md_rate"].Value.ToString();
txtgshop_rate.EditValue = cmd.Parameters["o_gshop_rate"].Value.ToString();
cmbDoma_Money.EditValue = cmd.Parameters["o_doma_money"].Value.ToString();
cmbVip_Money.EditValue = cmd.Parameters["o_vip_money"].Value.ToString();
cmbChef_Money.EditValue = cmd.Parameters["o_chef_money"].Value.ToString();
cmbMd_Money.EditValue = cmd.Parameters["o_md_money"].Value.ToString();
cmbGshop_Money.EditValue = cmd.Parameters["o_gshop_money"].Value.ToString();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void efwSimpleButton7_Click_1(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtPm_prodser.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "상품을 선택하세요!");
return;
}
// 도마
string sDoma_Rate = string.Empty;
sDoma_Rate = string.IsNullOrEmpty(this.txtDoma_Rate.Text).ToString();
if ((string.IsNullOrEmpty(this.txtDoma_Rate.Text)) || (txtDoma_Rate.EditValue.ToString() == "0"))
{
sDoma_Rate = "0";
}
if ((sDoma_Rate == "0" && cmbDoma_Money.EditValue.ToString() != "0") || (sDoma_Rate != "0" && cmbDoma_Money.EditValue.ToString() == "0"))
{
MessageAgent.MessageShow(MessageType.Warning, "일반도마 할인율과 사용머니를 선택하세요!");
return;
}
// Vip
string sVip_Rate = string.Empty;
sVip_Rate = string.IsNullOrEmpty(this.txtVip_Rate.Text).ToString();
if ((string.IsNullOrEmpty(this.txtVip_Rate.Text)) || (txtVip_Rate.EditValue.ToString() == "0"))
{
sVip_Rate = "0";
}
if ((sVip_Rate == "0" && cmbDoma_Money.EditValue.ToString() != "0") || (sVip_Rate != "0" && cmbVip_Money.EditValue.ToString() == "0"))
{
MessageAgent.MessageShow(MessageType.Warning, "VIP 할인율과 사용머니를 선택하세요!");
return;
}
// Chef
string sChef_Rate = string.Empty;
sChef_Rate = string.IsNullOrEmpty(this.txtChef_Rate.Text).ToString();
if ((string.IsNullOrEmpty(this.txtChef_Rate.Text)) || (txtChef_Rate.EditValue.ToString() == "0"))
{
sChef_Rate = "0";
}
if ((sChef_Rate == "0" && cmbChef_Money.EditValue.ToString() != "0") || (sChef_Rate != "0" && cmbChef_Money.EditValue.ToString() == "0"))
{
MessageAgent.MessageShow(MessageType.Warning, "G 매니저 할인율과 사용머니를 선택하세요!");
return;
}
// Md
string sMd_Rate = string.Empty;
sMd_Rate = string.IsNullOrEmpty(this.txtMd_Rate.Text).ToString();
if ((string.IsNullOrEmpty(this.txtMd_Rate.Text)) || (txtMd_Rate.EditValue.ToString() == "0"))
{
sMd_Rate = "0";
}
if ((sMd_Rate == "0" && cmbMd_Money.EditValue.ToString() != "0") || (sMd_Rate != "0" && cmbMd_Money.EditValue.ToString() == "0"))
{
MessageAgent.MessageShow(MessageType.Warning, "셰프이사 할인율과 사용머니를 선택하세요!");
return;
}
// Gshop
string sGshop_Rate = string.Empty;
sGshop_Rate = string.IsNullOrEmpty(this.txtGshop_Rate.Text).ToString();
if ((string.IsNullOrEmpty(this.txtGshop_Rate.Text)) || (txtGshop_Rate.EditValue.ToString() == "0"))
{
sGshop_Rate = "0";
}
if ((sGshop_Rate == "0" && cmbGshop_Money.EditValue.ToString() != "0") || (sGshop_Rate != "0" && cmbGshop_Money.EditValue.ToString() == "0"))
{
MessageAgent.MessageShow(MessageType.Warning, "G 멀티샵 할인율과 사용머니를 선택하세요!");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_MM_MM15_SAVE_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_Id", MySqlDbType.Int32));
cmd.Parameters["i_Id"].Value = Convert.ToInt32(txtId.EditValue);
cmd.Parameters["i_Id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_pm_prodser", MySqlDbType.Int32));
cmd.Parameters["i_pm_prodser"].Value = Convert.ToInt32(txtPm_prodser.EditValue);
cmd.Parameters["i_pm_prodser"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_P_Id", MySqlDbType.Int32));
cmd.Parameters["i_P_Id"].Value = Convert.ToInt32(txtP_Id.EditValue);
cmd.Parameters["i_P_Id"].Direction = ParameterDirection.Input;
// doma
int nDoma_Rate = 0;
if (string.IsNullOrEmpty(this.txtDoma_Rate.Text))
{
nDoma_Rate = 0;
}
else
{
nDoma_Rate = Convert.ToInt32(txtDoma_Rate.EditValue);
}
cmd.Parameters.Add(new MySqlParameter("i_doma_rate", MySqlDbType.Int32));
cmd.Parameters["i_doma_rate"].Value = nDoma_Rate;
cmd.Parameters["i_doma_rate"].Direction = ParameterDirection.Input;
// Vip
int nVip_Rate = 0;
if (string.IsNullOrEmpty(this.txtVip_Rate.Text))
{
nVip_Rate = 0;
}
else
{
nVip_Rate = Convert.ToInt32(txtVip_Rate.EditValue);
}
cmd.Parameters.Add(new MySqlParameter("i_vip_rate", MySqlDbType.Int32));
cmd.Parameters["i_vip_rate"].Value = nVip_Rate;
cmd.Parameters["i_vip_rate"].Direction = ParameterDirection.Input;
// Chef
int nChef_Rate = 0;
if (string.IsNullOrEmpty(this.txtChef_Rate.Text))
{
nChef_Rate = 0;
}
else
{
nChef_Rate = Convert.ToInt32(txtChef_Rate.EditValue);
}
cmd.Parameters.Add(new MySqlParameter("i_chef_rate", MySqlDbType.Int32));
cmd.Parameters["i_chef_rate"].Value = nChef_Rate;
cmd.Parameters["i_chef_rate"].Direction = ParameterDirection.Input;
// MD
int nMd_Rate = 0;
if (string.IsNullOrEmpty(this.txtMd_Rate.Text))
{
nMd_Rate = 0;
}
else
{
nMd_Rate = Convert.ToInt32(txtMd_Rate.EditValue);
}
cmd.Parameters.Add(new MySqlParameter("i_md_rate", MySqlDbType.Int32));
cmd.Parameters["i_md_rate"].Value = nMd_Rate;
cmd.Parameters["i_md_rate"].Direction = ParameterDirection.Input;
// Gshop
int nGshop_Rate = 0;
if (string.IsNullOrEmpty(this.txtGshop_Rate.Text))
{
nGshop_Rate = 0;
}
else
{
nGshop_Rate = Convert.ToInt32(txtGshop_Rate.EditValue);
}
cmd.Parameters.Add(new MySqlParameter("i_gshop_rate", MySqlDbType.Int32));
cmd.Parameters["i_gshop_rate"].Value = nGshop_Rate;
cmd.Parameters["i_gshop_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_doma_money", MySqlDbType.VarChar));
cmd.Parameters["i_doma_money"].Value = cmbDoma_Money.EditValue;
cmd.Parameters["i_doma_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_vip_money", MySqlDbType.VarChar));
cmd.Parameters["i_vip_money"].Value = cmbVip_Money.EditValue;
cmd.Parameters["i_vip_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_chef_money", MySqlDbType.VarChar));
cmd.Parameters["i_chef_money"].Value = cmbChef_Money.EditValue;
cmd.Parameters["i_chef_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_money", MySqlDbType.VarChar));
cmd.Parameters["i_md_money"].Value = cmbMd_Money.EditValue;
cmd.Parameters["i_md_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gshop_money", MySqlDbType.VarChar));
cmd.Parameters["i_gshop_money"].Value = cmbGshop_Money.EditValue;
cmd.Parameters["i_gshop_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_is_banner", MySqlDbType.VarChar));
cmd.Parameters["i_is_banner"].Value = rbIs_Banner.EditValue;
cmd.Parameters["i_is_banner"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
Open1();
}
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
// 필수항목 CHECK txtP_Img
if (string.IsNullOrEmpty(this.txtP_Name.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "상품을 선택하세요!");
txtP_Name.Focus();
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_MM_MM14_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_P_Id", MySqlDbType.Int32));
cmd.Parameters["i_P_Id"].Value = Convert.ToInt32(txtP_Id.EditValue);
cmd.Parameters["i_P_Id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_doma_rate", MySqlDbType.Int32));
cmd.Parameters["i_doma_rate"].Value = Convert.ToInt32(txtdoma_rate.EditValue);
cmd.Parameters["i_doma_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_vip_rate", MySqlDbType.Int32));
cmd.Parameters["i_vip_rate"].Value = Convert.ToInt32(txtvip_rate.EditValue);
cmd.Parameters["i_vip_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_chef_rate", MySqlDbType.Int32));
cmd.Parameters["i_chef_rate"].Value = Convert.ToInt32(txtchef_rate.EditValue);
cmd.Parameters["i_chef_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_rate", MySqlDbType.Int32));
cmd.Parameters["i_md_rate"].Value = Convert.ToInt32(txtmd_rate.EditValue);
cmd.Parameters["i_md_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gshop_rate", MySqlDbType.Int32));
cmd.Parameters["i_gshop_rate"].Value = Convert.ToInt32(txtgshop_rate.EditValue);
cmd.Parameters["i_gshop_rate"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_doma_money", MySqlDbType.VarChar));
cmd.Parameters["i_doma_money"].Value = cmbDoma_Money.EditValue;
cmd.Parameters["i_doma_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_vip_money", MySqlDbType.VarChar));
cmd.Parameters["i_vip_money"].Value = cmbVip_Money.EditValue;
cmd.Parameters["i_vip_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_chef_money", MySqlDbType.VarChar));
cmd.Parameters["i_chef_money"].Value = cmbChef_Money.EditValue;
cmd.Parameters["i_chef_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_money", MySqlDbType.VarChar));
cmd.Parameters["i_md_money"].Value = cmbMd_Money.EditValue;
cmd.Parameters["i_md_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gshop_money", MySqlDbType.VarChar));
cmd.Parameters["i_gshop_money"].Value = cmbGshop_Money.EditValue;
cmd.Parameters["i_gshop_money"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
}
/// <summary>
/// 点击事件
/// </summary>
/// <param name="requestMessage">请求消息</param>
/// <returns></returns>
public override IResponseMessageBase OnEvent_ClickRequest(RequestMessageEvent_Click requestMessage)
{
IResponseMessageBase reponseMessage = null;
//菜单点击，需要跟创建菜单时的Key匹配
switch (requestMessage.EventKey)
{
case "OneClick":
{
//这个过程实际已经在OnTextOrEventRequest中命中“OneClick”关键字，并完成回复，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了底部按钮。\r\n为了测试微信软件换行bug的应对措施，这里做了一个——\r\n换行";
}
break;
case "SubClickRoot_Text":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了子菜单按钮。";
}
break;
case "SubClickRoot_News":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "您点击了子菜单图文按钮",
Description = "您点击了子菜单图文按钮，这是一条图文信息。这个区域是Description内容\r\n可以使用\\r\\n进行换行。",
PicUrl = "https://sdk.weixin.senparc.com/Images/qrcode.jpg",
Url = "https://sdk.weixin.senparc.com"
});
//随机添加一条图文，或只输出一条图文信息
if (SystemTime.Now.Second % 2 == 0)
{
strongResponseMessage.Articles.Add(new Article()
{
Title = "这是随机产生的第二条图文信息，用于测试多条图文的样式",
Description = "这是随机产生的第二条图文信息，用于测试多条图文的样式",
PicUrl = "https://sdk.weixin.senparc.com/Images/qrcode.jpg",
Url = "https://sdk.weixin.senparc.com"
});
}
}
break;
case "SubClickRoot_Music":
{
//上传缩略图
#if NET45
var filePath = "~/Images/Logo.thumb.jpg";
#else
var filePath = "~/wwwroot/Images/Logo.thumb.jpg";
#endif
var uploadResult = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadTemporaryMedia(appId, UploadMediaFileType.thumb,
ServerUtility.ContentRootMapPath(filePath));
//PS：缩略图官方没有特别提示文件大小限制，实际测试哪怕114K也会返回文件过大的错误，因此尽量控制在小一点（当前图片39K）
//设置音乐信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageMusic>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Music.Title = "天籁之音";
strongResponseMessage.Music.Description = "真的是天籁之音";
strongResponseMessage.Music.MusicUrl = "https://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.HQMusicUrl = "https://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.ThumbMediaId = uploadResult.thumb_media_id;
}
break;
case "SubClickRoot_Image":
{
//上传图片
#if NET45
var filePath = "~/Images/Logo.jpg";
#else
var filePath = "~/wwwroot/Images/Logo.jpg";
#endif
var uploadResult = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadTemporaryMedia(appId, UploadMediaFileType.image,
ServerUtility.ContentRootMapPath(filePath));
//设置图片信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageImage>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Image.MediaId = uploadResult.media_id;
}
break;
case "SendMenu": //菜单消息
{
//注意：
//1、此接口可以在任意地方调用（包括后台线程），此处演示为通过
//2、一下"s:"前缀只是 Senparc.Weixin 的内部约定，可以使用 OnTextRequest事件中的 requestHandler.SelectMenuKeyword() 方法自动匹配到后缀（如101）
var menuContentList = new List <SendMenuContent>()
{
new SendMenuContent("101", "满意"),
new SendMenuContent("102", "一般"),
new SendMenuContent("103", "不满意")
};
//使用异步接口
CustomApi.SendMenuAsync(appId, OpenId, "请对 Senparc.Weixin SDK 给出您的评价", menuContentList, "感谢您的参与！");
reponseMessage = new ResponseMessageNoResponse(); //不返回任何消息
}
break;
case "SubClickRoot_Agent": //代理消息
{
//获取返回的XML
var dt1 = SystemTime.Now;
reponseMessage = MessageAgent.RequestResponseMessage(this, agentUrl, agentToken, RequestDocument.ToString());
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
var dt2 = SystemTime.Now;
if (reponseMessage is ResponseMessageNews)
{
(reponseMessage as ResponseMessageNews)
.Articles[0]
.Description += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
}
break;
case "Member": //托管代理会员信息
{
//原始方法为：MessageAgent.RequestXml(this,agentUrl, agentToken, RequestDocument.ToString());//获取返回的XML
reponseMessage = this.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
}
break;
case "OAuth": //OAuth授权测试
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试",
Description = "选择下面两种不同的方式进行测试，区别在于授权成功后，最后停留的页面。",
//Url = "https://sdk.weixin.senparc.com/oauth2",
//PicUrl = "https://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试（不带returnUrl），测试环境可使用",
Description = "OAuth2.0测试（不带returnUrl）",
Url = "https://sdk.weixin.senparc.com/oauth2",
PicUrl = "https://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
var returnUrl = "/OAuth2/TestReturnUrl";
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试（带returnUrl），生产环境强烈推荐使用",
Description = "OAuth2.0测试（带returnUrl）",
Url = "https://sdk.weixin.senparc.com/oauth2?returnUrl=" + returnUrl.UrlEncode(),
PicUrl = "https://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
reponseMessage = strongResponseMessage;
}
break;
case "Description":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = GetWelcomeInfo();
reponseMessage = strongResponseMessage;
}
break;
case "SubClickRoot_PicPhotoOrAlbum":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信拍照】按钮。系统将会弹出拍照或者相册发图。";
}
break;
case "SubClickRoot_ScancodePush":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信扫码】按钮。";
}
break;
case "ConditionalMenu_Male":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：男。";
}
break;
case "ConditionalMenu_Femle":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：女。";
}
break;
case "GetNewMediaId": //获取新的MediaId
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
try
{
var result = Senparc.Weixin.MP.AdvancedAPIs.MediaApi.UploadForeverMedia(appId, ServerUtility.ContentRootMapPath("~/Images/logo.jpg"));
strongResponseMessage.Content = result.media_id;
}
catch (Exception e)
{
strongResponseMessage.Content = "发生错误：" + e.Message;
WeixinTrace.SendCustomLog("调用UploadForeverMedia()接口发生异常", e.Message);
}
}
break;
default:
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = "您点击了按钮，EventKey：" + requestMessage.EventKey;
reponseMessage = strongResponseMessage;
}
break;
}
return(reponseMessage);
}
public ActionResult Index(string url, string token, RequestMsgType requestType, Event?eventType,
bool testConcurrence, int testConcurrenceCount,
bool testEncrypt, string encodingAESKey, string appId)
{
using (MemoryStream ms = new MemoryStream())
{
var requestMessaageDoc = GetrequestMessaageDoc(/*url, token,*/ requestType, eventType);
requestMessaageDoc.Save(ms);
ms.Seek(0, SeekOrigin.Begin);
string msgSigature = null;
var timeStamp = SystemTime.NowTicks.ToString();
var nonce = (SystemTime.NowTicks * 2).ToString();
string encryptTypeAll = null;
string openIdAll = null;
//对请求消息进行加密
if (testEncrypt)
{
try
{
var openId = requestMessaageDoc.Root.Element("FromUserName").Value;
var toUserName = requestMessaageDoc.Root.Element("ToUserName").Value;
WXBizMsgCrypt msgCrype = new WXBizMsgCrypt(token, encodingAESKey, appId);
string finalResponseXml = null;
var ret = msgCrype.EncryptRequestMsg(requestMessaageDoc.ToString(), timeStamp, nonce, toUserName, ref finalResponseXml, ref msgSigature);
if (ret == 0)
{
requestMessaageDoc = XDocument.Parse(finalResponseXml);//赋值最新的加密信息
openIdAll = $"openid={openId}";
encryptTypeAll = "&encrypt_type=aes";
}
}
catch (Exception ex)
{
var data = new { Success = false, LoadTime = "N/A", Result = "发生错误：" + ex.ToString() };
return(Json(data, new JsonSerializerSettings()
{
ContractResolver = new DefaultContractResolver()
}));
throw;
}
//Senparc.CO2NET.Trace.SenparcTrace.SendCustomLog("模拟测试-加密消息：", requestMessaageDoc?.ToString());
}
var sigature = CheckSignature.GetSignature(timeStamp, nonce, token);
url += url.Contains("?") ? "&" : "?";
url += $"signature={sigature}&timeStamp={timeStamp}&nonce={nonce}&msg_signature={msgSigature}{encryptTypeAll}{openIdAll}";
//参数如：signature=330ed3b64e363dc876f35e54a79e59b48739f567×tamp=1570075722&nonce=863153744&openid=olPjZjsXuQPJoV0HlruZkNzKc91E&encrypt_type=aes&msg_signature=71dc359205a4660bc3b3046b643452c994b5897d
var dt1 = SystemTime.Now;
var responseMessageXml = MessageAgent.RequestXml(null, url, token, requestMessaageDoc.ToString(), autoFillUrlParameters: false);
if (string.IsNullOrEmpty(responseMessageXml))
{
responseMessageXml = "返回消息为空，可能已经被去重。\r\nMsgId相同的连续消息将被自动去重。";
}
try
{
if (testConcurrence)
{
dt1 = SystemTime.Now;
testConcurrenceCount = testConcurrenceCount > 30 ? 30 : testConcurrenceCount;//设定最高限额
//模拟并发请求
List <Task <string> > taskList = new List <Task <string> >();
for (int i = 0; i < testConcurrenceCount; i++)
{
var task = TestAsyncTask(url, token, requestMessaageDoc, autoFillUrlParameters: false, sleepMillionSeconds: 100);
taskList.Add(task);
}
Task.WaitAll(taskList.ToArray(), 1500 * 10);
}
var cache = CacheStrategyFactory.GetObjectCacheStrategyInstance();
var data = new
{
Success = true,
LoadTime = SystemTime.DiffTotalMS(dt1, "f4"),
Result = responseMessageXml,
CacheType = cache.GetType().Name,
ConcurrenceCount = testConcurrenceCount
};
return(Json(data, new JsonSerializerSettings()
{
ContractResolver = new DefaultContractResolver()
}));
}
catch (Exception ex)
{
var msg = string.Format("{0}\r\n{1}\r\n{2}", ex.Message, null, ex.InnerException != null ? ex.InnerException.Message : null);
return(Json(new { Success = false, Result = msg }, new JsonSerializerSettings()
{
ContractResolver = new DefaultContractResolver()
}));
}
}
}
private void Save4()
{
if (string.IsNullOrEmpty(this.txtU_NAME1.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " 회원을 선택하세요!");
return;
}
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP06_SAVE_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.VarChar));
cmd.Parameters["i_idx"].Value = txtIDX1.EditValue;
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gr_u_id", MySqlDbType.VarChar));
cmd.Parameters["i_gr_u_id"].Value = txtGR_U_ID.EditValue;
cmd.Parameters["i_gr_u_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_u_id", MySqlDbType.VarChar));
cmd.Parameters["i_md_u_id"].Value = txtMD_U_ID.EditValue;
cmd.Parameters["i_md_u_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_doramd_type", MySqlDbType.Int32, 2));
cmd.Parameters["i_doramd_type"].Value = Convert.ToInt32(cbDORAMD_TYPE.EditValue);
cmd.Parameters["i_doramd_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
cmd.Parameters["i_remark"].Value = txtREMARK.EditValue;
cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.Int32, 10));
cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;
//Console.WriteLine(" i_idx ---> [" + txtIDX1.EditValue + "]");
//Console.WriteLine(" i_gr_u_id ---> [" + txtGR_U_ID.EditValue + "]");
//Console.WriteLine(" i_md_u_id ---> [" + txtMD_U_ID.EditValue + "]");
//Console.WriteLine(" i_doramd_type ---> [" + Convert.ToInt16(cbDORAMD_TYPE.EditValue) + "]");
//Console.WriteLine(" i_remark ---> [" + txtREMARK.EditValue + "]");
//Console.WriteLine(" o_idx ---> [" + ParameterDirection.Output + "]");
cmd.ExecuteNonQuery();
txtIDX1.Text = (cmd.Parameters["o_idx"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
finally
{
EfwSimpleButton1_Click(null, null);
}
}
/// <summary>
/// 处理文字请求
/// </summary>
/// <returns></returns>
public override IResponseMessageBase OnTextRequest(RequestMessageText requestMessage)
{
//TODO:这里的逻辑可以交给Service处理具体信息，参考OnLocationRequest方法或/Service/LocationSercice.cs
//方法一（v0.1），此方法调用太过繁琐，已过时（但仍是所有方法的核心基础），建议使用方法二到四
//var responseMessage =
// ResponseMessageBase.CreateFromRequestMessage(RequestMessage, ResponseMsgType.Text) as
// ResponseMessageText;
//方法二（v0.4）
//var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageText>(RequestMessage);
//方法三（v0.4），扩展方法，需要using Senparc.Weixin.MP.Helpers;
//var responseMessage = RequestMessage.CreateResponseMessage<ResponseMessageText>();
//方法四（v0.6+），仅适合在HandlerMessage内部使用，本质上是对方法三的封装
//注意：下面泛型ResponseMessageText即返回给客户端的类型，可以根据自己的需要填写ResponseMessageNews等不同类型。
var responseMessage = base.CreateResponseMessage <ResponseMessageText>();
if (requestMessage.Content == "约束")
{
responseMessage.Content = "<a href=\"http://weixin.senparc.com/FilterTest/\">点击这里</a>进行客户端约束测试（地址：http://weixin.senparc.com/FilterTest/）。";
}
if (requestMessage.Content == "托管" || requestMessage.Content == "代理")
{
//开始用代理托管，把请求转到其他服务器上去，然后拿回结果
//甚至也可以将所有请求在DefaultResponseMessage()中托管到外部。
DateTime dt1 = DateTime.Now; //计时开始
var responseXml = MessageAgent.RequestXml(this, agentUrl, agentToken, RequestDocument.ToString()); //获取返回的XML
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
/* 如果有WeiweihiKey，可以直接使用下面的这个MessageAgent.RequestWeiweihiXml()方法。
* WeiweihiKey专门用于对接www.weiweihi.com平台，获取方式见：http://www.weiweihi.com/ApiDocuments/Item/25#51
*/
//var responseXml = MessageAgent.RequestWeiweihiXml(weiweihiKey, RequestDocument.ToString());//获取Weiweihi返回的XML
DateTime dt2 = DateTime.Now;//计时结束
//转成实体。
/* 如果要写成一行，可以直接用：
* responseMessage = MessageAgent.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
* 或
*
*/
responseMessage = responseXml.CreateResponseMessage() as ResponseMessageText;
responseMessage.Content += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
else if (requestMessage.Content == "测试" || requestMessage.Content == "退出")
{
/*
* 这是一个特殊的过程，此请求通常来自于微微嗨（http://www.weiweihi.com）的“盛派网络小助手”应用请求（http://www.weiweihi.com/User/App/Detail/1），
* 用于演示微微嗨应用商店的处理过程，由于微微嗨的应用内部可以单独设置对话过期时间，所以这里通常不需要考虑对话状态，只要做最简单的响应。
*/
if (requestMessage.Content == "测试")
{
//进入APP测试
responseMessage.Content = "您已经进入【盛派网络小助手】的测试程序，请发送任意信息进行测试。发送文字【退出】退出测试对话。10分钟内无任何交互将自动退出应用对话状态。";
}
else
{
//退出APP测试
responseMessage.Content = "您已经退出【盛派网络小助手】的测试程序。";
}
}
else
{
var result = new StringBuilder();
result.AppendFormat("您刚才发送了文字信息：{0}\r\n\r\n", requestMessage.Content);
if (CurrentMessageContext.RequestMessages.Count > 1)
{
result.AppendFormat("您刚才还发送了如下消息（{0}/{1}）：\r\n", CurrentMessageContext.RequestMessages.Count, CurrentMessageContext.StorageData);
for (int i = CurrentMessageContext.RequestMessages.Count - 2; i >= 0; i--)
{
var historyMessage = CurrentMessageContext.RequestMessages[i];
result.AppendFormat("{0} 【{1}】{2}\r\n",
historyMessage.CreateTime.ToShortTimeString(),
historyMessage.MsgType.ToString(),
(historyMessage is RequestMessageText)
? (historyMessage as RequestMessageText).Content
: "[非文字类型]"
);
}
result.AppendLine("\r\n");
}
result.AppendFormat("如果您在{0}分钟内连续发送消息，记录将被自动保留（当前设置：最多记录{1}条）。过期后记录将会自动清除。\r\n", WeixinContext.ExpireMinutes, WeixinContext.MaxRecordCount);
result.AppendLine("\r\n");
result.AppendLine("您还可以发送【位置】【图片】【语音】【视频】等类型的信息（注意是这几种类型，不是这几个文字），查看不同格式的回复。\r\nSDK官方地址：http://weixin.senparc.com");
responseMessage.Content = result.ToString();
}
return(responseMessage);
}
private void EfwSimpleButton7_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtGR_U_ID.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " 그룹MD를 선택하세요!");
return;
}
if (string.IsNullOrEmpty(this.txtU_NAME1.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " 회원을 선택하세요!");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "MD 정보를 삭제 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP06_DELETE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.VarChar));
cmd.Parameters["i_idx"].Value = txtIDX1.EditValue;
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_gr_u_id", MySqlDbType.VarChar));
cmd.Parameters["i_gr_u_id"].Value = txtGR_U_ID.EditValue;
cmd.Parameters["i_gr_u_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_md_u_id", MySqlDbType.VarChar));
cmd.Parameters["i_md_u_id"].Value = txtMD_U_ID.EditValue;
cmd.Parameters["i_md_u_id"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
finally
{
EfwSimpleButton1_Click(null, null);
}
MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
txtU_NAME1.EditValue = null;
txtU_NICKNAME1.EditValue = null;
txtUSER_ID1.EditValue = null;
txtBIRTH1.EditValue = null;
txtU_GENDER1.EditValue = null;
txtU_CELL_NUM1.EditValue = null;
txtU_EMAIL1.EditValue = null;
txtLOGIN_DATE1.EditValue = null;
txtREG_DATE1.EditValue = null;
txtU_ZIP1.EditValue = null;
txtU_ADDR1.EditValue = null;
txtU_ADDR_DETAIL1.EditValue = null;
cbDORAMD_TYPE.EditValue = null;
txtIDX1.EditValue = null;
txtREMARK.EditValue = null;
Eraser.Clear(this, "CLR2");
Open2();
}
}
public override IResponseMessageBase OnEvent_ClickRequest(RequestMessageEvent_Click requestMessage)
{
IResponseMessageBase reponseMessage = null;
//菜单点击，需要跟创建菜单时的Key匹配
switch (requestMessage.EventKey)
{
case "OneClick":
{
//这个过程实际已经在OnTextOrEventRequest中完成，这里不会执行到。
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了底部按钮。\r\n为了测试微信软件换行bug的应对措施，这里做了一个——\r\n换行";
}
break;
case "SubClickRoot_Text":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了子菜单按钮。";
}
break;
case "SubClickRoot_News":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Articles.Add(new Article()
{
Title = "您点击了子菜单图文按钮",
Description = "您点击了子菜单图文按钮，这是一条图文信息。",
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg",
Url = "http://sdk.weixin.senparc.com"
});
}
break;
case "SubClickRoot_Music":
{
//上传缩略图
var accessToken = Containers.AccessTokenContainer.TryGetAccessToken(appId, appSecret);
var uploadResult = AdvancedAPIs.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.thumb,
Server.GetMapPath("~/Images/Logo.jpg"));
//设置音乐信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageMusic>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Music.Title = "天籁之音";
strongResponseMessage.Music.Description = "真的是天籁之音";
strongResponseMessage.Music.MusicUrl = "http://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.HQMusicUrl = "http://sdk.weixin.senparc.com/Content/music1.mp3";
strongResponseMessage.Music.ThumbMediaId = uploadResult.thumb_media_id;
}
break;
case "SubClickRoot_Image":
{
//上传图片
var accessToken = Containers.AccessTokenContainer.TryGetAccessToken(appId, appSecret);
var uploadResult = AdvancedAPIs.MediaApi.UploadTemporaryMedia(accessToken, UploadMediaFileType.image,
Server.GetMapPath("~/Images/Logo.jpg"));
//设置图片信息
var strongResponseMessage = CreateResponseMessage <ResponseMessageImage>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Image.MediaId = uploadResult.media_id;
}
break;
case "SubClickRoot_Agent": //代理消息
{
//获取返回的XML
DateTime dt1 = DateTime.Now;
reponseMessage = MessageAgent.RequestResponseMessage(this, agentUrl, agentToken, RequestDocument.ToString());
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
DateTime dt2 = DateTime.Now;
if (reponseMessage is ResponseMessageNews)
{
(reponseMessage as ResponseMessageNews)
.Articles[0]
.Description += string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
}
}
break;
case "Member": //托管代理会员信息
{
//原始方法为：MessageAgent.RequestXml(this,agentUrl, agentToken, RequestDocument.ToString());//获取返回的XML
reponseMessage = this.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
}
break;
case "OAuth": //OAuth授权测试
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageNews>();
strongResponseMessage.Articles.Add(new Article()
{
Title = "OAuth2.0测试",
Description = "点击【查看全文】进入授权页面。\r\n注意：此页面仅供测试（是专门的一个临时测试账号的授权，并非Senparc.Weixin.MP SDK官方账号，所以如果授权后出现错误页面数正常情况），测试号随时可能过期。请将此DEMO部署到您自己的服务器上，并使用自己的appid和secret。",
Url = "http://sdk.weixin.senparc.com/oauth2",
PicUrl = "http://sdk.weixin.senparc.com/Images/qrcode.jpg"
});
reponseMessage = strongResponseMessage;
}
break;
case "Description":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = GetWelcomeInfo();
reponseMessage = strongResponseMessage;
}
break;
case "SubClickRoot_PicPhotoOrAlbum":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信拍照】按钮。系统将会弹出拍照或者相册发图。";
}
break;
case "SubClickRoot_ScancodePush":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了【微信扫码】按钮。";
}
break;
case "ConditionalMenu_Male":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：男。";
}
break;
case "ConditionalMenu_Femle":
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
reponseMessage = strongResponseMessage;
strongResponseMessage.Content = "您点击了个性化菜单按钮，您的微信性别设置为：女。";
}
break;
default:
{
var strongResponseMessage = CreateResponseMessage <ResponseMessageText>();
strongResponseMessage.Content = "您点击了按钮，EventKey：" + requestMessage.EventKey;
reponseMessage = strongResponseMessage;
}
break;
}
return(reponseMessage);
}
/// <summary>
/// 处理文字请求
/// </summary>
/// <param name="requestMessage">请求消息</param>
/// <returns></returns>
public override IResponseMessageBase OnTextRequest(RequestMessageText requestMessage)
{
//说明：实际项目中这里的逻辑可以交给Service处理具体信息，参考OnLocationRequest方法或/Service/LocationSercice.cs
#region 书中例子
//if (requestMessage.Content == "你好")
//{
// var responseMessage = base.CreateResponseMessage<ResponseMessageNews>();
// var title = "Title";
// var description = "Description";
// var picUrl = "PicUrl";
// var url = "Url";
// responseMessage.Articles.Add(new Article()
// {
// Title = title,
// Description = description,
// PicUrl = picUrl,
// Url = url
// });
// return responseMessage;
//}
//else if (requestMessage.Content == "Senparc")
//{
// //相似处理逻辑
//}
//else
//{
// //...
//}
#endregion
#region 历史方法
//方法一（v0.1），此方法调用太过繁琐，已过时（但仍是所有方法的核心基础），建议使用方法二到四
//var responseMessage =
// ResponseMessageBase.CreateFromRequestMessage(RequestMessage, ResponseMsgType.Text) as
// ResponseMessageText;
//方法二（v0.4）
//var responseMessage = ResponseMessageBase.CreateFromRequestMessage<ResponseMessageText>(RequestMessage);
//方法三（v0.4），扩展方法，需要using Senparc.Weixin.MP.Helpers;
//var responseMessage = RequestMessage.CreateResponseMessage<ResponseMessageText>();
//方法四（v0.6+），仅适合在HandlerMessage内部使用，本质上是对方法三的封装
//注意：下面泛型ResponseMessageText即返回给客户端的类型，可以根据自己的需要填写ResponseMessageNews等不同类型。
#endregion
var defaultResponseMessage = base.CreateResponseMessage <ResponseMessageText>();
var requestHandler =
requestMessage.StartHandler()
//关键字不区分大小写，按照顺序匹配成功后将不再运行下面的逻辑
.Keyword("约束", () =>
{
defaultResponseMessage.Content =
@"您正在进行微信内置浏览器约束判断测试。您可以：
<a href=""https://sdk.weixin.senparc.com/FilterTest/"">点击这里</a>进行客户端约束测试（地址：https://sdk.weixin.senparc.com/FilterTest/），如果在微信外打开将直接返回文字。
或：
<a href=""https://sdk.weixin.senparc.com/FilterTest/Redirect"">点击这里</a>进行客户端约束测试（地址：https://sdk.weixin.senparc.com/FilterTest/Redirect），如果在微信外打开将重定向一次URL。";
return(defaultResponseMessage);
}).
//匹配任一关键字
Keywords(new[] { "托管", "代理" }, () =>
{
//开始用代理托管，把请求转到其他服务器上去，然后拿回结果
//甚至也可以将所有请求在DefaultResponseMessage()中托管到外部。
var dt1 = SystemTime.Now; //计时开始
var agentXml = RequestDocument.ToString();
#region 暂时转发到SDK线上Demo
agentUrl = "https://sdk.weixin.senparc.com/weixin";
//agentToken = WebConfigurationManager.AppSettings["WeixinToken"];//Token
//修改内容，防止死循环
var agentDoc = XDocument.Parse(agentXml);
agentDoc.Root.Element("Content").SetValue("代理转发文字：" + requestMessage.Content);
agentDoc.Root.Element("CreateTime").SetValue(DateTimeHelper.GetUnixDateTime(SystemTime.Now)); //修改时间，防止去重
agentDoc.Root.Element("MsgId").SetValue("123"); //防止去重
agentXml = agentDoc.ToString();
#endregion
var responseXml = MessageAgent.RequestXml(this, agentUrl, agentToken, agentXml);
//获取返回的XML
//上面的方法也可以使用扩展方法：this.RequestResponseMessage(this,agentUrl, agentToken, RequestDocument.ToString());
/* 如果有WeiweihiKey，可以直接使用下面的这个MessageAgent.RequestWeiweihiXml()方法。
* WeiweihiKey专门用于对接www.weiweihi.com平台，获取方式见：https://www.weiweihi.com/ApiDocuments/Item/25#51
*/
//var responseXml = MessageAgent.RequestWeiweihiXml(weiweihiKey, RequestDocument.ToString());//获取Weiweihi返回的XML
var dt2 = SystemTime.Now; //计时结束
//转成实体。
/* 如果要写成一行，可以直接用：
* responseMessage = MessageAgent.RequestResponseMessage(agentUrl, agentToken, RequestDocument.ToString());
* 或
*
*/
var msg = string.Format("\r\n\r\n代理过程总耗时：{0}毫秒", (dt2 - dt1).Milliseconds);
var agentResponseMessage = responseXml.CreateResponseMessage(this.MessageEntityEnlightener);
if (agentResponseMessage is ResponseMessageText)
{
(agentResponseMessage as ResponseMessageText).Content += msg;
}
else if (agentResponseMessage is ResponseMessageNews)
{
(agentResponseMessage as ResponseMessageNews).Articles[0].Description += msg;
}
return(agentResponseMessage); //可能出现多种类型，直接在这里返回
})
.Keywords(new[] { "测试", "退出" }, () =>
{
/*
* 这是一个特殊的过程，此请求通常来自于微微嗨（http://www.weiweihi.com）的“盛派网络小助手”应用请求（https://www.weiweihi.com/User/App/Detail/1），
* 用于演示微微嗨应用商店的处理过程，由于微微嗨的应用内部可以单独设置对话过期时间，所以这里通常不需要考虑对话状态，只要做最简单的响应。
*/
if (defaultResponseMessage.Content == "测试")
{
//进入APP测试
defaultResponseMessage.Content = "您已经进入【盛派网络小助手】的测试程序，请发送任意信息进行测试。发送文字【退出】退出测试对话。10分钟内无任何交互将自动退出应用对话状态。";
}
else
{
//退出APP测试
defaultResponseMessage.Content = "您已经退出【盛派网络小助手】的测试程序。";
}
return(defaultResponseMessage);
})
.Keyword("AsyncTest", () =>
{
//异步并发测试（提供给单元测试使用）
#if NET45
var begin = SystemTime.Now;
int t1, t2, t3;
System.Threading.ThreadPool.GetAvailableThreads(out t1, out t3);
System.Threading.ThreadPool.GetMaxThreads(out t2, out t3);
System.Threading.Thread.Sleep(TimeSpan.FromSeconds(4));
var end = SystemTime.Now;
var thread = System.Threading.Thread.CurrentThread;
defaultResponseMessage.Content = string.Format("TId:{0}\tApp:{1}\tBegin:{2:mm:ss,ffff}\tEnd:{3:mm:ss,ffff}\tTPool：{4}",
thread.ManagedThreadId,
HttpContext.Current != null ? HttpContext.Current.ApplicationInstance.GetHashCode() : -1,
begin,
end,
t2 - t1
);
#endif
return(defaultResponseMessage);
})
.Keyword("OPEN", () =>
{
var openResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageNews>();
openResponseMessage.Articles.Add(new Article()
{
Title = "开放平台微信授权测试！",
Description = @"点击进入Open授权页面。
授权之后，您的微信所收到的消息将转发到第三方（盛派网络小助手）的服务器上，并获得对应的回复。
测试完成后，您可以登陆公众号后台取消授权。",
Url = "https://sdk.weixin.senparc.com/OpenOAuth/JumpToMpOAuth"
});
return(openResponseMessage);
})
.Keyword("错误", () =>
{
var errorResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
//因为没有设置errorResponseMessage.Content，所以这小消息将无法正确返回。
return(errorResponseMessage);
})
.Keyword("容错", () =>
{
Thread.Sleep(4900); //故意延时1.5秒，让微信多次发送消息过来，观察返回结果
var faultTolerantResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
faultTolerantResponseMessage.Content = string.Format("测试容错，MsgId：{0}，Ticks：{1}", requestMessage.MsgId,
SystemTime.Now.Ticks);
return(faultTolerantResponseMessage);
})
.Keyword("TM", () =>
{
var openId = requestMessage.FromUserName;
var checkCode = Guid.NewGuid().ToString("n").Substring(0, 3); //为了防止openId泄露造成骚扰，这里启用验证码
TemplateMessageCollection[checkCode] = openId;
defaultResponseMessage.Content = string.Format(@"新的验证码为：{0}，请在网页上输入。网址：https://sdk.weixin.senparc.com/AsyncMethods", checkCode);
return(defaultResponseMessage);
})
.Keyword("OPENID", () =>
{
var openId = requestMessage.FromUserName; //获取OpenId
var userInfo = UserApi.Info(appId, openId, Language.zh_CN);
defaultResponseMessage.Content = string.Format(
"您的OpenID为：{0}\r\n昵称：{1}\r\n性别：{2}\r\n地区（国家/省/市）：{3}/{4}/{5}\r\n关注时间：{6}\r\n关注状态：{7}",
requestMessage.FromUserName, userInfo.nickname, (WeixinSex)userInfo.sex, userInfo.country, userInfo.province, userInfo.city, DateTimeHelper.GetDateTimeFromXml(userInfo.subscribe_time), userInfo.subscribe);
return(defaultResponseMessage);
})
.Keyword("EX", () =>
{
var ex = new WeixinException("openid:" + requestMessage.FromUserName + ":这是一条测试异常信息"); //回调过程在global的ConfigWeixinTraceLog()方法中
defaultResponseMessage.Content = "请等待异步模板消息发送到此界面上（自动延时数秒）。\r\n当前时间：" + SystemTime.Now.ToString();
return(defaultResponseMessage);
})
.Keyword("MUTE", () => //不回复任何消息
{
//方案一：
return(new SuccessResponseMessage());
//方案二：
var muteResponseMessage = base.CreateResponseMessage <ResponseMessageNoResponse>();
return(muteResponseMessage);
//方案三：
base.TextResponseMessage = "success";
return(null);
//方案四：
return(null); //在 Action 中结合使用 return new FixWeixinBugWeixinResult(messageHandler);
})
.Keyword("JSSDK", () =>
{
defaultResponseMessage.Content = "点击打开：https://sdk.weixin.senparc.com/WeixinJsSdk";
return(defaultResponseMessage);
})
//选择菜单，关键字：101（微信服务器端最终格式：id="s:101",content="满意"）
.SelectMenuKeyword("101", () =>
{
defaultResponseMessage.Content = $"感谢您的评价（{requestMessage.Content}）！我们会一如既往为提高企业和开发者生产力而努力！";
return(defaultResponseMessage);
})
//选择菜单，关键字：102（微信服务器端最终格式：id="s:102",content="一般"）
.SelectMenuKeyword("102", () =>
{
defaultResponseMessage.Content = $"感谢您的评价（{requestMessage.Content}）！希望我们的服务能让您越来越满意！";
return(defaultResponseMessage);
})
//选择菜单，关键字：103（微信服务器端最终格式：id="s:103",content="不满意"）
.SelectMenuKeyword("103", () =>
{
defaultResponseMessage.Content = $"感谢您的评价（{requestMessage.Content}）！我们需要您的意见或建议，欢迎向我们反馈！ <a href=\"https://github.com/JeffreySu/WeiXinMPSDK/issues/new\">点击这里</a>";
return(defaultResponseMessage);
})
.SelectMenuKeywords(new[] { "110", "111" }, () =>
{
defaultResponseMessage.Content = $"这里只是演示，可以同时支持多个选择菜单";
return(defaultResponseMessage);
})
//Default不一定要在最后一个
.Default(() =>
{
var result = new StringBuilder();
result.AppendFormat("您刚才发送了文字信息：{0}\r\n\r\n", requestMessage.Content);
if (CurrentMessageContext.RequestMessages.Count > 1)
{
result.AppendFormat("您刚才还发送了如下消息（{0}/{1}）：\r\n", CurrentMessageContext.RequestMessages.Count,
CurrentMessageContext.StorageData);
for (int i = CurrentMessageContext.RequestMessages.Count - 2; i >= 0; i--)
{
var historyMessage = CurrentMessageContext.RequestMessages[i];
result.AppendFormat("{0} 【{1}】{2}\r\n",
historyMessage.CreateTime.ToString("HH:mm:ss"),
historyMessage.MsgType.ToString(),
(historyMessage is RequestMessageText)
? (historyMessage as RequestMessageText).Content
: "[非文字类型]"
);
}
result.AppendLine("\r\n");
}
result.AppendFormat("如果您在{0}分钟内连续发送消息，记录将被自动保留（当前设置：最多记录{1}条）。过期后记录将会自动清除。\r\n",
GlobalMessageContext.ExpireMinutes, GlobalMessageContext.MaxRecordCount);
result.AppendLine("\r\n");
result.AppendLine(
"您还可以发送【位置】【图片】【语音】【视频】等类型的信息（注意是这几种类型，不是这几个文字），查看不同格式的回复。\r\nSDK官方地址：https://sdk.weixin.senparc.com");
defaultResponseMessage.Content = result.ToString();
return(defaultResponseMessage);
})
//“一次订阅消息”接口测试
.Keyword("订阅", () =>
{
defaultResponseMessage.Content = "点击打开：https://sdk.weixin.senparc.com/SubscribeMsg";
return(defaultResponseMessage);
})
//正则表达式
.Regex(@"^\d+#\d+$", () =>
{
defaultResponseMessage.Content = string.Format("您输入了：{0}，符合正则表达式：^\\d+#\\d+$", requestMessage.Content);
return(defaultResponseMessage);
});
return(requestHandler.GetResponseMessage() as IResponseMessageBase);
}
private void efwSimpleButton5_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtgshop_id.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "G 멀티샵을 선택하세요");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM_RM04_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
//
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txtidx.EditValue);
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_gshop_id", MySqlDbType.Int32));
cmd.Parameters["i_gshop_id"].Value = Convert.ToInt32(txtgshop_id.EditValue);
cmd.Parameters["i_gshop_id"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_img_url", MySqlDbType.VarChar));
cmd.Parameters["i_img_url"].Value = txtimg_url.EditValue;
cmd.Parameters["i_img_url"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_input_cause", MySqlDbType.VarChar));
cmd.Parameters["i_input_cause"].Value = txtinput_cause.EditValue;
cmd.Parameters["i_input_cause"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_customer_reaction", MySqlDbType.VarChar));
cmd.Parameters["i_customer_reaction"].Value = txtcustomer_reaction.EditValue;
cmd.Parameters["i_customer_reaction"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_good_writing", MySqlDbType.VarChar));
cmd.Parameters["i_good_writing"].Value = txtgood_writing.EditValue;
cmd.Parameters["i_good_writing"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_show_type", MySqlDbType.VarChar));
cmd.Parameters["i_show_type"].Value = rbshow_type.EditValue;
cmd.Parameters["i_show_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.Int32));
cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtidx.EditValue = cmd.Parameters["o_idx"].Value.ToString();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Search();
}
}
private void Open1()
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_DN_DN01_SELECT_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_id", MySqlDbType.Int32));
cmd.Parameters["i_id"].Value = Convert.ToInt32(txtID.EditValue);
cmd.Parameters["i_id"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_o_type", MySqlDbType.VarChar));
cmd.Parameters["o_o_type"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_code", MySqlDbType.VarChar));
cmd.Parameters["o_o_code"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_u_name", MySqlDbType.VarChar));
cmd.Parameters["o_u_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_zipcode", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_zipcode"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_address", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_address"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_name", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_contact", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_contact"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_message", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_message"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_zipcode1", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_zipcode1"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_address1", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_address1"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_name1", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_name1"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_contact1", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_contact1"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_receive_message1", MySqlDbType.VarChar));
cmd.Parameters["o_o_receive_message1"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_total_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_total_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_delivery_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_delivery_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_donut_d_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_donut_d_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_donut_s_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_donut_s_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_donut_g_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_donut_g_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_donut_c_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_donut_c_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_purchase_cost", MySqlDbType.Int32));
cmd.Parameters["o_o_purchase_cost"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_deposit_confirm_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_deposit_confirm_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_cancel_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_cancel_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_complete_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_complete_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_return_success_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_return_success_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_remark", MySqlDbType.VarChar));
cmd.Parameters["o_remark"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_return_reason_detail", MySqlDbType.VarChar));
cmd.Parameters["o_o_return_reason_detail"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_code", MySqlDbType.VarChar));
cmd.Parameters["o_p_code"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_name", MySqlDbType.VarChar));
cmd.Parameters["o_p_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_p_id", MySqlDbType.Int32));
cmd.Parameters["o_p_p_id"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_pp_title", MySqlDbType.VarChar));
cmd.Parameters["o_pp_title"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_num", MySqlDbType.Int32));
cmd.Parameters["o_p_num"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_price", MySqlDbType.Int32));
cmd.Parameters["o_p_price"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_response_code", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_response_code"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_response_msg", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_response_msg"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_amount", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_amount"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_tid", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_tid"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_paytype", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_paytype"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_paydate", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_paydate"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_financecode", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_financecode"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_financename", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_financename"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_accountnum", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_accountnum"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_accountowner", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_accountowner"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_payer", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_payer"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_castamount", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_castamount"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_cascamount", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_cascamount"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_casflag", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_casflag"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_casseqno", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_casseqno"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_lgd_saowner", MySqlDbType.VarChar));
cmd.Parameters["o_lgd_saowner"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_delivery_num", MySqlDbType.VarChar));
cmd.Parameters["o_o_delivery_num"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_delivery_comp_name", MySqlDbType.VarChar));
cmd.Parameters["o_o_delivery_comp_name"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_delivery_start_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_delivery_start_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_delivery_end_date", MySqlDbType.DateTime));
cmd.Parameters["o_o_delivery_end_date"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_p_id", MySqlDbType.VarChar));
cmd.Parameters["o_p_id"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_chk_type", MySqlDbType.VarChar));
cmd.Parameters["o_chk_type"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_o_mcode", MySqlDbType.VarChar));
cmd.Parameters["o_o_mcode"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtO_Type.EditValue = cmd.Parameters["o_o_type"].Value.ToString();
txtO_Code.EditValue = cmd.Parameters["o_o_code"].Value.ToString();
txtU_Name.EditValue = cmd.Parameters["o_u_name"].Value.ToString();
dtO_Date.EditValue = cmd.Parameters["o_o_date"].Value.ToString();
txtO_Receive_ZipCode.EditValue = cmd.Parameters["o_o_receive_zipcode"].Value.ToString();
txtO_Receive_Address.EditValue = cmd.Parameters["o_o_receive_address"].Value.ToString();
txtO_Receive_Name.EditValue = cmd.Parameters["o_o_receive_name"].Value.ToString();
txtO_Receive_Contact.EditValue = cmd.Parameters["o_o_receive_contact"].Value.ToString();
txtO_Receive_Message.EditValue = cmd.Parameters["o_o_receive_message"].Value.ToString();
txtO_Receive_ZipCode1.EditValue = cmd.Parameters["o_o_receive_zipcode1"].Value.ToString();
txtO_Receive_Address1.EditValue = cmd.Parameters["o_o_receive_address1"].Value.ToString();
txtO_Receive_Name1.EditValue = cmd.Parameters["o_o_receive_name1"].Value.ToString();
txtO_Receive_Contact1.EditValue = cmd.Parameters["o_o_receive_contact1"].Value.ToString();
txtO_Receive_Message1.EditValue = cmd.Parameters["o_o_receive_message1"].Value.ToString();
txtO_Total_Cost.EditValue = cmd.Parameters["o_o_total_cost"].Value.ToString();
txtO_Delivery_Cost.EditValue = cmd.Parameters["o_o_delivery_cost"].Value.ToString();
txtO_Donut_D_Cost.EditValue = cmd.Parameters["o_o_donut_d_cost"].Value.ToString();
txtO_Donut_S_Cost.EditValue = cmd.Parameters["o_o_donut_s_cost"].Value.ToString();
txtO_Donut_G_Cost.EditValue = cmd.Parameters["o_o_donut_g_cost"].Value.ToString();
txtO_Donut_C_Cost.EditValue = cmd.Parameters["o_o_donut_c_cost"].Value.ToString();
txtO_Purchase_Cost.EditValue = cmd.Parameters["o_o_purchase_cost"].Value.ToString();
txtO_Deposit_Confirm_Date.EditValue = cmd.Parameters["o_o_deposit_confirm_date"].Value.ToString();
txtO_Cancel_Date.EditValue = cmd.Parameters["o_o_cancel_date"].Value.ToString();
txtO_Complete_Date.EditValue = cmd.Parameters["o_o_complete_date"].Value.ToString();
txtO_Return_Success_Date.EditValue = cmd.Parameters["o_o_return_success_date"].Value.ToString();
txtRemark.EditValue = cmd.Parameters["o_remark"].Value.ToString();
txtO_Return_Reason_Detail.EditValue = cmd.Parameters["o_o_return_reason_detail"].Value.ToString();
txtP_Code.EditValue = cmd.Parameters["o_p_code"].Value.ToString();
txtP_Name.EditValue = cmd.Parameters["o_p_name"].Value.ToString();
txtP_P_Id.EditValue = cmd.Parameters["o_p_p_id"].Value.ToString();
txtPP_Title.EditValue = cmd.Parameters["o_pp_title"].Value.ToString();
txtP_num.EditValue = cmd.Parameters["o_p_num"].Value.ToString();
txtP_Price.EditValue = cmd.Parameters["o_p_price"].Value.ToString();
txtLGD_Response_Code.EditValue = cmd.Parameters["o_lgd_response_code"].Value.ToString();
txtLGD_Response_Msg.EditValue = cmd.Parameters["o_lgd_response_msg"].Value.ToString();
txtLGD_Amount.EditValue = cmd.Parameters["o_lgd_amount"].Value.ToString();
txtLGD_Tid.EditValue = cmd.Parameters["o_lgd_tid"].Value.ToString();
txtLGD_PayType.EditValue = cmd.Parameters["o_lgd_paytype"].Value.ToString();
txtLGD_PayDate.EditValue = cmd.Parameters["o_lgd_paydate"].Value.ToString();
txtLGD_FinanceCode.EditValue = cmd.Parameters["o_lgd_financecode"].Value.ToString();
txtLGD_FinanceName.EditValue = cmd.Parameters["o_lgd_financename"].Value.ToString();
txtLGD_AccountNum.EditValue = cmd.Parameters["o_lgd_accountnum"].Value.ToString();
txtLGD_AccountOwner.EditValue = cmd.Parameters["o_lgd_accountowner"].Value.ToString();
txtLGD_Payer.EditValue = cmd.Parameters["o_lgd_payer"].Value.ToString();
txtLGD_CastAmount.EditValue = cmd.Parameters["o_lgd_castamount"].Value.ToString();
txtLGD_CascAmount.EditValue = cmd.Parameters["o_lgd_cascamount"].Value.ToString();
txtLGD_CasFlag.EditValue = cmd.Parameters["o_lgd_casflag"].Value.ToString();
txtLGD_CasseqNo.EditValue = cmd.Parameters["o_lgd_casseqno"].Value.ToString();
txtLGD_SaOwner.EditValue = cmd.Parameters["o_lgd_saowner"].Value.ToString();
txtO_Delivery_Num.EditValue = cmd.Parameters["o_o_delivery_num"].Value.ToString();
txtO_Delivery_Comp_Name.EditValue = cmd.Parameters["o_o_delivery_comp_name"].Value.ToString();
txtO_Delivery_Start_Date.EditValue = cmd.Parameters["o_o_delivery_start_date"].Value.ToString();
txtO_Delivery_End_Date.EditValue = cmd.Parameters["o_o_delivery_end_date"].Value.ToString();
txtP_ID.EditValue = cmd.Parameters["o_p_id"].Value.ToString();
txtchk_type.EditValue = cmd.Parameters["o_chk_type"].Value.ToString();
txto_mcode.EditValue = cmd.Parameters["o_o_mcode"].Value.ToString();
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void efwSimpleButton1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtidx.Text))
{
MessageAgent.MessageShow(MessageType.Warning, "G 멀티샵을 선택 또는 기본 정보를 저장하세요 !");
return;
}
if (string.IsNullOrEmpty(this.dtS_DATE.Text))
{
dtS_DATE.EditValue = DateTime.Now;
}
if (string.IsNullOrEmpty(this.dtE_DATE.Text))
{
dtE_DATE.EditValue = DateTime.Now;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM_RM04_SAVE_02", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
//
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txtD_idx.EditValue);
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_master_idx", MySqlDbType.Int32));
cmd.Parameters["i_master_idx"].Value = Convert.ToInt32(txtidx.EditValue);
cmd.Parameters["i_master_idx"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_bef_url", MySqlDbType.VarChar));
cmd.Parameters["i_bef_url"].Value = txtbef_url.EditValue;
cmd.Parameters["i_bef_url"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_bef_date", MySqlDbType.Datetime));
cmd.Parameters["i_bef_date"].Value = dtS_DATE.EditValue;
cmd.Parameters["i_bef_date"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_after_url", MySqlDbType.VarChar));
cmd.Parameters["i_after_url"].Value = txtafter_url.EditValue;
cmd.Parameters["i_after_url"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_after_date", MySqlDbType.VarChar));
cmd.Parameters["i_after_date"].Value = dtE_DATE.EditValue3;
cmd.Parameters["i_after_date"].Direction = ParameterDirection.Input;
//
cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
cmd.Parameters["i_remark"].Value = txtremark.EditValue;
cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_Dshow_type", MySqlDbType.VarChar));
cmd.Parameters["i_Dshow_type"].Value = rbDshow_type.EditValue;
cmd.Parameters["i_Dshow_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.Int32));
cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
txtD_idx.EditValue = cmd.Parameters["o_idx"].Value.ToString();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Open1();
}
}
private void efwSimpleButton7_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txt_work_man.Text))
{
MessageAgent.MessageShow(MessageType.Warning, " 처리할 권한이 없습니다!");
return;
}
if (MessageAgent.MessageShow(MessageType.Confirm, "삭제 하시겠습니까?") == DialogResult.OK)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConstantLib.TelConn_Real))
{
using (MySqlCommand cmd = new MySqlCommand("erp.USP_TM_TM04_SAVE_01", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("i_proc_type", MySqlDbType.VarChar));
cmd.Parameters["i_proc_type"].Value = "D";
cmd.Parameters["i_proc_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
cmd.Parameters["i_idx"].Value = Convert.ToInt32(txt_idx.EditValue);
cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_visit_date", MySqlDbType.Datetime));
cmd.Parameters["i_visit_date"].Value = dt_visit_date.EditValue;
cmd.Parameters["i_visit_date"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_work_man", MySqlDbType.VarChar));
cmd.Parameters["i_work_man"].Value = txt_work_man.EditValue;
cmd.Parameters["i_work_man"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_agency_name", MySqlDbType.VarChar));
cmd.Parameters["i_agency_name"].Value = txt_agency_name.EditValue;
cmd.Parameters["i_agency_name"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_person", MySqlDbType.VarChar));
cmd.Parameters["i_person"].Value = txt_person.EditValue;
cmd.Parameters["i_person"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_advice_type", MySqlDbType.VarChar));
cmd.Parameters["i_advice_type"].Value = cmb_advice_type.EditValue;
cmd.Parameters["i_advice_type"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_plan_date", MySqlDbType.Datetime));
cmd.Parameters["i_plan_date"].Value = dt_plan_date.EditValue;
cmd.Parameters["i_plan_date"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_hp_no", MySqlDbType.VarChar));
cmd.Parameters["i_hp_no"].Value = txt_hp_no.EditValue;
cmd.Parameters["i_hp_no"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_tel_no", MySqlDbType.VarChar));
cmd.Parameters["i_tel_no"].Value = txt_tel_no.EditValue;
cmd.Parameters["i_tel_no"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_e_mail", MySqlDbType.VarChar));
cmd.Parameters["i_e_mail"].Value = txt_e_mail.EditValue;
cmd.Parameters["i_e_mail"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_visit_area", MySqlDbType.VarChar));
cmd.Parameters["i_visit_area"].Value = txt_visit_area.EditValue;
cmd.Parameters["i_visit_area"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_visit_distant", MySqlDbType.Int32));
cmd.Parameters["i_visit_distant"].Value = Convert.ToInt32(txt_visit_distant.EditValue);
cmd.Parameters["i_visit_distant"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_content", MySqlDbType.VarChar));
cmd.Parameters["i_content"].Value = txt_content.EditValue;
cmd.Parameters["i_content"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
cmd.Parameters["i_remark"].Value = txt_remark.EditValue;
cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar));
cmd.Parameters["o_Return"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString());
}
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
Search();
}
}
/// <summary>
/// Constructs a response queue using the specified message agent.
/// </summary>
/// <param name="agent">
/// The message agent to associate with this queue.
/// </param>
internal LdapResponseQueue(MessageAgent agent)
: base("LdapResponseQueue", agent)
{
}
