public ActionResult GetBoListByID()
{
BOManager manager = new BOManager();
string BOID = Request["BOID"];
return(JsonNT(manager.GetBoListByID(BOID)));
}
public string GetBoListByBOTID()
{
string data = "";
BOList = new List <BOModel>();
BOManager manager = new BOManager();
string BOTID = Request["BOTID"];
string BONAME = Request["BONAME"].Trim();
BOList = manager.GetBoListByBOTID(BOTID);
foreach (BOModel rtm in BOList)
{
if (rtm.Name.Contains(BONAME))
{
if (data == "")
{
data = "{id:'" + rtm.Boid + "',text:'" + rtm.Name + "',BOC:'" + rtm.Boc + "'}";
}
else
{
data = data + "," + "{id:'" + rtm.Boid + "',text:'" + rtm.Name + "',BOC:'" + rtm.Boc + "'}";
}
}
}
if (data != "")
{
data = "[" + data + "]";
}
return(data);
}
public bool SaveBOPara()
{
String json = Request["data"];
string BOID = Request["BOID"];
string Source = "";
string NS = Request["NS"].Trim();
BOManager manager = new BOManager();
List <string> SqlList = new List <string>();
ArrayList rows = (ArrayList)Decode(json);
StringBuilder MD = new StringBuilder();
MD.Append(" <PropertySet" + " name=" + '"' + NS + '"' + "> ");
foreach (Hashtable row in rows)
{
String id = row["id"] != null ? row["id"].ToString() : "";
//根据记录状态，进行不同的增加、删除、修改操作
String state = row["_state"] != null ? row["_state"].ToString() : "";
string n = row["name"].ToString();
string v = row["value"].ToString();
string t = row["editor"].ToString();
if (t == "textbox")
{
t = "String";
}
else if (t == "spinner")
{
t = "Decimal";
}
else if (t == "selectvalue")
{
t = "selectvalue";
}
else
{
t = "date";
}
MD.Append(" <P ");
MD.Append(" n=" + '"' + n + '"' + " t=" + '"' + t + '"' + ">" + v + "");
MD.Append(" </P> ");
}
MD.Append(" </PropertySet > ");
PropertyManager PropManager = new PropertyManager();
PropertyModel PropModel = new PropertyModel();
PropModel.MD = MD.ToString();
PropModel.BOId = BOID;
PropModel.NS = NS;
PropModel.MdSource = Source;
if (PropManager.Update(PropModel) == 1)
{
return(true);
}
else
{
return(false);
}
}
public void DelBOByID()
{
BOManager manager = new BOManager();
BOModel bo = new BOModel();
string BOID = Request["BOID"];
bo.Boid = BOID;
int i = manager.Delete(bo);
}
public ActionResult GetALIASNAME()
{
BOManager manager = new BOManager();
string BOID = Request["BOID"];
DataTable Dt = manager.GetALIASNAME(BOID);
return(JsonNT(Dt));
}
public string UpdatBOBYID()
{
BOManager manager = new BOManager();
BOModel model = new BOModel();
model.Boid = Request["BOID"];;
model.Name = Request["BONAME"];;
model.Botid = Request["BOTID"];
if (Request["ISUSE"] == "是")
{
model.Isuse = "1";
}
else
{
model.Isuse = "0";
}
string Result = "OK";
List <BOModel> BoList = manager.GetBoListByName(Request["BONAME"], Request["BOTID"]);
if (BoList.Count() > 0)//对象名称已经存在！
{
Result = "NO";
}
else
{
if (manager.Update(model) == 1)
{
Result = "OK";
}
else
{
Result = "failse";
}
}
return(Result);
}
public string SaveObjInfo()
{
String jsons = Request["data"];
string BOname = Request["BOname"].Trim();
string nameBM = Request["nameBM"].Trim();
string AppDomains = Request["AppDomain"];
string BOTID = Request["BOTID"];
string BOID = System.Guid.NewGuid().ToString();
BOManager manager = new BOManager();
List <string> SqlList = new List <string>();
string Result = "OK";
List <BOModel> BoList = manager.GetBoListByName(BOname, BOTID);
if (BoList.Count() > 0)//对象名称已经存在！
{
Result = "NO";
}
else
{
string Sql = "insert into bo( BOID , NAME , BOTID, ISUSE ) " +
" values('" + BOID + "','" + BOname + "','" + BOTID + "','1')";
SqlList.Add(Sql);
string[] sjson = jsons.Split('|');
foreach (string json in sjson)
{
ArrayList rows = (ArrayList)Decode(json);
foreach (Hashtable row in rows)
{
foreach (DictionaryEntry de in row) //ht为一个Hashtable实例
{
StringBuilder Property = new StringBuilder();
Property.Append(" <PropertySet" + " name=" + '"' + de.Key + '"' + "> ");
foreach (Hashtable tde in (ArrayList)de.Value)
{
string n = tde["name"].ToString();
string v = tde["value"].ToString();
string t = tde["editor"].ToString();
if (t == "textbox")
{
t = "String";
}
else if (t == "spinner")
{
t = "Decimal";
}
else if (t == "selectvalue")
{
t = "String";
}
else
{
t = "date";
}
Property.Append(" <P ");
Property.Append(" n=" + '"' + n + '"' + " t=" + '"' + t + '"' + ">" + v + "");
Property.Append(" </P> ");
}
Property.Append(" </PropertySet > ");
Sql = "insert into property(boid, ns,md) values('" + BOID + "','" + de.Key + "','" + Property.ToString() + "') ";
SqlList.Add(Sql);
}
}
}
Sql = "insert into aliasname( BOID, NAME , APPDOMAIN) " +
" values('" + BOID + "','" + nameBM + "','" + AppDomains + "')";
SqlList.Add(Sql);
bool b = manager.InsertBOandPara(SqlList);
if (b)
{
Result = "OK";
}
else
{
Result = "Fails";
}
}
return(Result);
}
