public bool UpdateProductiveTaskWork(ProductiveTaskWorkModel model) { string sql = @" update ICMO_OrderList set FRequest1 = @FRequest1,FRequest2 = @FRequest2,FRequest3 = @FRequest3 where FICMONo=@FICMONo"; using (var connection = SqlDb.UpdateConnection) { return(connection.Execute(sql, model) > 0); } }
private string GetNewNote(DateTime date, ProductiveTaskWorkModel model) { string note1 = @"/" + model.FOrgNo1 + " " + model.FModal2 + " " + model.FModal3 + " " + model.FRequest1;// "/2678 38*1kg JW790A(专用4) 华南,HW/2733 3*1kg JW790A 奥凯盛,样油200G "; string noteNew = string.Empty; Regex rg = new Regex(@"/(\d{4})"); var matches = rg.Matches(note1); foreach (Match item in matches) { noteNew += _work.GetProductiveTaskListFNote(date, model.FICMONo, item.Groups[1].ToString()); } return(noteNew); }