/// <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);
}
