private void UpdateSqlData() //手动状态下更新数据库
{
var Db = new DbContext().Db; //获取操作对象
AssignmentModel assignment = new AssignmentModel();
assignment.ID = Rack + Row + Column + Depth;
assignment.Rack = Rack;
assignment.X_Num = Row;
assignment.Y_Num = Column;
assignment.Depth = Depth;
assignment.Status = "OK";
var worksheet = reoGridControl1.CurrentWorksheet;//获取当前工作表
if (worksheet[Position] != null)
{
assignment.Name = worksheet[Position].ToString();
assignment.Code = "";
assignment.CreateTime = DateTime.Now;
Db.Saveable <AssignmentModel>(assignment).ExecuteReturnEntity();
}
else
{
// var t=Db.Deleteable<AssignmentModel>.In(assignment.ID).ExecuteCommand();
}
}
private bool InsertPallet(int depth)
{
var Db = new DbContext().Db;
string ID;
for (int rack = 1; rack < 3; rack++)//Rack
{
for (int row = 1; row < 27; row++)
{
for (int column = 1; column < 5; column++)
{
ID = rack.ToString("000") + row.ToString("000") + column.ToString("00") + depth.ToString("00");
var isAny = Db.Queryable <AssignmentModel>().Where(it => it.ID == ID).Any();
if (isAny)
{
continue;
}
else
{
string[] craneData = new string[17];
craneData[0] = "Crane1";
craneData[1] = SequenceNumber;
craneData[2] = AssignmentID;
craneData[3] = "CM";
craneData[4] = "01";
craneData[5] = "001"; //Rack1
craneData[8] = "01"; // 起点单双深
craneData[9] = rack.ToString("000");
craneData[12] = depth.ToString("00"); // 终点单双深
craneData[6] = "901"; //起点X
craneData[7] = "01"; //起点Y
craneData[10] = row.ToString("000"); //终点X
craneData[11] = column.ToString("00"); //终点Y
telegramARQ(craneData);
AssignmentModel model = new AssignmentModel();
model.ID = ID;
model.Rack = rack.ToString("000");
model.X_Num = row.ToString("000");
model.Y_Num = column.ToString("00");
model.Depth = depth.ToString("00");
model.Status = "OK";
model.Name = tbRuku.Text;
model.Code = "";
model.CreateTime = DateTime.Now;
var t2 = Db.Insertable(model).ExecuteCommand();
UpdateExcel(model.X_Num, model.Y_Num, tbRuku.Text);
return(true);
}
}
}
}
return(false);
}