private string deleteaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessContractType bc = new project.Business.Base.BusinessContractType(); bc.load(jp.getValue("id")); //if (obj.PopulateDataSet("select 1 from Mstr_Billboard where ContractType='" + bc.Entity.ContractTypeNo + "'").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("ContractTypeNameS")))); return(collection.ToString()); }
private string submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessContractType bc = new project.Business.Base.BusinessContractType(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id")); bc.Entity.ContractTypeName = jp.getValue("ContractTypeName"); int r = bc.Save("update"); if (r <= 0) { flag = "2"; } } else { Data obj = new Data(); DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_ContractType where ContractTypeNo='" + jp.getValue("ContractTypeNo") + "'").Tables[0]; if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0) { flag = "3"; } else { bc.Entity.ContractTypeNo = jp.getValue("ContractTypeNo"); bc.Entity.ContractTypeName = jp.getValue("ContractTypeName"); int r = bc.Save("insert"); 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("ContractTypeNameS")))); return(collection.ToString()); }
private string updateaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessContractType bc = new project.Business.Base.BusinessContractType(); bc.load(jp.getValue("id")); collection.Add(new JsonStringValue("ContractTypeNo", bc.Entity.ContractTypeNo)); collection.Add(new JsonStringValue("ContractTypeName", bc.Entity.ContractTypeName)); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "update")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }