private void JogoCard_Clicked(object sender, EventArgs e)
{
MaterialCard card = (MaterialCard)sender;
Jogo ctxJogo = (Jogo)card.BindingContext;
Navigation.PushAsync(new JogoView(ctxJogo));
}
private void Jogador_Clicked(object sender, EventArgs e)
{
MaterialCard card = (MaterialCard)sender;
Jogador ctxJogador = (Jogador)card.BindingContext;
Navigation.PushAsync(new InfoJogador(ctxJogador));
}
public MaterialCard ScanMatIn_Complete(string serialno, string location, string userid, out string resultMsg)
{
resultMsg = string.Empty;
MaterialCard mtl = null;
//remark userid value := userid & serial #
string serial = string.Empty;
string[] user_v = userid.Split('|');
if (user_v.Length.Equals(2))
{
userid = user_v[0];
serial = user_v[1];
}
try
{
using (MaterialBLL materialBll = new MaterialBLL())
{
mtl = materialBll.ScanMatIn_Complete(serialno, location, userid, out resultMsg);
}
// UserOnline.ProcessUserOnline(serial, userid, "Scan Material In.");
}
catch (Exception ex)
{
mtl = null;
throw ex;
}
return(mtl);
}
void LoadCards()
{
panelCardsContent.Controls.Clear();
lstId.Clear();
SqlConnection con = new SqlConnection(Form1.txtcon);
string txtquery = "select id_game from Games where id_studio = " + id_studio;
con.Open();
SqlCommand query1 = new SqlCommand(txtquery, con);
SqlDataReader read = query1.ExecuteReader();
while (read.Read())
{
lstId.Add(read["id_game"].ToString());
}
con.Close();
int curY = 10;
for (int i = 0; i <= lstId.Count - 1; i++)
{
MaterialCard card = new MaterialCard();
card.Size = new Size(1000, 150);
card.Location = new Point(100, curY);
panelCardsContent.Controls.Add(card);
CardAbout crd = new CardAbout(lstId[i]);
crd.btnEdit.Click += btnEdit_Click;
crd.btnDel.Click += BtnDel_Click;
card.Controls.Add(crd);
curY += 160;
}
}
public MaterialCard ScanMat_Stock(string serialno, out string resultMsg)
{
resultMsg = string.Empty;
MaterialCard mtl = null;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_MAT_PACK.SCAN_MAT_STOCK"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strSERIAL_NO", serialno);
procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 30);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize;
while (OraDataReader.Instance.OraReader.Read())
{
mtl = new MaterialCard();
mtl.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
mtl.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
mtl.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mtl.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mtl.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mtl.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mtl.QTY = OraDataReader.Instance.GetDecimal("QTY");
mtl.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
mtl.MIN_QTY = OraDataReader.Instance.GetDecimal("MIN_QTY");
mtl.MAX_QTY = OraDataReader.Instance.GetDecimal("MAX_QTY");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
OracleString resultDB = (OracleString)procPara.ReturnValue(2);
if (!resultDB.IsNull)
{
resultMsg = resultDB.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(mtl);
}
public override Activity Create()
{
Activity activity = new Activity();
try
{
PredefinedActivity p = m_ActivityLibrary.Get(m_WorkflowService.currentStep);
activity.Id = Guid.NewGuid().ToString();
activity.Type = "message";
activity.Text = m_LocalizationManager.GetLocalized($"{{{{{p.message}}}}}");
activity.Timestamp = DateTime.UtcNow;
if (p.hasImage)
{
string path = m_Domain + "/" + p.image;
MaterialCard matCard = new MaterialCard()
{
Materials = null, Image = new CardImage(path), Text = activity.Text
};
JContainer cont = JObject.FromObject(matCard);
activity.Attachments = new List <Attachment>()
{
new Attachment(AttachmentContentType.Material, null, cont)
};
}
}
catch (System.Exception e)
{
Debug.LogException(e);
}
return(activity);
}
public List <MaterialCard> GetSelectMtlCard(int seqNo)
{
List <MaterialCard> lstMtlCard = null;
MaterialCard mtlCard;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MTL_IN_PACK.GET_MATERIAL_CARD"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strSEQ_NO", seqNo);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstMtlCard = new List <MaterialCard>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
mtlCard = new MaterialCard();
mtlCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
mtlCard.ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO");
mtlCard.LINE_NO = OraDataReader.Instance.GetInteger("LINE_NO");
mtlCard.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mtlCard.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
mtlCard.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mtlCard.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mtlCard.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mtlCard.QTY = OraDataReader.Instance.GetDecimal("QTY");
mtlCard.CARGO_STATUS = OraDataReader.Instance.GetString("CARGO_STATUS");
mtlCard.WH_ID = OraDataReader.Instance.GetString("WH_ID");
//prdCard.BARCODE = OraDataReader.Instance.GetBitmap("BARCODE");
mtlCard.NO_OF_PRINT = OraDataReader.Instance.GetInteger("NO_OF_PRINT");
lstMtlCard.Add(mtlCard);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstMtlCard = null;
throw ex;
}
return(lstMtlCard);
}
private void NewsCard_Clicked(object sender, EventArgs e)
{
MaterialCard card = (MaterialCard)sender;
Article ctxArtigo = (Article)card.BindingContext;
string newsUrl = ctxArtigo.url;
Browser.OpenAsync(newsUrl);
}
protected override void OnElementChanged(ElementChangedEventArgs <Frame> e)
{
base.OnElementChanged(e);
if (e?.NewElement != null)
{
_materialCard = this.Element as MaterialCard;
this.Elevate(_materialCard.Elevation);
}
}
void LoadCards()
{
panelCards.Controls.Clear();
lstId.Clear();
SqlConnection con = new SqlConnection(Form1.txtcon);
string txtquery = "select id_game from Games where visible = 'true' ";
if (genre != "")
{
txtquery += genre;
}
if (search != "")
{
txtquery += search;
}
con.Open();
SqlCommand query1 = new SqlCommand(txtquery, con);
SqlDataReader read = query1.ExecuteReader();
while (read.Read())
{
lstId.Add(read["id_game"].ToString());
}
con.Close();
int curY = 10;
for (int i = lstId.Count - 1; i >= 0; i--)
{
MaterialCard card = new MaterialCard();
card.Size = new Size(750, 150);
card.Location = new Point(3, curY);
panelCards.Controls.Add(card);
CardAbout crd = new CardAbout(lstId[i])
{
flag = true
};
crd.btnDel.Visible = false;
crd.btnEdit.Tag = lstId[i];
crd.btnEdit.Text = "Подробнее";
crd.btnEdit.IconChar =
FontAwesome.Sharp.IconChar.ThList;
crd.btnEdit.Width = 400;
crd.btnEdit.Click += BtnEdit_Click;
card.Controls.Add(crd);
curY += 160;
}
}
protected override void OnElementChanged(ElementChangedEventArgs <Frame> e)
{
base.OnElementChanged(e);
if (e?.NewElement != null)
{
_materialCard = this.Element as MaterialCard;
this.UpdateStrokeColor();
this.Control.Elevate(_materialCard.Elevation);
this.SetClickable();
this.Control.SetOnTouchListener(this);
}
}
public override Activity Create(PredefinedActivity p)
{
Activity activity = new Activity();
try
{
activity.Id = Guid.NewGuid().ToString();
activity.Type = "message";
activity.Text = m_LocalizationManager.GetLocalized($"{{{{{p.message}}}}}");
activity.Timestamp = DateTime.UtcNow;
if (p.hasImage)
{
string path = m_Domain + "/" + p.image;
MaterialCard matCard = new MaterialCard()
{
Materials = null, Image = new CardImage(path), Text = activity.Text
};
JContainer cont = JObject.FromObject(matCard);
activity.Attachments = new List <Attachment>()
{
new Attachment(AttachmentContentType.Material, null, cont)
};
}
if (p.suggestedActions != null && p.suggestedActions.Length > 0)
{
List <CardAction> actions = new List <CardAction>();
for (int i = 0; i < p.suggestedActions.Length; i++)
{
SuggestedAction a = p.suggestedActions[i];
string localizedMessage = m_LocalizationManager.GetLocalized($"{{{{{a.Message}}}}}");
actions.Add(new CardAction(a.Type, localizedMessage, null, localizedMessage));
}
activity.SuggestedActions = new SuggestedActions()
{
Actions = actions
};
}
}
catch (System.Exception e)
{
Debug.LogException(e);
}
return(activity);
}
public Activity Create(ActivityData param)
{
Activity activity = new Activity
{
Id = Guid.NewGuid().ToString(),
Type = "message",
Text = param.message,
Timestamp = DateTime.UtcNow
};
if (!string.IsNullOrWhiteSpace(param.mediaFilePath))
{
JContainer container = null;
switch (param.contentType)
{
case AttachmentContentType.Material:
MaterialCard matCard = new MaterialCard()
{
Materials = null, Image = new CardImage(Path.Combine(workflowDirectory, param.mediaFilePath)), Text = activity.Text
};
container = JObject.FromObject(matCard);
break;
case AttachmentContentType.Video:
VideoCard videoCard = new VideoCard()
{
Text = activity.Text, Media = new List <MediaUrl>()
{
new MediaUrl(Path.Combine(workflowDirectory, param.mediaFilePath))
}
};
container = JObject.FromObject(videoCard);
break;
default:
break;
}
activity.Attachments = new List <Attachment>()
{
new Attachment(param.contentType, null, container)
};
}
return(activity);
}
private async void frmMaterialShow_Load(object sender, EventArgs e)
{
var searchRequest = new MaterialSearchRequest()
{
type = _type, isAvailable = _isAvailable
};
var materials = await _service.Get <List <EToolService.Model.Models.Material> >(searchRequest);
foreach (var material in materials)
{
var detailsPanel = new MaterialCard(material, this);
detailsPanel.Dock = DockStyle.Top;
detailsPanel.Show();
pnlMaterials.Controls.Add(detailsPanel);
}
pnlMaterials.Show();
}
protected override void OnElementChanged(ElementChangedEventArgs <Frame> e)
{
base.OnElementChanged(e);
if (e?.NewElement == null)
{
return;
}
_materialCard = this.Element as MaterialCard;
if (_materialCard != null)
{
this.Elevate(_materialCard.Elevation);
}
this.SetupColors();
this.SetIsClickable();
}
protected override void OnElementChanged(ElementChangedEventArgs <Frame> e)
{
base.OnElementChanged(e);
if (e?.NewElement != null)
{
_materialCard = this.Element as MaterialCard;
#region SHADOW FIX FOR BELOW API 23
if (Build.VERSION.SdkInt < BuildVersionCodes.N && _materialCard.Elevation > 0)
{
_materialCard.BorderColor = _materialCard.BackgroundColor;
}
#endregion
this.Control.Elevate(_materialCard.Elevation);
}
}
public MaterialCard ScanMat_Stock(string serialno, out string resultMsg)
{
resultMsg = string.Empty;
MaterialCard mtl = null;
try
{
using (MaterialBLL materialBll = new MaterialBLL())
{
mtl = materialBll.ScanMat_Stock(serialno, out resultMsg);
}
}
catch (Exception ex)
{
mtl = null;
throw ex;
}
return(mtl);
}
protected override void OnElementChanged(ElementChangedEventArgs <Frame> e)
{
base.OnElementChanged(e);
if (e?.NewElement != null)
{
_materialCard = this.Element as MaterialCard;
#region SHADOW FIX FOR BELOW API 23
/// TODO: Remove this after https://github.com/xamarin/Xamarin.Forms/issues/2423 has been resolved.
if (Build.VERSION.SdkInt < BuildVersionCodes.N && _materialCard.Elevation > 0)
{
_materialCard.BorderColor = _materialCard.BackgroundColor;
}
#endregion
this.Control.Elevate(_materialCard.Elevation);
}
}
public MaterialCard ScanMat_ChangeLocation(string serialno, string location, string userid, out string resultMsg)
{
resultMsg = string.Empty;
MaterialCard mtl = null;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_MAT_PACK.SCAN_MAT_CHANGELOCATION"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strSERIAL_NO", serialno);
procPara.AddParamInput(2, "strLOCATION", location);
procPara.AddParamInput(3, "strUSER_ID", userid);
procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 30);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize;
while (OraDataReader.Instance.OraReader.Read())
{
mtl = new MaterialCard();
mtl.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
mtl.PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID");
mtl.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
mtl.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mtl.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mtl.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mtl.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mtl.QTY = OraDataReader.Instance.GetDecimal("QTY");
mtl.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
mtl.ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO");
mtl.CARGO_STATUS = OraDataReader.Instance.GetString("CARGO_STATUS");
mtl.LOCATION_ID = OraDataReader.Instance.GetString("LOCATION_ID");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
OracleString resultDB = (OracleString)procPara.ReturnValue(4);
if (!resultDB.IsNull)
{
resultMsg = resultDB.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(mtl);
}
private DataTable GetPrintMaterialCard(int seqNo, string tableName)
{
List <MaterialCard> lstMCard = null;
MaterialCard mCard;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MTL_IN_PACK.RPT_MATERIAL_CARD_LABEL"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strSEQ_NO", seqNo);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstMCard = new List <MaterialCard>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
mCard = new MaterialCard();
mCard.ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO");
mCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
mCard.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
mCard.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
mCard.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
mCard.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
mCard.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
mCard.LOCATION_NAME = OraDataReader.Instance.GetString("LOCATION_NAME");
mCard.PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME");
if (!OraDataReader.Instance.IsDBNull("LOT_DATE"))
{
mCard.LOT_DATE = OraDataReader.Instance.GetDateTime("LOT_DATE");
}
mCard.QTY = OraDataReader.Instance.GetDecimal("QTY");
mCard.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
mCard.NO_OF_LABEL = OraDataReader.Instance.GetString("NO_OF_LABEL");
mCard.MIN_QTY = OraDataReader.Instance.GetDecimal("MIN_QTY");
mCard.MAX_QTY = OraDataReader.Instance.GetDecimal("MAX_QTY");
//prdCard.BARCODE = UtilityBLL.QRCode_Encode(prdCard.SERIAL_NO);
//prdCard.BARCODE = OraDataReader.Instance.GetBitmap("BARCODE");
//prdCard.BARCODE.Save(string.Format("C:\\Temp\\PicTemp2D\\{0}.BMP", prdCard.SERIAL_NO));
mCard.MTL_IMAGE = OraDataReader.Instance.GetBitmap("MTL_IMAGE");
lstMCard.Add(mCard);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstMCard = null;
throw ex;
}
//return this.ListToDataTable(lstPrdCard, tableName);
//DataTable dt = UtilityBLL.ListToDataTable(lstPrdCard, tableName);
return(UtilityBLL.ListToDataTable(lstMCard, tableName));
}
public void ScanLabel(string serialNo)
{
try
{
ResponseResult res = new ResponseResult();
using (ReplenishBLL repBll = new ReplenishBLL())
{
res = repBll.ScanRepLabel(serialNo, this.REP_NO, txtJobNo.Text, txtMCNo.Text, this.USER_ID);
}
if (res.Status)
{
if (res.Data != null)
{
MaterialCard matInfo = new MaterialCard();
matInfo = JsonConvert.DeserializeObject <MaterialCard>(res.Data.ToString());
this.lblLabelScan.Text = serialNo;
this.lblMtlCode.Text = matInfo.MTL_CODE;
this.lblMtlName.Text = matInfo.MTL_NAME;
this.lblGrade.Text = matInfo.MTL_GRADE;
this.lblColor.Text = matInfo.MTL_COLOR;
this.lblQty.Text = matInfo.QTY.ToString() + " " + matInfo.UNIT_ID;
if (res.Message == "OK")
{
this.SERIAL_NO = serialNo;
this.MATERIAL_CODE = matInfo.MTL_CODE;
this.SCAN_COUNTER++;
this.lblTotalQty.Text = String.Format("{0} / {1}", this.SCAN_COUNTER, this.txtNoOfLabel.Text);
this.SetActiveColor("txtSerialNo");
this.SetTextFocusControl(this.txtSerialNo, true);
if (this.SCAN_COUNTER == Convert.ToInt32(this.txtNoOfLabel.Text, NumberFormatInfo.CurrentInfo))
{
base.ShowCompletelyBox(string.Format("'{0}' {1}", this.lblProductNo.Text, ResourceManager.Instance.GetString("REPLENISH_COMPLETE")), ResourceManager.Instance.GetString("TITLE_INFORMATION"));
this.txtJobNo.Text = String.Empty;
this.txtMCNo.Text = String.Empty;
this.txtNoOfLabel.Text = String.Empty;
this.txtSerialNo.Text = string.Empty;
this.SetActiveColor("txtJobNo");
this.SetTextFocusControl(this.txtJobNo, true);
}
}
else
{
base.ShowWarningBox(string.Format("'{0}' {1}", serialNo, ResourceManager.Instance.GetString(res.Message)), ResourceManager.Instance.GetString("TITLE_PLEASE_CHECK"));
this.SetActiveColor("txtSerialNo");
this.SetTextFocusControl(this.txtSerialNo, true);
}
}
else
{
base.ShowWarningBox(string.Format("'{0}' {1}", serialNo, ResourceManager.Instance.GetString(res.Message)), ResourceManager.Instance.GetString("TITLE_PLEASE_CHECK"));
this.SetActiveColor("txtSerialNo");
this.SetTextFocusControl(this.txtSerialNo, true);
}
}
}
catch (WebException wex)
{
base.HideWaitProcess();
base.ShowErrorBox(wex.Message, "WebException");
this.SetActiveColor("txtSerialNo");
this.SetTextFocusControl(this.txtSerialNo, true);
}
catch (Exception ex)
{
base.HideWaitProcess();
base.ShowErrorBox(ex.Message, "Exception");
this.SetActiveColor("txtSerialNo");
this.SetTextFocusControl(this.txtSerialNo, true);
}
}
public ResponseResult ScanMixingLabel(string serialno, string mixedno, string mtlCode, string userid)
{
response = new ResponseResult();
MaterialCard mCard = null;
try
{
ProcParam procPara = new ProcParam(6)
{
ProcedureName = "SCANNER_MAT_CHK_PACK.SCAN_MIXED_LABEL"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strSERIAL_NO", serialno);
procPara.AddParamInput(2, "strMIXED_NO", mixedno);
procPara.AddParamInput(3, "strMTL_CODE", mtlCode);
procPara.AddParamInput(4, "strUSER_ID", userid);
procPara.AddParamOutput(5, "RESULTMSG", OracleDbType.Varchar2, 255);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
mCard = new MaterialCard()
{
SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO"),
PARTY_ID = OraDataReader.Instance.GetString("PARTY_ID"),
PARTY_NAME = OraDataReader.Instance.GetString("PARTY_NAME"),
MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE"),
MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME"),
MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE"),
MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR"),
QTY = OraDataReader.Instance.GetDecimal("QTY"),
UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID"),
ARRIVAL_NO = OraDataReader.Instance.GetString("ARRIVAL_NO"),
CARGO_STATUS = OraDataReader.Instance.GetString("CARGO_STATUS")
};
}
}
// Always call close when done reading.
OraDataReader.Instance.Close();
if (GlobalDB.Instance.DataAc.LastException != null)
{
throw GlobalDB.Instance.DataAc.LastException;
}
else
{
response.Message = procPara.ReturnValue(5).ToString();
response.Data = mCard;
}
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
}
return(response);
}
private void PrintProductCard_LABEL(List <T_ARRIVAL_DTL> jobOrdNo, string prodSEQNo, List <MaterialCard> lstPrdCard)
{
int printSeq = 0;
try
{
base.BeginProcessing("Begin Load Report...", "Please Waiting for Loading Report");
ReportViewer viewer = new ReportViewer();
viewer.AutoCloseAfterPrint = true;
XtraReport rpt = null;
DataSet ds;
using (ArrivalBLL jobOrdBll = new ArrivalBLL())
{
ds = jobOrdBll.PrintProductCardReport(jobOrdNo, prodSEQNo, lstPrdCard, this.USER_ID, out printSeq);
}
MaterialCard objMTL = null;
objMTL = lstPrdCard.Find(x => (x.WH_ID == "LC00002"));//PRESS
if (objMTL != null)
{
rpt = new RPT_MATERIAL_CARD_LABEL_PRESS();
//change ds val
}
else
{
rpt = new RPT_MATERIAL_CARD_LABEL_2();
//rpt = new RPT_MATERIAL_CARD_LABEL();
}
// }
// else
// {
// rpt = UiUtility.GetReportByName(fixRpt);
// }
if (rpt != null)
{
rpt.DataSource = ds;
rpt.Parameters["paramUserPrint"].Value = this.USER_ID;
rpt.CreateDocument();
viewer.SetReport(rpt);
viewer.LogPrintTime(printSeq);
base.FinishedProcessing();
viewer.ShowDialog();
}
else
{
XtraMessageBox.Show("Report is null");
}
}
catch (Exception ex)
{
base.FinishedProcessing();
XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
base.FinishedProcessing();
}
}
private void copyMatCardTable()
{
string sql = "SELECT ID, NППЗаказа, NППДетали, NДеталиОснастки, НаименованиеДетали, Материал, КузнечнаяОперация, РазмерыДетали, Количество, КоличествоДеталей, ФрезОбр, СтрогОбр, ШлифОбр, ВремяФрез, ВремяСтрог, ВремяШлиф, ВесЗаготовки, ВесВсего, ДополнДляЗакНар, ДатаРедактТехн, Склад, КодЕдИзм, CODEMAT, annealing, term, strogterm, ВесДетали, ordered, Материа FROM МатериальнаяКарта WHERE NППЗаказа>=80000";
OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.connStr);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
MaterialCard m = new MaterialCard();
m.matCardId = r.GetInt32(0);
m.orderId = r.GetInt32(1);
if (r[2] != DBNull.Value)
{
m.detailNumber = r.GetInt16(2);
}
if (r[3] != DBNull.Value)
{
m.detailTONumber = r.GetString(3);
}
if (r[4] != DBNull.Value)
{
m.detailTOTitle = r.GetString(4);
}
if (r[5] != DBNull.Value)
{
m.materialTitle = r.GetString(5);
}
if (r[6] != DBNull.Value)
{
m.blackSmithOp = r.GetString(6);
}
if (r[7] != DBNull.Value)
{
m.detailSize = r.GetString(7);
}
m.blankQty = r.GetFloat(8);
m.detailQty = r.GetFloat(9);
if (r[10] != DBNull.Value)
{
m.millingOp = r.GetString(10);
}
if (r[11] != DBNull.Value)
{
m.planerOp = r.GetString(11);
}
if (r[12] != DBNull.Value)
{
m.grindingOp = r.GetString(12);
}
if (r[13] != DBNull.Value)
{
m.millingTime = r.GetFloat(13);
}
if (r[14] != DBNull.Value)
{
m.planerTime = r.GetFloat(14);
}
if (r[15] != DBNull.Value)
{
m.grindingTime = r.GetFloat(15);
}
if (r[16] != DBNull.Value)
{
m.weight = r.GetFloat(16);
}
if (r[17] != DBNull.Value)
{
m.weightTotal = r.GetFloat(17);
}
if (r[18] != DBNull.Value)
{
m.supplementToOrder = r.GetBoolean(18);
}
if (r[19] != DBNull.Value)
{
m.technologyEditTime = r.GetDateTime(19);
}
if (r[20] != DBNull.Value)
{
m.storeId = r.GetInt16(20);
}
if (r[21] != DBNull.Value)
{
m.unitOfMeasureId = r.GetInt16(21);
}
if (r[22] != DBNull.Value)
{
m.materialCode = r.GetInt32(22);
}
if (r[23] != DBNull.Value)
{
m.annealing = r.GetBoolean(23);
}
if (r[24] != DBNull.Value)
{
m.thermalOp = r.GetString(24);
}
if (r[25] != DBNull.Value)
{
m.planerThermalOp = r.GetString(25);
}
if (r[26] != DBNull.Value)
{
m.detailWeight = r.GetDouble(26);
}
if (r[27] != DBNull.Value)
{
m.ordered = r.GetBoolean(27);
}
string json = JsonConvert.SerializeObject(m, Formatting.None, new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
});
// MessageBox.Show(json);
MaterialCard m2 = rest.saveEntity <MaterialCard>(m);
if (m2.matCardId < 1)
{
break;
}
}
r.Close();
cmd.Dispose();
conn.Close();
MessageBox.Show("Done!");
}
