linq2DB lambda
来源:互联网 发布:ppt拆分合并软件 编辑:程序博客网 时间:2024/06/05 03:55
//添加数据
public static bool InsertSeries(string SeriesName, string SubSeriesName, string OPIName, string OPICode, string States, string InsideCode, int MinStock, int AddStockNum, string Remarks, string OPI_CODERemarkes, DateTime OPI_Date = default(DateTime))
{
bool result;
string ss = OPIDB.GetConnectionString(DBHelper.ConnConfig);
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var user = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_CODE == OPICode && x.SERIES_NAME == SeriesName && x.OPI_NAME == OPIName && x.SUB_NAME == SubSeriesName && x.OPI_INSIDECODE == InsideCode);
if (user == null)
{
result = true;
T_OPI opi = new T_OPI();
if (OPI_Date == default(DateTime))
opi.OPI_DATE = DateTime.Now;
else
opi.OPI_DATE = OPI_Date;
opi.SERIES_NAME = SeriesName;
opi.SUB_NAME = SubSeriesName;
opi.OPI_NAME = OPIName;
opi.OPI_CODE = OPICode;
opi.OPI_STATES = States;
opi.OPI_INSIDECODE = InsideCode;
opi.OPI_MINSTOCK = MinStock;
opi.OPI_ADDSTOCKNUM = AddStockNum;
opi.OPI_REMARKES = Remarks;
opi.OPI_CODERemarkes=OPI_CODERemarkes;
sQLNICSDB.Insert(opi);
}
else
{
result = false;
}
return result;
}
}
//删除数据
public static bool DelSeries(string series_name,int ID)
{
bool result = false;
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var name = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_ID == ID);
if (name == null)
{
result = false;
}
else
{
//验证成功,删除
sQLNICSDB.Delete(name);
result = true;
}
}
return result;
}
//修改数据
public static bool UpdateSERIES(string SeriesName, string SubSeriesName, string OPIName, string OPICode, string States, string InsideCode, int MinStock, int AddStockNum, string Remarks, int ID,string OPI_CODERemarkes, DateTime OPI_Date = default(DateTime))
{
bool result = false;
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var user = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_ID == ID);
if (user != null)
{
var list1 = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_CODE == OPICode && x.SERIES_NAME == SeriesName && x.OPI_NAME == OPIName && x.SUB_NAME == SubSeriesName && x.OPI_INSIDECODE == InsideCode);
if (list1 != null)
{
result = true;
user.OPI_STATES = States;
user.OPI_MINSTOCK = Convert.ToInt32(MinStock);
user.OPI_ADDSTOCKNUM = AddStockNum;
user.OPI_DATE = OPI_Date;
user.OPI_REMARKES = Remarks;
user.OPI_CODERemarkes = OPI_CODERemarkes;
sQLNICSDB.Update(user);
}
else
{
result = true;
user.SERIES_NAME = SeriesName;
user.SUB_NAME = SubSeriesName;
user.OPI_NAME = OPIName;
user.OPI_CODE = OPICode;
user.OPI_INSIDECODE = InsideCode;
user.OPI_STATES = States;
user.OPI_MINSTOCK = Convert.ToInt32(MinStock);
user.OPI_ADDSTOCKNUM = AddStockNum;
user.OPI_DATE = OPI_Date;
user.OPI_REMARKES = Remarks;
user.OPI_CODERemarkes = OPI_CODERemarkes;
sQLNICSDB.Update(user);
}
}
else
{
result = false;
}
}
return result;
}
//查询所有的数据
public static List<T_OPI> select()
{
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
return sQLNICSDB.T_OPI.OrderBy(x => x.SERIES_NAME).ThenBy(x=>x.OPI_INSIDECODE).ToList();//con.表名.ToList(); ToList()--查找所有
}
//tuple
public static List<Tuple<string, string, string, string, string, long, long,Tuple<string,DateTime>>> selectOrNeiBu()
{
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
//var result2 = sQLNICSDB.T_OPI.Select(s=> Tuple.Create(s.OPI_REMARKES,s.OPI_DATE));
var result3 = sQLNICSDB.T_OPI.Select(s => new Tuple<string, string, string, string,
string, long, long, Tuple<string, DateTime>>(s.SERIES_NAME, s.SUB_NAME, s.OPI_NAME, s.OPI_CODE, s.OPI_STATES, s.OPI_MINSTOCK, s.OPI_ADDSTOCKNUM, Tuple.Create(s.OPI_REMARKES, s.OPI_DATE))).ToList();
return result3;
}
}
//查询去重的系列名称数据
public static List<string> selectDSeriesName()
{
List<string> result = new List<string>();
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
result = sQLNICSDB.T_OPI.Select(x => x.SERIES_NAME).Distinct().ToList();
}
return result;
}
public static bool InsertSeries(string SeriesName, string SubSeriesName, string OPIName, string OPICode, string States, string InsideCode, int MinStock, int AddStockNum, string Remarks, string OPI_CODERemarkes, DateTime OPI_Date = default(DateTime))
{
bool result;
string ss = OPIDB.GetConnectionString(DBHelper.ConnConfig);
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var user = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_CODE == OPICode && x.SERIES_NAME == SeriesName && x.OPI_NAME == OPIName && x.SUB_NAME == SubSeriesName && x.OPI_INSIDECODE == InsideCode);
if (user == null)
{
result = true;
T_OPI opi = new T_OPI();
if (OPI_Date == default(DateTime))
opi.OPI_DATE = DateTime.Now;
else
opi.OPI_DATE = OPI_Date;
opi.SERIES_NAME = SeriesName;
opi.SUB_NAME = SubSeriesName;
opi.OPI_NAME = OPIName;
opi.OPI_CODE = OPICode;
opi.OPI_STATES = States;
opi.OPI_INSIDECODE = InsideCode;
opi.OPI_MINSTOCK = MinStock;
opi.OPI_ADDSTOCKNUM = AddStockNum;
opi.OPI_REMARKES = Remarks;
opi.OPI_CODERemarkes=OPI_CODERemarkes;
sQLNICSDB.Insert(opi);
}
else
{
result = false;
}
return result;
}
}
//删除数据
public static bool DelSeries(string series_name,int ID)
{
bool result = false;
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var name = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_ID == ID);
if (name == null)
{
result = false;
}
else
{
//验证成功,删除
sQLNICSDB.Delete(name);
result = true;
}
}
return result;
}
//修改数据
public static bool UpdateSERIES(string SeriesName, string SubSeriesName, string OPIName, string OPICode, string States, string InsideCode, int MinStock, int AddStockNum, string Remarks, int ID,string OPI_CODERemarkes, DateTime OPI_Date = default(DateTime))
{
bool result = false;
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
var user = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_ID == ID);
if (user != null)
{
var list1 = sQLNICSDB.T_OPI.FirstOrDefault(x => x.OPI_CODE == OPICode && x.SERIES_NAME == SeriesName && x.OPI_NAME == OPIName && x.SUB_NAME == SubSeriesName && x.OPI_INSIDECODE == InsideCode);
if (list1 != null)
{
result = true;
user.OPI_STATES = States;
user.OPI_MINSTOCK = Convert.ToInt32(MinStock);
user.OPI_ADDSTOCKNUM = AddStockNum;
user.OPI_DATE = OPI_Date;
user.OPI_REMARKES = Remarks;
user.OPI_CODERemarkes = OPI_CODERemarkes;
sQLNICSDB.Update(user);
}
else
{
result = true;
user.SERIES_NAME = SeriesName;
user.SUB_NAME = SubSeriesName;
user.OPI_NAME = OPIName;
user.OPI_CODE = OPICode;
user.OPI_INSIDECODE = InsideCode;
user.OPI_STATES = States;
user.OPI_MINSTOCK = Convert.ToInt32(MinStock);
user.OPI_ADDSTOCKNUM = AddStockNum;
user.OPI_DATE = OPI_Date;
user.OPI_REMARKES = Remarks;
user.OPI_CODERemarkes = OPI_CODERemarkes;
sQLNICSDB.Update(user);
}
}
else
{
result = false;
}
}
return result;
}
//查询所有的数据
public static List<T_OPI> select()
{
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
return sQLNICSDB.T_OPI.OrderBy(x => x.SERIES_NAME).ThenBy(x=>x.OPI_INSIDECODE).ToList();//con.表名.ToList(); ToList()--查找所有
}
//tuple
public static List<Tuple<string, string, string, string, string, long, long,Tuple<string,DateTime>>> selectOrNeiBu()
{
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
//var result2 = sQLNICSDB.T_OPI.Select(s=> Tuple.Create(s.OPI_REMARKES,s.OPI_DATE));
var result3 = sQLNICSDB.T_OPI.Select(s => new Tuple<string, string, string, string,
string, long, long, Tuple<string, DateTime>>(s.SERIES_NAME, s.SUB_NAME, s.OPI_NAME, s.OPI_CODE, s.OPI_STATES, s.OPI_MINSTOCK, s.OPI_ADDSTOCKNUM, Tuple.Create(s.OPI_REMARKES, s.OPI_DATE))).ToList();
return result3;
}
}
//查询去重的系列名称数据
public static List<string> selectDSeriesName()
{
List<string> result = new List<string>();
using (OPIDB sQLNICSDB = new OPIDB(OPIDB.GetConnectionString(DBHelper.ConnConfig)))
{
result = sQLNICSDB.T_OPI.Select(x => x.SERIES_NAME).Distinct().ToList();
}
return result;
}
0 0
- linq2DB lambda
- Lambda
- lambda
- lambda
- lambda
- Lambda
- lambda
- lambda
- Lambda
- Lambda
- lambda
- lambda
- lambda
- lambda
- lambda
- lambda
- lambda
- lambda
- Java之设计模式六大原则(2):里氏替换原则
- TCP连接的建立(三次握手)和释放(四次握手)
- GridView中实现CheckBoxList选中更新数据库
- 前端优化
- 什么是和包(NFC)业务
- linq2DB lambda
- 强制修改mysql密码
- java web servlet 实现自动生成验证码
- Oracle 数据库信息搜集脚本 持续更新
- 2016.11.23-2016.11.25回顾
- JVM之偏向锁应用及性能分析
- Android SDK Android NDK Android Studio 官方下载地址
- yii2 用gii生成CRUD页面
- lua5.1 到 5.3的一些经常会接触到的改动