public void Insert2(Dictionary <string, object> dicList, string html, int menuID, string imgUri, string filename, string filePath) { if (NeedInsertDB) { string sql1 = string.Format("select * from dbo.SchoolStyle where dbo.SchoolStyle.Description ='{0}'", dicList["Title"]); string error1 = ""; List <cm> cmList = DBManage.ExcuteEntity <cm>(sql1, System.Data.CommandType.Text, out error1); if (cmList.Count < 1) { int modeType = 0; if (dicList.ContainsKey("_x6a21__x7248_")) { if (dicList["_x6a21__x7248_"] != null) { modeType = 1; } } Microsoft.SharePoint.Client.FieldUserValue vvv = dicList["Author"] as Microsoft.SharePoint.Client.FieldUserValue; string creator = vvv.LookupValue; html = html.Replace("'", "''"); string sql = string.Format("insert into SchoolStyle(MenuId,Title,[Description],CreateTime,ImageUrl,ClickNum,ModelType,IsDelete,Creator,FileName,FilePath) values({0},'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}')", menuID, dicList["Title"], html, dicList["Created"], imgUri, dicList["Count"], modeType, 0, creator, filename, filePath); string error = ""; DBManage.Transaction(sql, out error); } } }
public cm GetCm(string title) { cm cm = null; string sql = string.Format("select * from PortalTreeData where PortalTreeData.Name ='{0}'", title); string error = ""; List <cm> cmList = DBManage.ExcuteEntity <cm>(sql, System.Data.CommandType.Text, out error); if (cmList.Count > 0) { cm = cmList[0]; } return(cm); }