/// <summary>
/// LINQ更新方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dc"></param>
/// <param name="fun"></param>
/// <param name="tentity"></param>
/// <param name="action"></param>
public static bool Update(Expression <Func <LogInfo, bool> > fun, Action <LogInfo> action)
{
bool rbool = true;
DCQUALITYDataContext dc = new DCQUALITYDataContext();
try
{
var table = dc.LogInfo.Where(fun).ToList();
foreach (var item in table)
{
action(item);
}
dc.SubmitChanges();
}
catch
{
dc.ChangeConflicts.ResolveAll(RefreshMode.KeepCurrentValues);
dc.SubmitChanges();
rbool = false;
}
finally
{
dc.Connection.Close();
}
return(rbool);
}
/// <summary>
/// 多项更改
/// 使用SubmitChanges将对检索到的进行的更新保持回数据库
/// </summary>
/// <param name="dictionary">Dictionary实体对象</param>
/// <returns></returns>
public static bool UpdateMore(Dictionary dictionary)
{
bool rbool = true;
try
{
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
var q = from p in db.Dictionary
where p.Dictionary_ID == dictionary.Dictionary_ID
select p;
foreach (var p in q)
{
p.Dictionary_Name = dictionary.Dictionary_Name;
p.Dictionary_OtherID = dictionary.Dictionary_OtherID;
p.Dictionary_Remark = dictionary.Dictionary_Remark;
p.Dictionary_State = dictionary.Dictionary_State;
p.Dictionary_Value = dictionary.Dictionary_Value;
}
db.SubmitChanges();
}
}
catch (Exception ex)
{
rbool = false;
}
return(rbool);
}
/// <summary>
/// 修改客户端信息
/// 注意：请在编写实体之前先获取实体再进行修改的字段编写
/// </summary>
/// <param name="record">客户端实体（ClientInfo）</param>
/// <returns></returns>
public static bool UpdateOneQcRecord(ClientInfo client)
{
bool rbool = false;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
ClientInfo qInfo = db.ClientInfo.First(c => c.Client_ID == client.Client_ID);
qInfo.Client_ADDRESS = client.Client_ADDRESS;
qInfo.Client_Dictionary_ID = client.Client_Dictionary_ID;
qInfo.Client_NAME = client.Client_NAME;
qInfo.Client_Phone = client.Client_Phone;
qInfo.Client_REMARK = client.Client_REMARK;
qInfo.Client_TestItems_ID = client.Client_TestItems_ID;
db.SubmitChanges();
rbool = true;
}
catch (Exception ex)
{
}
finally
{
db.Connection.Close();
}
}
return(rbool);
}
public static bool UpdateQCRecordISLEDSHOW(int iqcrecordId)
{
bool rbool = false;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
QCRecord qcrecord = db.QCRecord.First(c => c.QCRecord_ID == iqcrecordId);
qcrecord.QCRecord_ISLEDSHOW = true;
db.SubmitChanges();
rbool = true;
}
return(rbool);
}
/// <summary>
/// 修改质检记录信息
/// 注意：请在编写实体之前先获取实体再进行修改的字段编写
/// </summary>
/// <param name="record">质检记录实体（QCRecord）</param>
/// <returns></returns>
public static bool UpdateOneQcRecord(QCRecord record)
{
bool rbool = false;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
QCRecord qInfo = db.QCRecord.First(c => c.QCRecord_ID == record.QCRecord_ID);
qInfo.QCRecord_Client_ID = record.QCRecord_Client_ID;
qInfo.QCRecord_COUNT = record.QCRecord_COUNT;
qInfo.QCRecord_Dictionary_ID = record.QCRecord_Dictionary_ID;
qInfo.QCRecord_DRAW = record.QCRecord_DRAW;
// qInfo.QCRecord_ISLEDSHOW = record.QCRecord_ISLEDSHOW;
qInfo.QCRecord_ISRETEST = record.QCRecord_ISRETEST;
qInfo.QCRecord_NAME = record.QCRecord_NAME;
qInfo.QCRecord_NUMBER = record.QCRecord_NUMBER;
qInfo.QCRecord_OFF_TIME = record.QCRecord_OFF_TIME;
qInfo.QCRecord_QCCOUNT = record.QCRecord_QCCOUNT;
qInfo.QCRecord_QCInfo_ID = record.QCRecord_QCInfo_ID;
qInfo.QCRecord_QCRetest_ID = record.QCRecord_QCRetest_ID;
qInfo.QCRecord_REMARK = record.QCRecord_REMARK;
qInfo.QCRecord_RESULT = record.QCRecord_RESULT;
qInfo.QCRecord_TARE = record.QCRecord_TARE;
qInfo.QCRecord_TestItems_ID = record.QCRecord_TestItems_ID;
qInfo.QCRecord_TIME = record.QCRecord_TIME;
qInfo.QCRecord_TYPE = record.QCRecord_TYPE;
qInfo.QCRecord_UPDATE_REASON = record.QCRecord_UPDATE_REASON;
qInfo.QCRecord_UPDATE_TIME = record.QCRecord_UPDATE_TIME;
qInfo.QCRecord_UserId = record.QCRecord_UserId;
qInfo.QCRecord_UserId_UpdateID = record.QCRecord_UserId_UpdateID;
qInfo.QCRecord_UpdateCardUserName = record.QCRecord_UpdateCardUserName;
db.SubmitChanges();
rbool = true;
}
catch (Exception ex)
{
throw new Exception("修改质检信息（QCInfo）:" + ex.Message);
}
finally
{
db.Connection.Close();
}
}
return(rbool);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_Click(object sender, EventArgs e)
{
try
{
dc = new DCQUALITYDataContext();
idebarJoinU9 ijU9 = dc.idebarJoinU9.Where(n => n.idebarJoinU9_id == currentId).First();
dc.idebarJoinU9.DeleteOnSubmit(ijU9);
dc.SubmitChanges();
MessageBox.Show("操作成功！");
LoadData("");
}
catch (Exception)
{
MessageBox.Show("操作失败！");
return;
}
}
/// <summary>
/// 新增一条质检记录
/// </summary>
/// <param name="qcRecord">质检实体</param>
/// <returns></returns>
public static bool InsertOneDictionary(Dictionary qcRecord)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.Dictionary.InsertOnSubmit(qcRecord);
db.SubmitChanges();
}
catch (Exception ex)
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);;
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("确定删除吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes && currentId > 0)
{
dc = new DCQUALITYDataContext();
dc.WeightSet.DeleteOnSubmit(dc.WeightSet.Where(n => n.WeightSet_id == currentId).First());
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show("操作失败！", "提示");
return;
}
}
/// <summary>
/// 根据ID删除数据（单条）
/// </summary>
/// <param name="RoleInfoid">角色编号</param>
/// <returns></returns>
public static bool DeleteToMany(int RoleInfoid)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
var dty = db.RoleInfo.FirstOrDefault(p => p.Role_Id == RoleInfoid);
db.RoleInfo.DeleteOnSubmit(dty);
db.SubmitChanges();
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
//添加质检信息
public static bool addQCInfoDAL(QCInfo qcInfo)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.QCInfo.InsertOnSubmit(qcInfo);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="qcRecord">实体</param>
/// <returns></returns>
public static bool InsertOneQCRecord(LogInfo qcRecord)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.LogInfo.InsertOnSubmit(qcRecord);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 添加一条新的菜单信息
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public static bool InsertMenuInfo(MenuInfo menu)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.MenuInfo.InsertOnSubmit(menu);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
WeightSet ws = new WeightSet();
dc = new DCQUALITYDataContext();
if (btnAdd.Text == "添加")
{
if (isHaveWeightSet(Convert.ToInt32(cbxTestItem.SelectedValue)))
{
ws.WeightSet_TestItems_ID = Convert.ToInt32(cbxTestItem.SelectedValue);
ws.WeightSet_weightNum = cbxWeightNum.SelectedIndex + 1;
dc = new DCQUALITYDataContext();
dc.WeightSet.InsertOnSubmit(ws);
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
else
{
MessageBox.Show("该检测项目已经配置，请修改或删除后再添加！");
}
}
else if (btnAdd.Text == "修改" && currentId > 0)
{
ws = dc.WeightSet.Where(n => n.WeightSet_id == currentId).First();
ws.WeightSet_TestItems_ID = Convert.ToInt32(cbxTestItem.SelectedValue);
ws.WeightSet_weightNum = cbxWeightNum.SelectedIndex + 1;
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
btnAdd.Text = "添加";
cbxTestItem.Enabled = true;
LoadData();
}
catch (Exception ex)
{
MessageBox.Show("操作失败！", "提示");
return;
}
}
/// <summary>
/// 添加、修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtPRODID.Text.Trim() == "")
{
MessageBox.Show("货品名称不能为空！");
return;
}
idebarJoinU9 ij = new idebarJoinU9();
dc = new DCQUALITYDataContext();
if (btnSave.Text == "添加")
{
ij.idebarJoinU9_PROD_ID = txtPRODID.Text.Trim();
ij.idebarJoinU9_remark = txtRemork.Text.Trim();
dc = new DCQUALITYDataContext();
dc.idebarJoinU9.InsertOnSubmit(ij);
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
else if (btnSave.Text == "修改" && currentId > 0)
{
ij = dc.idebarJoinU9.Where(n => n.idebarJoinU9_id == currentId).First();
ij.idebarJoinU9_PROD_ID = txtPRODID.Text.Trim();
ij.idebarJoinU9_remark = txtRemork.Text.Trim();
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
btnSave.Text = "添加";
txtPRODID.Text = "";
txtRemork.Text = "";
LoadData("");
}
catch (Exception ex)
{
MessageBox.Show("操作失败！", "提示");
return;
}
}
/// <summary>
/// 新增一条质检记录
/// </summary>
/// <param name="qcRecord">用户实体</param>
/// /// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneQCRecord(UserInfo2 qcRecord, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.UserInfo2.InsertOnSubmit(qcRecord);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 新增一条接口表重量记录
/// </summary>
/// <param name="qcRecord">MATERIAL_QC_INTERFACE实体</param>
/// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneMATERIAL_QC_INTERFACE(MATERIAL_QC_INTERFACE qcRecord, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.MATERIAL_QC_INTERFACE.InsertOnSubmit(qcRecord);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 新增一条质检记录审批人记录
/// </summary>
/// <param name="qcRecord">质检实体</param>
/// <returns></returns>
public static bool InsertOFFQCRecord(OFFQCRecord off, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.OFFQCRecord.InsertOnSubmit(off);
db.SubmitChanges();
rint = off.OFFQCRecord_ID;
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
{ /// </summary>
/// 新增一条客户端记录
/// </summary>
/// <param name="qcRecord">QCRecord质检实体</param>
/// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneClientInfo(ClientInfo clientInfo, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.ClientInfo.InsertOnSubmit(clientInfo);
db.SubmitChanges();
rbool = true;
rint = clientInfo.Client_ID;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 新增一异常记录
/// </summary>
/// <param name="qcRecord"> </param>
/// /// <param name="rint"> </param>
/// <returns></returns>
public static bool InsertOneQCRecord(Unusual unusual, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.Unusual.InsertOnSubmit(unusual);
db.SubmitChanges();
rint = unusual.Unusual_Id;
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// </summary>
/// 新增一条车辆质检记录
/// </summary>
/// <param name="qcRecord">QCRecord质检实体</param>
/// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneCarInfo(Packets DRAW_E_INI, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.Packets.InsertOnSubmit(DRAW_E_INI);
db.SubmitChanges();
rbool = true;
rint = DRAW_E_INI.Packets_ID;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// </summary>
/// 新增一条车辆质检记录
/// </summary>
/// <param name="qcRecord">QCRecord质检实体</param>
/// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneCarInfo(RegisterLoosePaperDistribution DRAW_E_INI, out int rint)
{
rint = 0;
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.RegisterLoosePaperDistribution.InsertOnSubmit(DRAW_E_INI);
db.SubmitChanges();
rbool = true;
rint = (int)DRAW_E_INI.R_DRAW_EXAM_INTERFACE_ID;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 单项更改
/// 检索到的一个Dictionary对象做出的更新保持回数据库
/// </summary>
/// <param name="dictionary">Dictionary实体</param>
/// <returns></returns>
public static bool Update(Dictionary dictionary)
{
bool rbool = true;
try
{
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
Dictionary dic = db.Dictionary.First(c => c.Dictionary_ID == dictionary.Dictionary_ID);
dic.Dictionary_Name = dictionary.Dictionary_Name;
dic.Dictionary_Value = dictionary.Dictionary_Value;
dic.Dictionary_OtherID = dictionary.Dictionary_OtherID;
dic.Dictionary_State = dictionary.Dictionary_State;
dic.Dictionary_Remark = dictionary.Dictionary_Remark;
db.SubmitChanges();
}
}
catch (Exception ex)
{
rbool = false;
}
return(rbool);
}
/// <summary>
/// 修改质检信息
/// 注意：请在编写实体之前先获取实体再进行修改的字段编写
/// </summary>
/// <param name="qc">质检实体</param>
/// <returns></returns>
public static bool UpdateInfo(QCInfo qc)
{
bool rbool = false;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
QCInfo qInfo = db.QCInfo.First(c => c.QCInfo_ID == qc.QCInfo_ID);
qInfo.QC_PRINTNUM = qc.QC_PRINTNUM;
qInfo.QCInfo_BAGWeight = qc.QCInfo_BAGWeight;
qInfo.QCInfo_Client_ID = qc.QCInfo_Client_ID;
qInfo.QCInfo_DEGREE = qc.QCInfo_DEGREE;
qInfo.QCInfo_Dictionary_ID = qc.QCInfo_Dictionary_ID;
qInfo.QCInfo_DRAW_EXAM_INTERFACE_ID = qc.QCInfo_DRAW_EXAM_INTERFACE_ID;
qInfo.QCInfo_EXPLAIN = qc.QCInfo_EXPLAIN;
//qInfo.QCInfo_ISLEDSHOW = qc.QCInfo_ISLEDSHOW;
qInfo.QCInfo_MATERIAL_BAD_CSALE = qc.QCInfo_MATERIAL_BAD_CSALE;
qInfo.QCInfo_MATERIAL_EXAMINER = qc.QCInfo_MATERIAL_EXAMINER;
qInfo.QCInfo_MATERIAL_SCALE = qc.QCInfo_MATERIAL_SCALE;
qInfo.QCInfo_MATERIAL_WEIGHT = qc.QCInfo_MATERIAL_WEIGHT;
qInfo.QCInfo_MOIST_BAD_PER_SAMPLE = qc.QCInfo_MOIST_BAD_PER_SAMPLE;
qInfo.QCInfo_MOIST_EXAMINER = qc.QCInfo_MOIST_EXAMINER;
qInfo.QCInfo_MOIST_PER_SAMPLE = qc.QCInfo_MOIST_PER_SAMPLE;
qInfo.QCInfo_PAPER_BAD_SCALE = qc.QCInfo_PAPER_BAD_SCALE;
qInfo.QCInfo_PAPER_EXAMINER = qc.QCInfo_PAPER_EXAMINER;
qInfo.QCInfo_PAPER_SCALE = qc.QCInfo_PAPER_SCALE;
qInfo.QCInfo_PAPER_WEIGHT = qc.QCInfo_PAPER_WEIGHT;
qInfo.QCInfo_PumpingPackets = qc.QCInfo_PumpingPackets;
qInfo.QCInfo_QCGroup_ID = qc.QCInfo_QCGroup_ID;
qInfo.QCInfo_REMARK = qc.QCInfo_REMARK;
qInfo.QCInfo_STATE = qc.QCInfo_STATE;
qInfo.QCInfo_TIME = qc.QCInfo_TIME;
qInfo.QCInfo_UnpackBack_MOIST_COUNT = qc.QCInfo_UnpackBack_MOIST_COUNT;
qInfo.QCInfo_UnpackBack_MOIST_EXAMINER = qc.QCInfo_UnpackBack_MOIST_EXAMINER;
qInfo.QCInfo_UnpackBack_MOIST_PER_SAMPLE = qc.QCInfo_UnpackBack_MOIST_PER_SAMPLE;
qInfo.QCInfo_UnpackBefore_MOIST_EXAMINER = qc.QCInfo_UnpackBefore_MOIST_EXAMINER;
qInfo.QCInfo_UnpackBefore_MOIST_PER_COUNT = qc.QCInfo_UnpackBefore_MOIST_PER_COUNT;
qInfo.QCInfo_UnpackBefore_MOIST_PER_SAMPLE = qc.QCInfo_UnpackBefore_MOIST_PER_SAMPLE;
qInfo.QCInfo_UPDATE_NAME = qc.QCInfo_UPDATE_NAME;
qInfo.QCInfo_UPDATE_REASON = qc.QCInfo_UPDATE_REASON;
qInfo.QCInfo_UPDATE_TIME = qc.QCInfo_UPDATE_TIME;
qInfo.QCInfo_UserId = qc.QCInfo_UserId;
qInfo.QCIInfo_EndTime = qc.QCIInfo_EndTime;
qInfo.QCInfo_RETURNBAG_COUNT = qc.QCInfo_RETURNBAG_COUNT;
qInfo.QCInfo_RETURNBAG_EXAMINER = qc.QCInfo_RETURNBAG_EXAMINER;
qInfo.QCInfo_RETURNBAG_TIME = qc.QCInfo_RETURNBAG_TIME;
qInfo.QCInfo_RETURNBAG_WEIGH = qc.QCInfo_RETURNBAG_WEIGH;
qInfo.QCInfo_RECV_RMA_METHOD = qc.QCInfo_RECV_RMA_METHOD;
db.SubmitChanges();
rbool = true;
}
catch (Exception ex)
{
throw ex;
//log
}
finally
{
db.Connection.Close();
}
}
return(rbool);
}