/// <summary> /// 带Log删除 自定义where /// </summary> /// <param name="keys"></param> /// <param name="cuser"></param> public void IoRyDelete(List <string> keys, string cuser) { string sqlp = "delete " + tablename + " where {0}"; List <string> lswhere = new List <string>(); foreach (var item in keys) { string mv = LIC.Where(x => x.ioryName == item).First().ioryValue; lswhere.Add(item + "='" + mv + "'"); } string sql = string.Format(sqlp, string.Join(" and ", lswhere)); IoRyFunction.CallIoRyClass(sql, cuser); }
/// <summary> /// 带Log新增 /// </summary> /// <returns></returns> public void IoRyAdd(string cuser) { string sqlp = " insert into " + tablename + " ({0}) values ({1})"; List <string> lscname = new List <string>(); List <string> lscvalue = new List <string>(); foreach (IoRyCol item in this.LIC) { if (item.ioryValueNull == false && item.IsIdentity == false) { lscname.Add(item.ioryName); lscvalue.Add("'" + item.ioryValue.Replace("'", "''") + "'"); } } if (lscname.Count == 0) { throw new Exception("新增的类必须有值!"); } string sql = string.Format(sqlp, string.Join(",", lscname), string.Join(",", lscvalue)); IoRyFunction.CallIoRyClass(sql, cuser); }
/// <summary> /// 自定义where 带Log 修改 /// </summary> /// <param name="keys"></param> /// <param name="cuser"></param> public void IoRyUpdate(List <string> keys, string cuser) { string sqlp = "update " + tablename + " set {0} where {1}"; List <string> lsset = new List <string>(); List <string> lswhere = new List <string>(); if (LIC.Any(x => x.ioryValueChange == true)) { foreach (var item in LIC) { if (item.ioryValueChange == true) { if (!keys.Contains(item.ioryName)) { if (item.ioryValueNull) { lsset.Add(item.ioryName + " = null "); } else { lsset.Add(item.ioryName + "='" + item.ioryValue.Replace("'", "''") + "'"); } } } } foreach (var item in keys) { string mv = LIC.Where(x => x.ioryName == item).First().ioryValue; lswhere.Add(item + "='" + mv + "'"); } string sql = string.Format(sqlp, string.Join(",", lsset), string.Join(" and ", lswhere)); IoRyFunction.CallIoRyClass(sql, cuser); } else { throw new Exception("此数据没有修改!"); } }
/// <summary> /// 带Log删除 自定义where /// </summary> /// <param name="keys"></param> /// <param name="cuser"></param> public void IoRyDelete(List <string> keys, string cuser) { IoRyFunction.CallIoRyClass(this.IoRyDelete_Sql(keys), cuser); }
/// <summary> /// 自定义where 修改 /// </summary> /// <param name="keys"></param> public void IoRyUpdate(List <string> keys) { IoRyFunction.CallIoRyClass(this.IoRyUpdate_Sql(keys)); }
/// <summary> /// 带Log新增 /// </summary> /// <returns></returns> public void IoRyAdd(string cuser) { IoRyFunction.CallIoRyClass(this.IoRyAdd_Sql(), cuser); }
/// <summary> /// 普通新增 /// </summary> /// <returns></returns> public void IoRyAdd() { IoRyFunction.CallIoRyClass(this.IoRyAdd_Sql()); }
/// <summary> /// 执行事务 /// </summary> public void Commit() { IoRyFunction.CallIoRyClass(this.Sql); }