using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace 补片.DAL
|
{
|
public class gongchenglog
|
{
|
public string gongchengNo { get; set; }
|
public string caozuo { get; set; }
|
public string caozuoren { get; set; }
|
public string caozuoxiangqing { get; set; }
|
public int? IntRemark { get; set; }
|
public string StrRemark { get; set; }
|
|
|
|
public static bool Insert(gongchenglog gcl)
|
{
|
try
|
{
|
StringBuilder sb = new StringBuilder();
|
sb.Append("Insert into gongchenglog ");
|
sb.Append(" (gongcheng,caozuo,caozuoren,caozuoxiangqing,IntRemark,StrRemark)");
|
sb.Append(" Values");
|
sb.AppendFormat(@"('{0}','{1}','{2}','{3}','{4}','{5}')", gcl.gongchengNo, gcl.caozuo, BuPianBll.MainName+" 版本号："+BuPianBll.Version, gcl.caozuoxiangqing, gcl.IntRemark == null ? 0 : gcl.IntRemark, string.IsNullOrEmpty(gcl.StrRemark) ? "版本号：" + BuPianBll.Version : gcl.StrRemark);
|
return MySqlSqHelper.ExecuteSql(sb.ToString(), "mm");
|
}
|
catch (Exception ex)
|
{
|
return false;
|
}
|
|
}
|
|
/// <summary>
|
/// 删除多少天之前的工程操作记录
|
/// </summary>
|
/// <param name="days"></param>
|
/// <returns></returns>
|
public bool Delete(int days = 90)
|
{
|
|
string dt = DateTime.Now.AddDays(-days).ToString("yyyy-MM-dd");
|
StringBuilder sb = new StringBuilder();
|
sb.AppendFormat("Delete from where createtime =< '{0}'", dt);
|
return MySqlSqHelper.ExecuteSql(sb.ToString(), "mm");
|
}
|
|
|
public static string GetCZName(int cztype)
|
{
|
string czName = "";
|
switch (cztype)
|
{
|
case -1:
|
czName = "修改";
|
break;
|
case 0:
|
czName = "创建";
|
break;
|
case 1:
|
czName = "保存";
|
break;
|
case 2:
|
czName = "撤销优化";
|
break;
|
case 3:
|
czName = "下发";
|
break;
|
case 4:
|
czName = "执行";
|
break;
|
case 5:
|
czName = "标注外采";
|
break;
|
case 6:
|
czName = "取消标注外采";
|
break;
|
case 7:
|
czName = "复刻";
|
break;
|
case 8:
|
czName = "手动";
|
break;
|
case 9:
|
czName = "打开";
|
break;
|
case 10:
|
czName = "打印工艺流程卡";
|
break;
|
case 11:
|
czName = "导出已优化工程列表";
|
break;
|
case 12:
|
czName = "优化";
|
break;
|
case 13:
|
czName = "删除未优化工程";
|
break;
|
case 14:
|
czName = "撤销下发";
|
break;
|
case 15:
|
czName = "撤销执行";
|
break;
|
case 16:
|
czName = "补片信息下发";
|
break;
|
case 17:
|
czName = "李赛克";
|
break;
|
case 18:
|
czName = "登入程序";
|
break;
|
case 19:
|
czName = "退出程序";
|
break;
|
default:
|
czName = "未知";
|
break;
|
}
|
return czName;
|
}
|
|
|
|
public static void ShowErrorMessage(string err, string cap = "错误提示")
|
{
|
System.Windows.Forms.MessageBox.Show(err, cap, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
|
}
|
|
|
|
}
|
}
|
