public static StockInfo PutawayTicketItemToStockInfo(PutawayTicketItem putawayTicketItem)
{
WMSEntities wmsEntities = new WMSEntities();
StockInfo stockInfo = new StockInfo();
stockInfo.ID = 0;
stockInfo.ReceiptTicketItemID = putawayTicketItem.ReceiptTicketItemID;
stockInfo.OverflowAreaAmount = 10000;
ReceiptTicketItemView receiptTicketItemView = (from rti in wmsEntities.ReceiptTicketItemView where rti.ID == putawayTicketItem.ReceiptTicketItemID select rti).FirstOrDefault();
//TODO stockInfo.ProjectID = receiptTicketItemView.ReceiptTicketProjectID;
//TODO stockInfo.WarehouseID = receiptTicketItemView.ReceiptTicketWarehouse;
return(stockInfo);
}
private void Search()
{
//this.labelStatus.Text = "搜索中...";
new Thread(new ThreadStart(() =>
{
var wmsEntities = new WMSEntities();
ReceiptTicketItemView[] receiptTicketItemViews = null;
try
{
receiptTicketItemViews = wmsEntities.Database.SqlQuery <ReceiptTicketItemView>(
"SELECT * FROM ReceiptTicketItemView " +
"WHERE ReceiptTicketID = @receiptTicketID",
new SqlParameter("receiptTicketID", this.receiptTicketID)).ToArray();
}
catch
{
MessageBox.Show("无法连接到数据库，请查看网络连接!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
this.countRow = receiptTicketItemViews.Length;
this.reoGridControlUser.Invoke(new Action(() =>
{
//this.labelStatus.Text = "搜索完成";
var worksheet = this.reoGridControlUser.Worksheets[0];
worksheet.DeleteRangeData(RangePosition.EntireRange);
int n = 0;
for (int i = 0; i < receiptTicketItemViews.Length; i++)
{
ReceiptTicketItemView curReceiptTicketItemView = receiptTicketItemViews[i];
object[] columns = Utilities.GetValuesByPropertieNames(curReceiptTicketItemView, (from kn in ReceiptMetaData.itemsKeyName select kn.Key).ToArray());
if (curReceiptTicketItemView.State == "作废")
{
continue;
}
for (int j = 0; j < worksheet.Columns - 1; j++)
{
worksheet[n, j] = columns[j];
}
CheckBoxCell checkboxCell;
worksheet[n, worksheet.Columns - 1] = new object[] { checkboxCell = new CheckBoxCell() };
this.checkColumn = worksheet.Columns - 1;
n++;
}
}));
})).Start();
}
private void Search()
{
//this.labelStatus.Text = "搜索中...";
new Thread(new ThreadStart(() =>
{
var wmsEntities = new WMSEntities();
ReceiptTicketItemView[] receiptTicketItemViews = null;
receiptTicketItemViews = wmsEntities.Database.SqlQuery <ReceiptTicketItemView>("SELECT * FROM ReceiptTicketItemView WHERE ReceiptTicketID = @receiptTicketID", new SqlParameter("receiptTicketID", this.receiptTicketID)).ToArray();
this.countRow = receiptTicketItemViews.Length;
this.reoGridControlUser.Invoke(new Action(() =>
{
//this.labelStatus.Text = "搜索完成";
//this.reoGridControlUser.Readonly = false;
var worksheet = this.reoGridControlUser.Worksheets[0];
worksheet.DeleteRangeData(RangePosition.EntireRange);
//int n = 0;
for (int i = 0; i < receiptTicketItemViews.Length; i++)
{
ReceiptTicketItemView curReceiptTicketItemView = receiptTicketItemViews[i];
object[] columns = Utilities.GetValuesByPropertieNames(curReceiptTicketItemView, (from kn in ItemKeyName select kn.Key).ToArray());
int m = 0;
for (int j = 0; j < worksheet.Columns - 1; j++)
{
if (j == this.checkBoxColumn)
{
//CheckBoxCell checkboxCell;
//TextBox textbox = new TextBox();
//DataGridViewTextBoxCell;
//worksheet[i, m]
//Cell cell =
worksheet.CreateAndGetCell(i, m).Style.BackColor = Color.AliceBlue;
worksheet[i, j] = curReceiptTicketItemView.DefaultSubmissionAmount;
}
else
{
//worksheet.CreateAndGetCell(i, m).IsReadOnly = true;
worksheet[i, j] = columns[m];
m++;
}
}
}
}));
})).Start();
}
private void FormRecieptTicketItemsModify_Load(object sender, EventArgs e)
{
this.tableLayoutPanelTextBoxes.Controls.Clear();
for (int i = 0; i < ReceiptMetaData.itemsKeyName.Length; i++)
{
KeyName curKeyName = ReceiptMetaData.itemsKeyName[i];
if (curKeyName.Visible == false && curKeyName.Editable == false)
{
continue;
}
Label label = new Label();
label.Text = curKeyName.Name;
this.tableLayoutPanelTextBoxes.Controls.Add(label);
TextBox textBox = new TextBox();
textBox.Name = "textBox" + curKeyName.Key;
if (this.formMode == FormMode.ALTER && curKeyName.Editable == false)
{
textBox.Enabled = false;
}
else if (this.formMode == FormMode.ADD)
{
textBox.Enabled = curKeyName.Editable;
}
//Console.WriteLine("{0} {1}", label.Text, textBox.Name);
this.tableLayoutPanelTextBoxes.Controls.Add(textBox);
}
if (this.formMode == FormMode.ALTER)
{
ReceiptTicketItemView receiptTicketItemView = (from s in this.wmsEntities.ReceiptTicketItemView
where s.ID == this.receiptTicketItemID
select s).Single();
Utilities.CopyPropertiesToTextBoxes(receiptTicketItemView, this);
}
//this.Controls.Find("textBoxReceiptTicketID", true)[0].Enabled = false;
//this.Controls.Find("textBoxReceiptTicketID", true)[0].Text = this.receiptTicketID.ToString();
this.Controls.Find("textBoxComponentNo", true)[0].Click += textBoxComponentID_Click;
this.Controls.Find("textBoxComponentName", true)[0].Enabled = false;
}
private void Search()
{
//this.labelStatus.Text = "搜索中...";
new Thread(new ThreadStart(() =>
{
var wmsEntities = new WMSEntities();
ReceiptTicketItemView[] receiptTicketItemViews = null;
receiptTicketItemViews = wmsEntities.Database.SqlQuery <ReceiptTicketItemView>(String.Format("SELECT * FROM ReceiptTicketItemView WHERE ReceiptTicketID = {0}", this.receiptTicketID)).ToArray();
this.countRow = receiptTicketItemViews.Length;
this.reoGridControlUser.Invoke(new Action(() =>
{
//this.labelStatus.Text = "搜索完成";
var worksheet = this.reoGridControlUser.Worksheets[0];
worksheet.DeleteRangeData(RangePosition.EntireRange);
int n = 0;
for (int i = 0; i < receiptTicketItemViews.Length; i++)
{
ReceiptTicketItemView curReceiptTicketItemView = receiptTicketItemViews[i];
object[] columns = Utilities.GetValuesByPropertieNames(curReceiptTicketItemView, (from kn in ReceiptMetaData.itemsKeyName select kn.Key).ToArray());
if (curReceiptTicketItemView.State == "作废")
{
continue;
}
for (int j = 0; j < worksheet.Columns - 1; j++)
{
worksheet[n, j] = columns[j];
}
CheckBoxCell checkboxCell;
worksheet[n, worksheet.Columns - 1] = new object[] { checkboxCell = new CheckBoxCell() };
this.checkColumn = worksheet.Columns - 1;
n++;
}
}));
})).Start();
}
