public static string EditIssue(Member_Issue issuemodel, string actchecked)
{
try
{
var issueid = new MemberIssueData().InsertOrUpdate(issuemodel);
var delissueact = new MemberIssueActivityData().DelIssueIdByIssueId(issueid);
string[] actgroup = actchecked.Split(',');
for (int i = 0; i < actgroup.Length; i++)
{
Member_Issue_Activity act = new Member_Issue_Activity()
{
Id = 0,
ISid = issueid,
Acid = int.Parse(actgroup[i])
};
var issueactid = new MemberIssueActivityData().InsertOrUpdate(act);
}
return(JsonConvert.SerializeObject(new { type = 100, msg = issueid }));
}
catch
{
new SqlHelper().Dispose();
throw;
}
}
public int InsertOrUpdate(Member_Issue issuemodel)
{
using (var helper = new SqlHelper())
{
var id = new InternalMemberIssue(helper).InsertOrUpdate(issuemodel);
return(id);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string oper = context.Request["oper"].ConvertTo <string>("");
if (oper != "")
{
if (oper == "editissue")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
string pubtitle = context.Request["pubtitle"];
int channelid = context.Request["channelid"].ConvertTo <int>(0);
int cardid = context.Request["cardid"].ConvertTo <int>(0);
int num = context.Request["num"].ConvertTo <int>(0);
string actchecked = context.Request["actchecked"];
var isopen1 = context.Request["isopen"];
bool isopen = context.Request["isopen"].ConvertTo <string>("true") == "true" ? true : false;
int openaddress = context.Request["openaddress"].ConvertTo <int>(0);
int comid = context.Request["comid"].ConvertTo <int>(0);
Member_Issue issuemodel = new Member_Issue()
{
Id = issueid,
Chid = channelid,
Crid = cardid,
Num = num,
Com_id = comid,
Openyes = isopen,
Openaddress = openaddress,
Title = pubtitle
};
string data = IssueJsonDate.EditIssue(issuemodel, actchecked);
context.Response.Write(data);
}
if (oper == "GetIssueDetailById")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
string data = IssueJsonDate.GetIssueDetailById(issueid);
context.Response.Write(data);
}
if (oper == "GetIssueDetail2")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
string data = IssueJsonDate.GetIssueDetail2(issueid);
context.Response.Write(data);
}
if (oper == "GetIssuePromot")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
string data = IssueJsonDate.GetIssuePromot(issueid);
context.Response.Write(data);
}
if (oper == "pagelist")
{
var comid = context.Request["comid"];
var pageindex = context.Request["pageindex"].ConvertTo <int>(0);
var pagesize = context.Request["pagesize"].ConvertTo <int>(10);
string data = IssueJsonDate.PageList(comid, pageindex, pagesize);
context.Response.Write(data);
}
if (oper == "entercardnumber")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
//var carddd = context.Request["cardnumber"];
decimal cardnumber = context.Request["cardnumber"].ConvertTo <decimal>(0);
int comid = context.Request["comid"].ConvertTo <int>(0);
string data = IssueJsonDate.EnterCardNumber(issueid, cardnumber, comid);
context.Response.Write(data);
}
if (oper == "batchentercardnumber")
{
int issueid = context.Request["issueid"].ConvertTo <int>(0);
decimal numberbegin = context.Request["numberbegin"].ConvertTo <decimal>(0);
decimal numberend = context.Request["numberend"].ConvertTo <decimal>(0);
int comid = context.Request["comid"].ConvertTo <int>(0);
bool ignoreentered = context.Request["ignoreentered"].ConvertTo <bool>(false);
string data = IssueJsonDate.BatchEnterCardNumber(issueid, numberbegin, numberend, comid, ignoreentered);
//string data = IssueJsonDate.EnterCardNumber(issueid, numberbegin, comid);
context.Response.Write(data);
}
}
}
/// <summary>
/// 公用录入单卡号方法 result:录入成功返回cardid，错误返回错误原因
/// </summary>
/// <returns></returns>
public static bool CommonEnterCardNumber(int issueid, decimal cardnumber, int comid, out string result, Member_Issue issue)
{
Member_Card cardinfo = new MemberCardData().GetCardByCardNumber(cardnumber);
//判断卡号是否存在属于此次发行的卡片类型
int cardtype = cardinfo.Crid;
int issuecardtype = issue.Crid;
if (cardtype != issuecardtype)
{
result = "输入的卡号所属类型和发行需要的卡号类型不相符";
return(false);
}
Member_Channel channel = new MemberChannelData().GetChannelDetail(issue.Chid);
List <Member_Issue_Activity> actlist = new MemberIssueActivityData().GetIssuePromot(issueid);
try
{
var upMemberCardd = new MemberCardData().UPChannelCardCode(channel.Id, cardnumber, issueid);//更改生成卡号表中卡号所属渠道的id和发行id
foreach (Member_Issue_Activity issueact in actlist)
{
Member_Card_Activity cardactinfo = new MemberCardActivityData().GetCardActInfo(cardinfo.Id, issueact.Acid);
//防止一张卡重复录入同一次活动
if (cardactinfo == null)
{
Member_Card_Activity cardact = new Member_Card_Activity()
{
Id = 0,
ACTID = issueact.Acid,
Actnum = 1,
CardID = cardinfo.Id,
USEstate = (int)MemberCardUserState.NotUse,
USEsubdate = DateTime.Parse("1900-01-01")
};
var insertcardact = new MemberCardActivityData().EditMemberCardActivity(cardact);
}
}
result = upMemberCardd.ToString();
return(true);
}
catch (Exception ex)
{
new SqlHelper().Dispose();
result = "意外错误";
return(false);
throw;
}
}