/// <summary>
/// 插入产品信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
///DateTime theDate = DateTime.Now;
// theDate.ToString("yyyy-MM-dd HH:mm:ss");
string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into production (lineid,brakename,brakeid,brakecode,createtime,factory,remark)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
// strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, dateTime, mdl.Factory, mdl.Remark);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 更新产品计划信息
/// </summary>
/// <param name="info"></param>
public int UpdateAcqCountItem(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\
string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime);
//(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)
strSql = "update acq_count_list set tagName='{0}',StartTime='{1}',EndTime='{2}',CurrentCount='{3}',Remark='{4}' "
+ " where tid='{5}'";
strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.StartTime,
mdl.CurrentCount, mdl.Remark);
// ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 插入单项产品计划
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int InsertAcqCountItem(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into acq_count_list (tagName,StartTime,EndTime,CurrentCount,Remark)" +
"values('{0}','{1}','{2}','{3}','{4}')";
//2015-05-11 08:30:00
string startTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.StartTime); //4-10-2010 17:16:50\
string endTime = String.Format("{0:yyyy-MM-dd HH:mm:ss}", mdl.EndTime);
strSql = string.Format(strSql, mdl.TagName, startTime, endTime, mdl.CurrentCount, mdl.Remark);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 插入单项产品计划
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int InsertProductionPlanItem(ProductionPlanMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "insert into production_plan (plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')";
strSql = string.Format(strSql, mdl.PlanID, mdl.Pline_ID, mdl.Station_ID, mdl.StartTime.ToString("yyyy-MM-dd HH:mm:ss"),
mdl.EndTime.ToString("yyyy-MM-dd HH:mm:ss"), mdl.BreakeID, mdl.PlanNum, mdl.Actual_num, mdl.Shift, mdl.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), mdl.Remark);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public int UpdateActualPlan(string tid, int actualNum)
{
try
{
int ret = 0;
string strSql = "update production_plan set actual_num='{0}' where tid='{1}'";
strSql = string.Format(strSql, actualNum, tid);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
}
return(0);
}
/// <summary>
/// 插入文本文本内容
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private int InsertNoticeInfo(string info)
{
int ret = 0;
string strSql = string.Empty;
try
{
//DateTime theDate = DateTime.Now;
//theDate.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into notice (tid,content,update_time) values(1,'{0}','{1}')";
strSql = string.Format(strSql, info, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public int RemoveAllAcqCountItem()
{
try
{
int ret = 0;
string strSql = "delete from acq_count_list;";
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 删除产品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteProduction(int id)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "delete from production where tid=" + id.ToString();
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 更新插入单项的起始采集总数
/// </summary>
/// <param name="mdl"></param>
/// <returns></returns>
public int UpdateItemStartCountValue(int startCount, string tagName)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "update acq_count_list set StartCount='{0}' "
+ " where tagName='{1}'";
strSql = string.Format(strSql, startCount, tagName);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
public int UpdateAcqCountValue(AcqCountMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//(plan_id,pline_id,station_id,start_time,end_time,brakeid,plan_num,actual_num,shift,create_time,remark)
strSql = "update acq_count_list set CurrentCount='{0}' "
+ " where tagName='{1}'";
strSql = string.Format(strSql, mdl.CurrentCount, mdl.TagName);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 更新产品信息
/// </summary>
/// <param name="info"></param>
public int UpdateProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//DateTime theDate = DateTime.Now;
//theDate.ToString("yyyy-MM-dd HH:mm:ss");
string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "update production set lineid='{0}',brakename='{1}',brakeid='{2}',brakecode='{3}',factory='{4}',remark='{5}' where tid='{6}'";
// strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, mdl.Factory, mdl.Remark, mdl.TID);
// ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql,null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
