/// <summary> /// 修改資料 /// </summary> /// <param name="formdata"></param> /// <returns></returns> public static bool ToUptForm1Data(Form1Data formdata) { bool result = false; using (var conn = new SqlConnection(MainController.connStr)) { conn.Open(); //SqlTransaction sqlTrans = conn.BeginTransaction(); try { string sqlStr = @"UPDATE dt_formdata SET Title = @dc_title, File_Info = @dc_fileinfo WHERE ID = @dc_ID"; conn.Execute(sqlStr, new { dc_title = formdata.Title, dc_fileinfo = formdata.File_Info, dc_ID = formdata.ID }); result = true; } catch (Exception err) { throw (err); } } return(result); }
/// <summary> /// 新增資料 /// </summary> /// <param name="formdata"></param> /// <returns></returns> public static bool ToInsForm1Data(Form1Data formdata) { bool result = false; using (var conn = new SqlConnection(MainController.connStr)) { try { conn.Open(); string sqlStr = @"INSERT INTO dt_formdata (Title, File_Info, Create_Time) VALUES (@dc_title, @dc_fileinfo, CURRENT_TIMESTAMP)"; conn.Execute(sqlStr, new[] { new { dc_title = formdata.Title, dc_fileinfo = formdata.File_Info } }); result = true; } catch (Exception err) { throw (err); } } return(result); }