public static int UpdateBOMCode(mg_BOM_MatchModel model) { string sql = @"UPDATE [mg_BOM_Match] SET [TraceCode] = '" + model.TraceCode + @"' WHERE BOMNO='" + model.BOMNO + "' and VIN='" + model.VIN + "'"; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null)); }
public static int RecordBOMCode(mg_BOM_MatchModel model) { string sql = @"INSERT INTO [mg_BOM_Match] ([BOMNO] ,[MatchResult] ,[ScanCode] ,[RecordDate] ,[UID] ,[VIN]) VALUES ('" + model.BOMNO + @"' ,1 ,'" + model.ScanCode + @"' ,'" + DateTime.Now.ToString() + @"' ,'" + model.UID + @"' ,'" + model.VIN + @"')"; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null)); }
public bool UpdateBOMCode(mg_BOM_MatchModel model) { return((mg_BOM_MatchDAL.UpdateBOMCode(model) != -1) ? true : false); }
public bool RecordBOMCode(mg_BOM_MatchModel model) { return((mg_BOM_MatchDAL.RecordBOMCode(model) > 0) ? true : false); }