private string validaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessCustInfo bc = new project.Business.Base.BusinessCustInfo();
bc.load(jp.getValue("id"));
bc.Entity.Valid = !bc.Entity.Valid;
int r = bc.valid();
if (r <= 0)
{
flag = "2";
}
if (bc.Entity.Valid)
{
collection.Add(new JsonStringValue("stat", "<span class=\"label label-success radius\">有效</span>"));
}
else
{
collection.Add(new JsonStringValue("stat", "<span class=\"label radius\">已失效</span>"));
}
collection.Add(new JsonStringValue("id", jp.getValue("id")));
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("type", "valid"));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessCustInfo bc = new project.Business.Base.BusinessCustInfo();
bc.load(jp.getValue("id"));
if (obj.ExecuteDataSet("select 1 from WO_WorkOrder where CustNo='" + bc.Entity.CustNo + "' and AccID='" + user.Entity.AccID + "'").Tables[0].Rows.Count > 0)
{
flag = "3";
}
else
{
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("CustNameS"), int.Parse(jp.getValue("page")))));
return(collection.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
string result = "";;
try
{
Business.Base.BusinessCustInfo bc = new project.Business.Base.BusinessCustInfo();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("CustNo", bc.Entity.CustNo));
collection.Add(new JsonStringValue("CustName", bc.Entity.CustName));
collection.Add(new JsonStringValue("CustType", bc.Entity.CustType));
collection.Add(new JsonStringValue("Contact", bc.Entity.Contact));
collection.Add(new JsonStringValue("Tel", bc.Entity.Tel));
collection.Add(new JsonStringValue("Addr", bc.Entity.Addr));
collection.Add(new JsonStringValue("Website", bc.Entity.Website));
collection.Add(new JsonStringValue("Remark", bc.Entity.Remark));
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonStringValue("flag", flag));
result = collection.ToString();
return(result);
}
private string submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessCustInfo bc = new project.Business.Base.BusinessCustInfo();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.CustName = jp.getValue("CustName");
bc.Entity.CustType = jp.getValue("CustType");
bc.Entity.Contact = jp.getValue("Contact");
bc.Entity.Tel = jp.getValue("Tel");
bc.Entity.Addr = jp.getValue("Addr");
bc.Entity.Website = jp.getValue("Website");
bc.Entity.Remark = jp.getValue("Remark");
int r = bc.Save();
if (r <= 0)
{
flag = "2";
}
}
else
{
Data obj = new Data();
DataTable dt = obj.ExecuteDataSet("select cnt=COUNT(*) from Base_Cust_Info where CustNo=N'" + jp.getValue("CustNo") + "' and AccID='" + user.Entity.AccID + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.CustNo = jp.getValue("CustNo");
bc.Entity.CustName = jp.getValue("CustName");
bc.Entity.CustType = jp.getValue("CustType");
bc.Entity.Contact = jp.getValue("Contact");
bc.Entity.Tel = jp.getValue("Tel");
bc.Entity.Addr = jp.getValue("Addr");
bc.Entity.Website = jp.getValue("Website");
bc.Entity.Remark = jp.getValue("Remark");
bc.Entity.AccID = user.Entity.AccID;
bc.Entity.Valid = true;
bc.Entity.RegDate = GetDate();
int r = bc.Save();
if (r <= 0)
{
flag = "2";
}
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "submit"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("CustNameS"), int.Parse(jp.getValue("page")))));
return(collection.ToString());
}