private void RefreshTextBoxes()
{
this.ClearTextBoxes();
var worksheet = this.reoGridControlPutaway.Worksheets[0];
int[] ids = Utilities.GetSelectedIDs(this.reoGridControlPutaway);
if (ids.Length == 0)
{
this.putawayTicketID = -1;
return;
}
int id = ids[0];
PutawayTicketView putawayTicketView = (from s in this.wmsEntities.PutawayTicketView
where s.ID == id
select s).FirstOrDefault();
if (putawayTicketView == null)
{
MessageBox.Show("系统错误，未找到相应送检单项目", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//putawayTicketView.ReceiptTicketID = this.receiptTicketID;
//this.putawayTicketID = int.Parse(submissionTicketItemView.SubmissionTicketID.ToString());
Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this);
//this.Controls.Find("textBoxReceiptTicketID", true)[0].Text = this.receiptTicketID.ToString();
//Utilities.CopyPropertiesToComboBoxes(shipmentTicketItemView, this);
}
private void Search()
{
this.labelStatus.Text = "搜索中...";
new Thread(new ThreadStart(() =>
{
var wmsEntities = new WMSEntities();
//ReceiptTicketView[] receiptTicketViews = null;
PutawayTicketView[] putawayTicketView = null;
try
{
putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>(String.Format("SELECT * FROM PutawayTicketView WHERE ReceiptTicketID={0}", receiptTicketID)).ToArray();
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
this.reoGridControlPutaway.Invoke(new Action(() =>
{
this.labelStatus.Text = "搜索完成";
var worksheet = this.reoGridControlPutaway.Worksheets[0];
worksheet.DeleteRangeData(RangePosition.EntireRange);
int n = 0;
for (int i = 0; i < putawayTicketView.Length; i++)
{
if (putawayTicketView[i].State == "作废")
{
continue;
}
PutawayTicketView curPutawayTicketView = putawayTicketView[i];
object[] columns = Utilities.GetValuesByPropertieNames(curPutawayTicketView, (from kn in ReceiptMetaData.putawayTicketKeyName select kn.Key).ToArray());
for (int j = 0; j < worksheet.Columns; j++)
{
if (columns[j] == null)
{
worksheet[n, j] = columns[j];
}
else
{
worksheet[n, j] = columns[j].ToString();
}
}
n++;
}
}));
this.Invoke(new Action(this.RefreshTextBoxes));
})).Start();
}
private void FormPutwayTicketModify_Load(object sender, EventArgs e)
{
InitComponent();
if (this.formMode == FormMode.ALTER)
{
PutawayTicketView putawayTicketView = (from pt in wmsEntities.PutawayTicketView where pt.ID == this.putawayTicketID select pt).FirstOrDefault();
if (putawayTicketView != null)
{
Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this);
}
}
else
{
TextBox textBoxReceiptTicketID = (TextBox)this.Controls.Find("textBoxReceiptTicketID", true)[0];
textBoxReceiptTicketID.Text = this.receiptTicketID.ToString();
textBoxReceiptTicketID.Enabled = false;
}
}
private void FormPutawayModify_Load(object sender, EventArgs e)
{
//InitComponent();
Utilities.CreateEditPanel(this.tableLayoutPanelTextBoxes, ReceiptMetaData.putawayTicketKeyName);
this.PersonIDGetter = Utilities.BindTextBoxSelect <FormSelectPerson, Person>(this, "textBoxPersonName", "Name");
putawayTicket = (from pt in wmsEntities.PutawayTicket where pt.ID == this.putawayTicketID select pt).FirstOrDefault();
PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == this.putawayTicketID select ptv).FirstOrDefault();
if (putawayTicketView == null)
{
MessageBox.Show("找不到该上架单", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
Utilities.CopyPropertiesToTextBoxes(putawayTicketView, this);
Utilities.CopyPropertiesToComboBoxes(putawayTicketView, this);
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
var worksheet = this.reoGridControlUser.Worksheets[0];
StandardFormPreviewExcel formPreview = new StandardFormPreviewExcel("上架单预览");
WMSEntities wmsEntities = new WMSEntities();
int[] ids = Utilities.GetSelectedIDs(this.reoGridControlUser);
if (ids.Length == 0)
{
MessageBox.Show("请选择一项预览", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
foreach (int id in ids)
{
try
{
PutawayTicketView putawayTicketView = (from ptv in wmsEntities.PutawayTicketView where ptv.ID == id select ptv).FirstOrDefault();
PutawayTicketItemView[] putawayTicketItemView = (from ptiv in wmsEntities.PutawayTicketItemView where ptiv.PutawayTicketID == putawayTicketView.ID select ptiv).ToArray <PutawayTicketItemView>();
string worksheetName = id.ToString();
if (putawayTicketView == null)
{
MessageBox.Show("上架单不存在，请重新查询！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//ReceiptTicketView receiptTicketView = (from rtv in wmsEntities.ReceiptTicketView where rtv.ID == submissionTicketView.ReceiptTicketID select rtv).FirstOrDefault();
if (formPreview.AddPatternTable(@"Excel\PutawayTicket.xlsx", worksheetName) == false)
{
this.Close();
return;
}
if (putawayTicketView != null)
{
formPreview.AddData("PutawayTicket", putawayTicketView, worksheetName);
}
formPreview.AddData("PutawayTicketItem", putawayTicketItemView, worksheetName);
formPreview.SetPrintScale(1.0F, worksheetName);
}
catch
{
MessageBox.Show("搜索失败，请检查网络连接！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
formPreview.SetPrintedCallback(new Action(() =>
{
WMSEntities wmsEntities2 = new WMSEntities();
foreach (int id in ids)
{
PutawayTicket putawayTicket = (from pt in wmsEntities2.PutawayTicket where pt.ID == id select pt).FirstOrDefault();
if (putawayTicket != null)
{
if (putawayTicket.PrintTimes == null)
{
putawayTicket.PrintTimes = 0;
}
putawayTicket.PrintTimes++;
}
}
new Thread(() =>
{
wmsEntities2.SaveChanges();
Search();
}).Start();
}));
//formPreview.AddData("SubmissionTicketItem", submissionTicketItemView);
formPreview.Show();
}
private void Search(string key, string value)
{
this.lableStatus.Text = "搜索中...";
new Thread(new ThreadStart(() =>
{
var wmsEntities = new WMSEntities();
PutawayTicketView[] putawayTicketView = null;
if (key == null || value == null) //搜索所有
{
try
{
putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>("SELECT * FROM PutawayTicketView WHERE WarehouseID = @warehouseID AND ProjectID = @projectID ORDER BY ID DESC", new SqlParameter[] { new SqlParameter("warehouseID", this.warehouseID), new SqlParameter("projectID", this.projectID) }).ToArray();
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
}
else
{
double tmp;
//if (Double.TryParse(value, out tmp) == false) //不是数字则加上单引号
//{
// value = "'" + value + "'";
//}
try
{
putawayTicketView = wmsEntities.Database.SqlQuery <PutawayTicketView>(String.Format("SELECT * FROM PutawayTicketView WHERE {0} = @key AND WarehouseID = @warehouseID AND ProjectID = @projectID ORDER BY ID DESC", key), new SqlParameter[] { new SqlParameter("@key", value), new SqlParameter("@warehouseID", this.warehouseID), new SqlParameter("@projectID", this.projectID) }).ToArray();
}
catch (EntityException)
{
MessageBox.Show("查询的值不合法，请输入正确的值！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
catch (Exception)
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
}
this.reoGridControlUser.Invoke(new Action(() =>
{
this.lableStatus.Text = "搜索完成";
var worksheet = this.reoGridControlUser.Worksheets[0];
worksheet.DeleteRangeData(RangePosition.EntireRange);
int n = 0;
for (int i = 0; i < putawayTicketView.Length; i++)
{
PutawayTicketView curReceiptTicketView = putawayTicketView[i];
if (curReceiptTicketView.State == "作废")
{
continue;
}
object[] columns = Utilities.GetValuesByPropertieNames(curReceiptTicketView, (from kn in ReceiptMetaData.putawayTicketKeyName select kn.Key).ToArray());
for (int j = 0; j < worksheet.Columns; j++)
{
if (columns[j] == null)
{
worksheet[n, j] = columns[j];
}
else
{
worksheet[n, j] = columns[j].ToString();
}
}
n++;
}
}));
if (putawayTicketView.Length == 0)
{
int m = ReceiptUtilities.GetFirstColumnIndex(ReceiptMetaData.submissionTicketKeyName);
//this.reoGridControl1.Worksheets[0][6, 8] = "32323";
this.reoGridControlUser.Worksheets[0][0, m] = "没有查询到符合条件的记录";
}
})).Start();
}
