@H_301_0@如图所示，点击新增，弹出如图的弹出框，点击取消不保存页面信息，点击确定保存页面信息
//弹窗取消按钮
$("#popup_cancel2").click(function () {
$("#popup_container").hide();
$("#popup_overlay").hide();
});
$("#popup_ok2").click(function () {
$("#popup_container").hide();
$("#popup_overlay").hide();
var keys = $("[tag='txtNum01']"),values = $("[tag='txtNum02']"),precent = $("[tag='txtPercent']"),len = keys.length,result = [],txt = "";
for (var i = 0; i < len; i++) {
txt += keys.eq(i).val() + "," + values.eq(i).val() + "," + precent.eq(i).val() + ";";
}
var contractName = $("#txtContractName").val();
var hid = $("#hidValue").val();
var startTime = $("#txtCStartTime").val();
var endTime = $("#txtCEndTime").val();
// var pic = $("#HiddenField2").val();
var fileUpload = $("#fileID").get(0);
var files = fileUpload.files;
//IE8以及以上浏览器
var data = new FormData();
for (var i = 0; i < files.length; i++) {
data.append(files[i].name,files[i]);
}
data.append("txt",txt);
data.append("contractName",contractName);
data.append("hid",hid);
data.append("startTime",startTime);
data.append("endTime",endTime);
$.ajax({
//url: "AgentEditSP.aspx/GetData",url: "../Handler/FileAll.ashx",type: "Post",//data: "{'txt':'" + txt + "','contractName':'" + contractName + "','hid':'" + hid + "','startTime':'" + startTime + "','endTime':'" + endTime + "','pic':'" + pic + "'}",data:data,contentType: false,processData: false,success: function (data) {
alert("操作成功");
location.href = location.href;
},error: function (err) {
alert(err);
}
});});
});
{
var filenames = "";
HttpFileCollection files = context.Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFile file = files[i];
filenames =file.FileName;
pic = filenames;
string fname = context.Server.MapPath("~/Content/Exploitation/" + file.FileName);
file.SaveAs(fname);
}}
// 向ContractDetailSP表插入数据
if (!string.IsNullOrEmpty(txt) && !string.IsNullOrEmpty(contractName) && !string.IsNullOrEmpty(startTime) && !string.IsNullOrEmpty(endTime))
{
if (IsExistAgentName(hid) == 0)//判断代理是否存在
{
Model.ContractDetailSP condSP = new Model.ContractDetailSP();
condSP.ZID = int.Parse(hid);
condSP.Name = GetAgentName(hid);
condSP.ParentId = -1;
var insertTableName = DB.Context.Insert<Model.ContractDetailSP>(condSP);
}
if (IsExistContractID(IsExistAgentName(hid),contractName) == 0)//判断合同是否存在
{
Model.ContractDetailSP condSP = new Model.ContractDetailSP();
condSP.Name = contractName;
condSP.StartTime = DateTime.Parse(startTime);
condSP.EndTime = DateTime.Parse(endTime);
condSP.ParentId = IsExistAgentName(hid);
condSP.ContractPic = pic;
var insertTableName = DB.Context.Insert<Model.ContractDetailSP>(condSP);
}
string[] strrList = txt.Split(';');
foreach (var item in strrList)
{
string[] templist = item.Split(',');
if (templist.Length > 1)
{
Model.ContractDetailSP condSP = new Model.ContractDetailSP();
condSP.Num1 = int.Parse(templist[0].ToString());
condSP.Num2 = int.Parse(templist[1].ToString());
condSP.PercentNum = decimal.Parse(templist[2].ToString());
condSP.ParentId = IsExistContractID(IsExistAgentName(hid),contractName);
var insertTableNum = DB.Context.Insert<Model.ContractDetailSP>(condSP);
}
}
context.Response.ContentType = "text/plain";
context.Response.Write("ok");
}
else
{
//return "请填写完必填项";
context.Response.Write("notall");
}}
public bool IsReusable
{
get
{
return false;
}
}
private static int IsExistAgentName(string agendID)
{//select id from ContractDetailSP where AgentID=2123
int str = 0;
var isexist = DB.Context.From<Model.ContractDetailSP>()
.Select(a => a.Id)
.Where(a => a.ZID == int.Parse(agendID)).ToList();
if (isexist.Count < 1)
{
str = 0;
}
else
{
foreach (var item in isexist)
{
str = item.Id;
}
}
return str;
}
private static int IsExistContractID(int id,string contractName)
{//select id from ContractDetailSP where ParentId='' and Name=''
int str = 0;
var isexist = DB.Context.From<Model.ContractDetailSP>()
.Select(a => a.Id)
.Where(a => a.ParentId == id && a.Name == contractName).ToList();
if (isexist.Count < 1)
{
str = 0;
}
else
{
foreach (var item in isexist)
{
str = item.Id;
}
}
return str;
}
private static string GetAgentName(string hid)
{//select name,* from tblAgent
string str = string.Empty;
var agent = DB.Context.From<Model.tblAgent>().Select(a => a.name)
.Where(a => a.AgentID == int.Parse(hid)).ToList();
foreach (var item in agent)
{
str = item.name;
}
return str;
}
