public static bool Add(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0 || dt.Columns.Count == 0)
{
return(false);
}
//INSERT INTO [Job]()VALUES();
StringBuilder fields_sb = new StringBuilder();
StringBuilder values_sb = new StringBuilder();
StringBuilder value_sb = new StringBuilder();
//先确定字段
foreach (DataColumn col in dt.Columns)
{
fields_sb.Append(col.ColumnName + ",");
}
fields_sb.Remove(fields_sb.Length - 1, 1);
//确定值
foreach (DataRow row in dt.Rows)
{
value_sb.Clear();
foreach (DataColumn col in dt.Columns)
{
value_sb.Append("'" + row[col].ToString() + "',");
}
value_sb.Remove(value_sb.Length - 1, 1);
values_sb.AppendLine("(" + value_sb + "),");
}
return(MySqlDbHelper.ExecuteNonQuery(
string.Format("INSERT INTO `Job`\n({0})\nVALUES\n{1}"
, fields_sb.ToString(), values_sb.ToString().Trim().TrimEnd(','))) > 0);
}
public int DeleteCrossing(string id)
{
int ret = -1;
string strSql = "delete from tb_crossing where ID = " + id;
MySqlDbHelper dbHelper = new MySqlDbHelper();
dbHelper.Connect();
ret = dbHelper.ExecuteNonQuery(strSql);
dbHelper.Close();
return(ret);
}
public int UpdateCrossing(string crossId, string crossName, string id)
{
int ret = -1;
string strSql = "update tb_crossing set CROSSING_ID='" + crossId + "',CROSSING_NAME = '" + crossName + "' where id = " + id;
MySqlDbHelper dbHelper = new MySqlDbHelper();
dbHelper.Connect();
ret = dbHelper.ExecuteNonQuery(strSql);
dbHelper.Close();
return(ret);
}
public int AddCrossing(string crossId, string crossName)
{
int ret = -1;
string strSql = "insert into tb_crossing(CROSSING_ID, CROSSING_NAME,CREATE_TIME) values('" +
crossId + "','" + crossName + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')";
MySqlDbHelper dbHelper = new MySqlDbHelper();
dbHelper.Connect();
ret = dbHelper.ExecuteNonQuery(strSql);
dbHelper.Close();
return(ret);
}
public int UpdateCrossingInfo(string crossing_id, string json, string base64Image)
{
MySqlDbHelper dbHelper = new MySqlDbHelper();
dbHelper.Connect();
string sqlStr = "update tb_crossing set CROSSING_CONFIG='" + json + "' where CROSSING_ID='" + crossing_id + "'";
if (!string.IsNullOrEmpty(base64Image))
{
sqlStr = "update tb_crossing set CROSSING_CONFIG='" + json + "' ,IMAGE_DATA='" + base64Image + "' where CROSSING_ID='" + crossing_id + "'";
}
int retVal = dbHelper.ExecuteNonQuery(sqlStr);
dbHelper.Close();
return(retVal);
}
private static void IsNotExistCreate()
{
MySqlDbHelper.ExecuteNonQuery(
" CREATE TABLE `PublishJob`.`job` (" +
" `ID` bigint(20) NOT NULL AUTO_INCREMENT," +
" `出版` bit(1) NOT NULL," +
" `稿袋号` varchar(10) NOT NULL," +
" `上机机台` varchar(20) NOT NULL," +
" `客户简称` varchar(20) NOT NULL," +
"`产品名称` varchar(200) NOT NULL," +
" `制造尺寸` varchar(30) NOT NULL," +
" `面纸尺寸` varchar(20) NOT NULL," +
" `色数1` varchar(10) NOT NULL," +
" `色数2` varchar(10) NOT NULL," +
" `晒版数` varchar(10) NOT NULL," +
" `备注` varchar(254) NOT NULL," +
" `咬口` varchar(10) NOT NULL," +
" `Excel文件` varchar(100) NOT NULL," +
" `Excel时间` datetime NOT NULL," +
" PRIMARY KEY (`ID`)" +
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;");
}