public string DeleteData(string userid, string id) { IDbTransaction tran = Utility.Database.BeginDbTransaction();//开始事务并返回一个事务对象 SkyLandDeveloper developer = new SkyLandDeveloper("{}", userid, tran);//获取业务流相关参数 try { Para_UsedPhrase usedPhrase = new Para_UsedPhrase(); usedPhrase.Condition.Add("id = " + id);//设置查询条件,条件为当前用户ID Utility.Database.Delete(usedPhrase, tran); developer.Commit();//提交事务 //return JsonConvert.SerializeObject( retContent); return Utility.JsonMsg(true, "删除成功!"); } catch (Exception ex) { developer.RollBack();//回滚事务 ComBase.Logger(ex);//写日专到本地文件 return Utility.JsonMsg(false, "删除失败:" + ex.Message); //return Utility.JsonMsg(false, "删除失败:" + ex.Message); } }
public object GetUsedPhrase(string userid, string lx) { DataSet dataSet = null; IDbTransaction tran = Utility.Database.BeginDbTransaction();//开始事务并返回一个事务对象 SkyLandDeveloper developer = new SkyLandDeveloper("{}", userid, tran);//获取业务流相关参数 try { GetUsedPhraseDataModel data = new GetUsedPhraseDataModel(); List<Para_UsedPhrase> usedPhraseList = new List<Para_UsedPhrase>(); //Para_UsedPhrase list = new Para_UsedPhrase(); //list.Condition.Add("cjrid = " + userid);//设置查询条件,条件为当前用户ID //list.Condition.Add("lx = " + lx);//设置查询条件,条件为常用语类型 //data.usedPhraseList = Utility.Database.QueryList(list); dataSet = Utility.Database.ExcuteDataSet("select * from Para_UsedPhrase where cjrid='" + userid + "' and lx='" + lx + "' order by sypl desc", tran); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0] != null) { string jsonData = JsonConvert.SerializeObject(dataSet.Tables[0]); usedPhraseList = (List<Para_UsedPhrase>)JsonConvert.DeserializeObject(jsonData, typeof(List<Para_UsedPhrase>)); } else { usedPhraseList = new List<Para_UsedPhrase>(); } Para_UsedPhrase userPhrase = new Para_UsedPhrase(); userPhrase.lx = lx; userPhrase.cjrid = userid; userPhrase.cjsj = DateTime.Now; Utility.Database.Commit(tran); return new { usedPhraseList = usedPhraseList, userPhrase = userPhrase }; } catch (Exception ex) { Utility.Database.Commit(tran); ComBase.Logger(ex);//写日专到本地文件 return Utility.JsonMsg(false, ex.Message); } finally { if (dataSet != null) dataSet.Dispose(); tran.Dispose(); } }
public string SaveData(string userid, string nr, string lx) { if (nr == null || nr.ToString() == "") return Utility.JsonResult(true, "数据不能空"); //UTF8Encoding utf = new UTF8Encoding(); //lx = utf.GetString(Encoding.Unicode.GetBytes(lx)).Trim(); //byte[] utf8Bytes = Encoding.UTF8.GetBytes(lx); //lx = Encoding.GetEncoding("UTF-8").GetString(utf8Bytes); nr = nr.Trim(); IDbTransaction tran = Utility.Database.BeginDbTransaction();//开始事务并返回一个事务对象 SkyLandDeveloper developer = new SkyLandDeveloper("{}", userid, tran);//获取业务流相关参数 try { Para_UsedPhrase usedPhrase = new Para_UsedPhrase(); usedPhrase.nr = nr; usedPhrase.cjrid = userid; usedPhrase.lx = lx; usedPhrase.Condition.Add("cjrid=" + userid); usedPhrase.Condition.Add("lx=" + lx); usedPhrase.Condition.Add("nr=" + nr); List<Para_UsedPhrase> list = Utility.Database.QueryList(usedPhrase); DataSet ds = Utility.Database.ExcuteDataSet("select isnull(MAX(sypl),0) as sypl from Para_UsedPhrase where cjrid='" + userid + "' and lx='" + lx + "'"); usedPhrase.sypl = (int)ds.Tables[0].Rows[0]["sypl"] + 1; if (list == null || list.Count < 1) { usedPhrase.cjsj = DateTime.Now; Utility.Database.Insert(usedPhrase, tran); } else { Utility.Database.Update(usedPhrase, tran); } developer.Commit();//提交事务 //return Utility.JsonResult(true, "保存成功!", retContent); return Utility.JsonResult(true, "保存成功!"); } catch (Exception ex) { developer.RollBack();//回滚事务 ComBase.Logger(ex);//写日专到本地文件 return Utility.JsonResult(false, "保存失败:" + ex.Message); //return Utility.JsonResult(false, "删除失败:" + ex.Message); } }