/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool Update(CarriageReturn model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("ReturnID", model.ReturnID));
parameters.Add(new QfParameter("DispatchID", model.DispatchID));
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("ReturnDate", string.Format(@"'{0}'", model.ReturnDate)));
parameters.Add(new QfParameter("EmployeeID", model.EmployeeID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperatorID", model.OperatorID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string setStr = "";
foreach (var item in parameters)
{
if (item.Value != null && ValueConvert.ToString(item.Value) != "''")
{
setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value);
}
}
setStr = setStr.Substring(0, setStr.LastIndexOf(","));
string sql = string.Format("update t_carriage_return set {0} where ReturnID = {1}", setStr, model.ReturnID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="sql"></param>
public bool Add(CarriageReturn model)
{
try
{
var parameters = new List <QfParameter>();
parameters.Add(new QfParameter("ReturnID", model.ReturnID));
parameters.Add(new QfParameter("DispatchID", model.DispatchID));
parameters.Add(new QfParameter("CarID", model.CarID));
parameters.Add(new QfParameter("ReturnDate", string.Format(@"'{0}'", model.ReturnDate)));
parameters.Add(new QfParameter("EmployeeID", model.EmployeeID));
parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note)));
parameters.Add(new QfParameter("OperatorID", model.OperatorID));
parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime)));
string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName));
string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value));
string sql = string.Format("insert into t_carriage_return({0}) values ({1})", colStr, atColStr);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public Stream CreateCustomerDirectoryDocument(List <Object> customers)
{
MemoryStream result = new MemoryStream();
using (WordprocessingDocument wordDocument = WordprocessingDocument.Create(result, WordprocessingDocumentType.Document))
{
MainDocumentPart mainPart = wordDocument.AddMainDocumentPart();
mainPart.Document = new Document();
Body body = mainPart.Document.AppendChild(new Body());
foreach (var customer in customers.Cast <List <Object> >())
{
Paragraph para = body.AppendChild(new Paragraph());
Run run = para.AppendChild(new Run());
foreach (var item in customer.Cast <string>())
{
run.AppendChild(new Text(item));
CarriageReturn cr = new CarriageReturn();
run.AppendChild(cr);
}
}
wordDocument.Close();
}
result.Position = 0;
return(result);
}
public static void GenerateHeaderPart2Content(HeaderPart headerPart2)
{
Header header2 = new Header()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "w14 w15 w16se w16cid wp14"
}
};
header2.AddNamespaceDeclaration("wpc", "http://schemas.microsoft.com/office/word/2010/wordprocessingCanvas");
header2.AddNamespaceDeclaration("cx", "http://schemas.microsoft.com/office/drawing/2014/chartex");
header2.AddNamespaceDeclaration("cx1", "http://schemas.microsoft.com/office/drawing/2015/9/8/chartex");
header2.AddNamespaceDeclaration("cx2", "http://schemas.microsoft.com/office/drawing/2015/10/21/chartex");
header2.AddNamespaceDeclaration("cx3", "http://schemas.microsoft.com/office/drawing/2016/5/9/chartex");
header2.AddNamespaceDeclaration("cx4", "http://schemas.microsoft.com/office/drawing/2016/5/10/chartex");
header2.AddNamespaceDeclaration("cx5", "http://schemas.microsoft.com/office/drawing/2016/5/11/chartex");
header2.AddNamespaceDeclaration("cx6", "http://schemas.microsoft.com/office/drawing/2016/5/12/chartex");
header2.AddNamespaceDeclaration("cx7", "http://schemas.microsoft.com/office/drawing/2016/5/13/chartex");
header2.AddNamespaceDeclaration("cx8", "http://schemas.microsoft.com/office/drawing/2016/5/14/chartex");
header2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
header2.AddNamespaceDeclaration("aink", "http://schemas.microsoft.com/office/drawing/2016/ink");
header2.AddNamespaceDeclaration("am3d", "http://schemas.microsoft.com/office/drawing/2017/model3d");
header2.AddNamespaceDeclaration("o", "urn:schemas-microsoft-com:office:office");
header2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
header2.AddNamespaceDeclaration("m", "http://schemas.openxmlformats.org/officeDocument/2006/math");
header2.AddNamespaceDeclaration("v", "urn:schemas-microsoft-com:vml");
header2.AddNamespaceDeclaration("wp14", "http://schemas.microsoft.com/office/word/2010/wordprocessingDrawing");
header2.AddNamespaceDeclaration("wp", "http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing");
header2.AddNamespaceDeclaration("w10", "urn:schemas-microsoft-com:office:word");
header2.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main");
header2.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml");
header2.AddNamespaceDeclaration("w15", "http://schemas.microsoft.com/office/word/2012/wordml");
header2.AddNamespaceDeclaration("w16cid", "http://schemas.microsoft.com/office/word/2016/wordml/cid");
header2.AddNamespaceDeclaration("w16se", "http://schemas.microsoft.com/office/word/2015/wordml/symex");
header2.AddNamespaceDeclaration("wpg", "http://schemas.microsoft.com/office/word/2010/wordprocessingGroup");
header2.AddNamespaceDeclaration("wpi", "http://schemas.microsoft.com/office/word/2010/wordprocessingInk");
header2.AddNamespaceDeclaration("wne", "http://schemas.microsoft.com/office/word/2006/wordml");
header2.AddNamespaceDeclaration("wps", "http://schemas.microsoft.com/office/word/2010/wordprocessingShape");
Paragraph paragraph277 = new Paragraph()
{
RsidParagraphAddition = "00F225EA", RsidRunAdditionDefault = "009E39C2", ParagraphId = "637CAE62", TextId = "77777777"
};
Run run406 = new Run();
CarriageReturn carriageReturn1 = new CarriageReturn();
run406.Append(carriageReturn1);
paragraph277.Append(run406);
header2.Append(paragraph277);
headerPart2.Header = header2;
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="sql"></param>
public bool UpdateReturnDate(CarriageReturn model)
{
try
{
string sql = string.Format("update t_car_dispatch set ReturnDate = '{0}', Status = 4 where DispatchID = {1}", model.ReturnDate, model.DispatchID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="sql"></param>
public bool Delete(CarriageReturn model)
{
try
{
string sql = string.Format("delete from t_carriage_return where ReturnID = {0}", model.ReturnID);
int row = MysqlHelper.ExecuteNonQuery(sql);
return(row == 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="sql"></param>
public CarriageReturn GetModel(int ReturnID)
{
try
{
string sql = string.Format("select * from t_carriage_return where ReturnID = {0} limit 1", ReturnID);
DataTable dt = MysqlHelper.ExecuteDataTable(sql);
CarriageReturn model = ModelConvert.ToModel <CarriageReturn>(dt);
return(model);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public void CrInsertion(IElementContext context, CarriageReturn cr)
{
InsertBrAtCurrentPosition(context);
}
public bool ProcessElement(IElementProcessingState state, CarriageReturn cr)
{
InsertBreak(state);
return(false);
}
public void TestSymbols()
{
var s1 = LineFeed.Negate().Maybe();
Assert.AreEqual(s1.Expression, @"[^\n]?");
var s2 = CarriageReturn.OnceOrMore();
Assert.AreEqual(s2.Expression, @"\r+");
s1 = Backspace.Negate().Maybe();
Assert.AreEqual(s1.Expression, @"[^\x08]?");
s2 = Backspace.OnceOrMore();
Assert.AreEqual(s2.Expression, @"\x08+");
s2 = CarriageReturnLineFeed.NoneOrMany();
Assert.AreEqual(s2.Expression, @"(?:\r\n)*");
var p = (LineFeed | CarriageReturnLineFeed).AtLeast(2);
Assert.AreEqual(p.Expression, @"(?:\n|\r\n){2,}");
p = ("abc" + LineFeed | CarriageReturnLineFeed).AtLeast(2);
Assert.AreEqual(p.Expression, @"(?:abc\n|\r\n){2,}");
p = ("abc" + (LineFeed | CarriageReturnLineFeed)).Repeat(5);
Assert.AreEqual(p.Expression, @"(?:abc(?:\n|\r\n)){5}");
p = "Hi." + AnyChar;
Assert.AreEqual(p.Expression, @"Hi\..");
s2 = AnyWordChars[3, 4];
Assert.AreEqual(s2.Expression, @"(?:\w+){3,4}");
s2 = (AnyWordChars | "; ") + EndOfLine;
Assert.AreEqual(s2.Expression, @"(?:\w+|;\ )$");
s2 = WhiteSpace + AnyWordChars + "; " + EndOfLine;
Assert.AreEqual(s2.Expression, @"\s\w+;\ $");
s2 = AnyWordChars | s2;
Assert.AreEqual(s2.Expression, @"\w+|\s\w+;\ $");
s2 = s2 + AnyWordChars;
Assert.AreEqual(s2.Expression, @"(?:\w+|\s\w+;\ $)\w+");
s2 = s2 | AnyWordChars;
Assert.AreEqual(s2.Expression, @"(?:\w+|\s\w+;\ $)\w+|\w+");
s2 = (
(AnyWordChars
| (WhiteSpace + AnyWordChars + "; " + EndOfLine)
)
+ AnyWordChars
)
| AnyWordChars;
Assert.AreEqual(s2.Expression, @"(?:\w+|\s\w+;\ $)\w+|\w+");
var c = AsciiChar('\t')[2];
Assert.AreEqual(c.Expression, @"\x09{2}");
c = AsciiChar(222)[2, 0];
Assert.AreEqual(c.Expression, @"\xde{2,}");
c = AsciiChar(0xaf)[0, 0];
Assert.AreEqual(c.Expression, @"\xaf*");
}
