// 그리드에 데이터 복사
public void AddDataToGrid(int grid1RowHandle, DataTable table, DevExpress.XtraGrid.Views.Grid.GridView gridView)
{
DataRow dataRow = gridView1.GetDataRow(grid1RowHandle);
table.ImportRow(dataRow);
gridView.RefreshData();
Application.DoEvents();
}
private void comboBoxEdit1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = GetDataTable(this.cmbLayer.Text);
this.gridControl1.DataSource = dt;
gridView1.RefreshData();
//this.gridControl1.MainView = this.gridView1;
gridView1.Columns["ErrorFeatureID"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gridView1.Columns["ErrorFeatureID"].SummaryItem.DisplayFormat = "合计：{0}";
gridView1.ExpandAllGroups();
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
view.RefreshData();
}
private void SetGroupNo(DevExpress.XtraGrid.Views.Grid.GridView gView, string GroupNo)
{
if (gView.SelectedRowsCount > 0)
{
int[] iHandle = gView.GetSelectedRows();
for (int j = 0; j < iHandle.Length; j++)
{
if (iHandle[j] < 0)
{
continue;
}
gView.SetRowCellValue(iHandle[j], "PositionType", GroupNo);
}
gView.RefreshData();
}
}
private void simpleButtonUpdate_Click(object sender, EventArgs e)
{
Config.NewKeyValue("Operation", (sender as SimpleButton).Text);
gvDetail.RefreshData();
if (_data.DsData.Tables[0].HasErrors)
{
XtraMessageBox.Show("Số liệu chưa hợp lệ, vui lòng kiểm tra lại trước khi lưu!");
return;
}
if (!_data.UpdateData())
{
DisplayData();
}
else
{
XtraMessageBox.Show("Hoàn tất cập nhật bảng số liệu");
}
}
public void AddRow(T entity)
{
if (gridView == null || gridView.GridControl == null)
{
return;
}
IList <T> list = gridView.GridControl.DataSource as IList <T>;
if (list == null)
{
list = new List <T>();
}
list.Add(entity);
gridView.GridControl.DataSource = list;
gridView.RefreshData();
this.Insert(entity);
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
////int[] rows = gridView1.GetSelectedRows();
//int[] g = view.GetSelectedRows();
//DataRow[] rows = new DataRow[view.SelectedRowsCount];
//for (int i = 0; i < view.SelectedRowsCount; i++)
// rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
//view.BeginSort();
//try
//{
// foreach (DataRow row in rows)
// row.Delete();
//}
//finally
//{
// view.EndSort();
//}
view.RefreshData();
}
private void GridView_Change()
{
try
{
for (int i = 0; i <= gridView1.RowCount; i++)
{
DataRow drDetl = gridView1.GetDataRow(i);
if (drDetl != null)
{
if (radioGroupType.SelectedIndex == 0)
{
SqlHelper.ExecuteNonQuery(connection, "up_Payr_InstructorFees",
new SqlParameter("@nClassInstanceID", drDetl["nClassInstanceID"]),
new SqlParameter("@mInstructorFees", Convert.ToDecimal(drDetl["mInstructorFees"])),
new SqlParameter("@nActualInstructorID", Convert.ToInt32(drDetl["nActualInstructorID"])),
new SqlParameter("@Year", Convert.ToInt32(drDetl["PYear"])),
new SqlParameter("@Year", Convert.ToInt32(drDetl["PMonth"])),
new SqlParameter("@PayRollID", nPayrollID)
);
}
else if (radioGroupType.SelectedIndex == 1)
{
SqlHelper.ExecuteNonQuery(connection, "up_Payr_StandingInstructorFees",
new SqlParameter("@nClassInstanceID", drDetl["nClassInstanceID"]),
new SqlParameter("@mStandinInstructorFees", Convert.ToDecimal(drDetl["mStandinInstructorFees"])),
new SqlParameter("@nStandinInstructorID", Convert.ToInt32(drDetl["nStandinInstructorID"])),
new SqlParameter("@Year", Convert.ToInt32(drDetl["PYear"])),
new SqlParameter("@Year", Convert.ToInt32(drDetl["PMonth"])),
new SqlParameter("@PayRollID", nPayrollID)
);
}
gridView1.RefreshData();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ValidMtID(DataColumn colMT, string value)
{
string fieldName = colMT.ColumnName;
foreach (CDTGridLookUpEdit tmp in _glist)
{
if (tmp.Properties.Buttons[0].Tag != null)
{
if ((tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString() == string.Empty)
{
continue;
}
if (!this.isRefreshed)
{
this.Refresh(this, new EventArgs());
this.isRefreshed = true;
}
if (fieldName.ToLower() == (tmp.Properties.Buttons[0].Tag as DataRow)["FieldName"].ToString().ToLower())
{
try
{
string query = (tmp.Properties.Buttons[0].Tag as DataRow)["QueryInsertDt"].ToString();
//xoa cac dong da nhap
DevExpress.XtraGrid.Views.Grid.GridView gvMain = gc.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
if (colMT.Table.TableName == "MT29" && fieldName == "MT2AID") //Piriou
{
gvMain.SelectAll();
gvMain.DeleteSelectedRows();
//gvMain.ClearSelection();
_data.LstDrCurrentDetails.Clear();
}
if (value == string.Empty)
{
continue;
}
DataTable dtTable;
query = query.Replace("@" + fieldName, value);
dtTable = _data.DbData.GetDataTable(query);
//Xác định khóa ngoại
DataRow[] RelaRow = _data.DsStruct.Tables[1].Select("refTable='" + _data.DrTableMaster["TableName"].ToString() + "'");
string RelaCol = _data.DrTableMaster["Pk"].ToString();
if (RelaRow.Length > 0)
{
RelaCol = RelaRow[0]["FieldName"].ToString();
}
for (int i = 0; i < dtTable.Rows.Count; i++)
{
DataRow drdt = dtTable.Rows[i];
DataRow drNew = _data.DsData.Tables[1].NewRow();
drNew[RelaCol] = _data.DrCurrentMaster[_data.DrTableMaster["Pk"].ToString()];
gvMain.RefreshData();
//int j = gvMain.DataRowCount;
foreach (DataColumn col in dtTable.Columns)
{
if (_data.DsData.Tables[1].Columns.Contains(col.ColumnName))
{
drNew[col.ColumnName] = drdt[col.ColumnName];
if (gvMain.Columns[col.ColumnName] == null)
{
continue;
}
{
GridColumn g = gvMain.Columns[col.ColumnName];
CDTRepGridLookup r = g.ColumnEdit as CDTRepGridLookup;
if (r == null)
{
continue;
}
BindingSource bs = r.DataSource as BindingSource;
if (!r.Data.FullData)
{
r.Data.GetData();
bs.DataSource = r.Data.DsData.Tables[0];
r.DataSource = bs;
}
//DataTable tbRep = bs.DataSource as DataTable;
//int index = r.GetIndexByKeyValue(drdt[g.FieldName]);
//if (index == -1) continue;
//DataRow RowSelected = tbRep.Rows[index];
//if (RowSelected != null)
//{
// //_data.SetValuesFromListDt(drNew, g.FieldName, drdt[g.FieldName].ToString(), RowSelected);
//}
}
}
}
_data.DsData.Tables[1].Rows.Add(drNew);
//_data.DsData.Tables[1].Rows.Add(_data.LstDrCurrentDetails[_data.LstDrCurrentDetails.Count - 1]);
}
// gvMain.AddNewRow();
//if (colMT.Table.TableName == "MTLSX" && fieldName == "MT35ID") //Bến Thành
//{
// foreach (DataRow m in _data.LstDrCurrentDetails)
// {
// if (m["MT35ID"].ToString() != value)
// {
// m["MT35ID"] = DBNull.Value;
// m["DT35ID"] = DBNull.Value;
// m.EndEdit();
// }
// }
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
private void MostrarSoloSeleccionados_checkButton_CheckedChanged(object sender, EventArgs e)
{
GlobalGridView.RefreshData();
}
private void btnRefundOrder_HbClick(object sender, EventArgs e)
{
JsonRequest request = new JsonRequest();
StringBuilder sql = new StringBuilder();
ProcAction retAction = request.NewAction();
retAction.proc = WebUtil.Values.PROC_SQL;
sql.Append("update tb_so_return set ret_yn = 'Y', up_id = #{up_id}, up_dt = current_timestamp, ");
sql.Append(" ret_price_total = #{ret_price_total}, ret_price_real = #{ret_price_real},");
sql.Append(" ret_reason = #{ret_reason} ");
sql.Append(" WHERE ord_no = #{ord_no} ");
retAction.text = sql.ToString();
retAction.param.Add("up_id", COM.UserInfo.UserID);
retAction.param.Add("ord_no", etOrdNo.Text);
retAction.param.Add("ret_price_total", etRetPriceTotal.Value);
retAction.param.Add("ret_price_real", etRetPriceReal.Value);
retAction.param.Add("ret_reason", etRetReason.Text);
retAction.param.Add("store_cd", COM.UserInfo.StoreCd);
retAction.param.Add("pos_no", COM.UserInfo.PosNo);
ProcAction logAction = request.NewAction();
logAction.proc = WebUtil.Values.PROC_SQL;
sql.Clear();
sql.Append("insert into tb_log_wms(ord_no, log_type, store_cd, pos_no, sale_dt, sale_tm, tran_no, in_dt, in_id) ");
sql.Append("values(#{ord_no}, #{log_type}, #{store_cd}, #{pos_no}, date_format(current_timestamp, '%Y%m%d'), date_format(current_timestamp, '%H%i%S'), get_next_tran_no2(#{store_cd}, #{pos_no}, null), current_timestamp, #{in_id}) ");
logAction.text = sql.ToString();
logAction.param.Add("ord_no", etOrdNo.Text);
logAction.param.Add("log_type", "return");
logAction.param.Add("store_cd", COM.UserInfo.StoreCd);
logAction.param.Add("pos_no", COM.UserInfo.PosNo);
logAction.param.Add("in_id", COM.UserInfo.UserID);
ProcAction ordAction = request.NewAction();
ordAction.proc = WebUtil.Values.PROC_SQL;
sql.Clear();
sql.Append("update tb_so_order set ret_yn = 'Y', up_id = #{up_id}, up_dt = current_timestamp ");
sql.Append(" WHERE ord_no = #{ord_no} ");
ordAction.text = sql.ToString();
ordAction.param.Add("up_id", COM.UserInfo.UserID);
ordAction.param.Add("ord_no", etOrdNo.Text);
ProcAction selectAction = request.NewAction();
selectAction.proc = WebUtil.Values.PROC_SQL;
selectAction.table = "ret";
sql.Clear();
sql.Append("select a.sale_dt, a.sale_tm, a.tran_no, date_format(a.in_dt, '%Y%m%d%H%i%S') open_dt, a.pay_info, b.point_no, b.full_name ");
sql.Append("from tb_so_return a ");
sql.Append(" left join tb_so_order b on a.ord_no = b.ord_no ");
sql.Append("where a.ord_no = #{ord_no} ");
selectAction.text = sql.ToString();
selectAction.param.Add("ord_no", etOrdNo.Text);
ProcAction selectLogAction = request.NewAction();
selectLogAction.proc = WebUtil.Values.PROC_SQL;
selectLogAction.table = "log";
sql.Clear();
sql.Append("select a.log_id, a.sale_dt, a.sale_tm, a.tran_no ");
sql.Append("from tb_log_wms a ");
sql.Append("where a.ord_no = #{ord_no} ");
sql.Append(" and a.log_type = 'order' ");
sql.Append("order by a.log_id desc limit 1 ");
selectLogAction.text = sql.ToString();
selectLogAction.param.Add("ord_no", etOrdNo.Text);
ProcAction itemAction = request.NewAction();
itemAction.proc = WebUtil.Values.PROC_SQL;
itemAction.table = "item";
sql.Clear();
sql.Append("select a.prod_cd plu_cd, @RANKT := @RANK + 1 item_seq, c.ex_cd item_cd, c.vndr_cd, concat(c.prod_nm, ' / ', c.prod_nm_ko) plu_nm, ");
sql.Append(" a.ret_qty sale_qty, a.ret_qty * a.unit_sale_price tot_amt, a.unit_sale_price sale_prc, a.ret_qty * a.unit_price tot_unit, a.unit_price ");
sql.Append("from tb_so_return_dtl a ");
sql.Append(" inner join (SELECT @RANK := 0) b ");
sql.Append(" left join tb_ma_product c on a.prod_cd = c.prod_cd ");
sql.Append("where a.ord_no = #{ord_no} ");
sql.Append(" and a.ret_qty > 0 ");
sql.Append("order by a.ord_seq asc ");
itemAction.text = sql.ToString();
itemAction.param.Add("ord_no", etOrdNo.Text);
WebClient client = new WebClient();
DataSet ds = client.Execute(request);
if (client.check)
{
gridView.SetFocusedRowCellValue("ret_yn", "Y");
gridView.SetFocusedRowCellValue("ret_reason", etRetReason.Text);
gridView.RefreshData();
DataTable dt = ds.Tables["ret"];
DataTable dtLog = ds.Tables["log"];
DataTable dtItem = ds.Tables["item"];
GetAvailPoint(dt, dtLog);
//double priceTotal = Convert.ToDouble(this.priceTotal);
//double pricePoint = Convert.ToDouble(this.pricePoint);
//double priceCard = Convert.ToDouble(this.priceCard);
//double priceCoupon = Convert.ToDouble(this.priceCoupon);
//double priceDc = pricePoint + priceCard + priceCoupon;
//double priceAll = priceTotal - priceDc;
double priceTotUnit = 0;
double priceTotSaleUnit = 0;
for (int i = 0; i < dtItem.Rows.Count; i++)
{
priceTotUnit += Convert.ToDouble(dtItem.Rows[i]["tot_unit"].ToString());
priceTotSaleUnit += Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString());
}
JObject wmsRequest = new JObject();
JObject irtModel = new JObject();
wmsRequest.Add("IRT_MODEL", irtModel);
JObject irtHeader = new JObject();
irtModel.Add("IRT_HEADER", irtHeader);
irtHeader.Add("WCC", "Q001");
irtHeader.Add("SALE_DY", dtLog.Rows[0]["sale_dt"].ToString());
irtHeader.Add("SITE_CD", COM.UserInfo.StoreCd);
irtHeader.Add("PROG_NO", COM.UserInfo.PosNo);
irtHeader.Add("RECEIPT_NO", dtLog.Rows[0]["tran_no"].ToString());
irtHeader.Add("TRAN_FG", "");
irtHeader.Add("DES_FG", "Y");
irtHeader.Add("ORG_LEN", "1000");
irtHeader.Add("STATUS", "");
irtHeader.Add("EMP_NO", "");
irtHeader.Add("SYSTEM", "WMSP");
JObject tranReq = new JObject();
irtModel.Add("TRAN_REQ", tranReq);
tranReq.Add("EJ_DATA", new JArray());
tranReq.Add("SIGN_DATAS", new JArray());
tranReq.Add("STORE_CD", COM.UserInfo.StoreCd);
tranReq.Add("POS_NO", COM.UserInfo.PosNo);
tranReq.Add("RECEIPT_NO", dtLog.Rows[0]["tran_no"].ToString());
tranReq.Add("SALE_DY", dtLog.Rows[0]["sale_dt"].ToString());
tranReq.Add("SALE_TM", dtLog.Rows[0]["sale_tm"].ToString());
tranReq.Add("REG_EMP_NO", "");
JObject trData = new JObject();
trData.Add("TRADE_CALL", new JArray());
trData.Add("TEMP_OFFER_LIST", new JArray());
trData.Add("STR_CD", COM.UserInfo.StoreCd);
trData.Add("SALE_DT", dtLog.Rows[0]["sale_dt"].ToString());
trData.Add("POS_NO", COM.UserInfo.PosNo);
trData.Add("SALE_TM", dtLog.Rows[0]["sale_tm"].ToString());
trData.Add("TRAN_NO", dtLog.Rows[0]["tran_no"].ToString());
trData.Add("TERMINAL_FG", "01");
trData.Add("MIX_TRAN_FG", "N");
trData.Add("TRAN_FG", "2"); //반품
trData.Add("TRANQ_FG", "0"); //수동반품
trData.Add("SAVE_FG", "");
//trData.Add("ORG_DT", dt.Rows[0]["sale_dt"].ToString());
//trData.Add("ORG_TM", dt.Rows[0]["sale_tm"].ToString());
//trData.Add("ORG_POS_NO", COM.UserInfo.PosNo);
//trData.Add("ORG_TRAN_NO", dt.Rows[0]["tran_no"].ToString());
//trData.Add("ORG_DT", dtLog.Rows[0]["sale_dt"].ToString());
//trData.Add("ORG_TM", dtLog.Rows[0]["sale_tm"].ToString());
//trData.Add("ORG_POS_NO", COM.UserInfo.PosNo);
//trData.Add("ORG_TRAN_NO", dtLog.Rows[0]["tran_no"].ToString());
trData.Add("ORG_DT", "");
trData.Add("ORG_TM", "");
trData.Add("ORG_POS_NO", "");
trData.Add("ORG_TRAN_NO", "");
trData.Add("JASA_SUMPAY_FG", "");
trData.Add("JASA_HALBU_FG", "");
trData.Add("TASA_SUMPAY_FG", "");
trData.Add("TASA_HALBU_FG", "");
trData.Add("CHECK_CARD_FG", "");
trData.Add("CASH_IC_CARD_FG", "");
trData.Add("GIFT_FG", "");
trData.Add("TRAN_TYPE_FG", "10");
trData.Add("CARD_CD", "");
trData.Add("FOR_FG", "K");
trData.Add("OPEN_DT", dt.Rows[0]["open_dt"].ToString());
trData.Add("CLOSE_DT", dtLog.Rows[0]["sale_dt"].ToString() + dtLog.Rows[0]["sale_tm"].ToString());
trData.Add("CASHIER_ID", "");
trData.Add("CASHIER_NAME", COM.UserInfo.UserName);
trData.Add("WON_AMT", 0.0);
trData.Add("RESON_CD", "3"); //기타사유
trData.Add("ORG_CASHIER_ID", "");
trData.Add("CUST_CD", custCd);
trData.Add("PGM_VER", "A");
trData.Add("MST_VER", "A");
trData.Add("POS_FG", "PS01");
trData.Add("GIFT_FREE_FG", "");
trData.Add("TAX_INVOICE_FG", "0");
trData.Add("PUR_LIMIT", "");
trData.Add("EMPTY_BOTTLE_SALE", "");
trData.Add("POS_IP", "");
trData.Add("EVT_NO", null);
trData.Add("FOREIGNER_NAME", "");
trData.Add("UNIONPAY_YN", "");
trData.Add("SPECIALCARD_YN", "");
trData.Add("PUBLICSERVANT_YN", "");
trData.Add("LPAY_FG", false);
trData.Add("VIC_MEMSALE", "");
trData.Add("VIC_MEM_CHARGE", "");
trData.Add("VIC_ONEDAY", "");
trData.Add("SPECIAL_CARD_SALE", "0");
trData.Add("LIQUOR_BEER_LITER", 0.0);
trData.Add("LIQUOR_SOJU_LITER", 0.0);
trData.Add("LIQUOR_FORIEN_LITER", 0.0);
trData.Add("LIQUOR_OTH_LITER", 0.0);
trData.Add("DCC_FG", "");
trData.Add("CREDT_FG", "");
trData.Add("EMP_DISCOUNTFG", false);
trData.Add("USER_PWD", null);
trData.Add("VIC_SALES", false);
trData.Add("LawDCCStep", "");
trData.Add("BioPayFlag", false);
trData.Add("BioOtcNo", "");
trData.Add("BioCardNm", "");
trData.Add("BioFlag", false);
trData.Add("BioModel", "");
trData.Add("WCardDcApplyFlag", false);
trData.Add("OverPayFlag", false);
trData.Add("SALE_AMT", priceTotUnit);
trData.Add("DC_AMT", priceTotUnit - priceTotSaleUnit);
trData.Add("TOT_AMT", priceTotSaleUnit);
JObject trTranSales = new JObject();
trData.Add("TR_TRAN_SALES", trTranSales);
JArray trItemList = new JArray();
trTranSales.Add("TR_ITEM_LIST", trItemList);
for (int i = 0; i < dtItem.Rows.Count; i++)
{
double qty = Convert.ToDouble(dtItem.Rows[i]["sale_qty"].ToString());
double unitPrice = Convert.ToDouble(dtItem.Rows[i]["unit_price"].ToString());
double salePrice = Convert.ToDouble(dtItem.Rows[i]["sale_prc"].ToString());
double unitTotal = Convert.ToDouble(dtItem.Rows[i]["tot_unit"].ToString());
double saleTotal = Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString());
JObject item = new JObject();
trItemList.Add(item);
item.Add("PLU_CD", dtItem.Rows[i]["plu_cd"].ToString());
item.Add("ITEM_SEQ", i + 1);
item.Add("ITEM_CD", dtItem.Rows[i]["item_cd"].ToString());
item.Add("CLASS_CD", "");
item.Add("BTL_CD", "");
item.Add("WEIGHT_CD", "");
item.Add("SALE_QTY", qty);
item.Add("TOT_AMT", unitTotal);
item.Add("InclusionAddTaxToDiscount", 0.0);
item.Add("CURR_SALE_PRC", unitPrice);
item.Add("ORG_SALE_PRC", unitPrice);
item.Add("NOR_SALE_PRC", unitPrice);
item.Add("NEW_PRC_FG", "0");
item.Add("ITEM_FG", "0");
item.Add("CANCEL_FG", "1");
item.Add("PLU_NM", dtItem.Rows[i]["plu_nm"].ToString());
item.Add("DC_FG", "02");
item.Add("DC_AMT", unitTotal - saleTotal);
item.Add("DC_VAL", 0);
item.Add("DC_REASON", "");
item.Add("ENURI_PER", 0.0);
item.Add("ENURI_AMT", 0.0);
item.Add("BOTTLE_PRC", 0.0);
item.Add("PBOX_PRC", 0.0);
item.Add("PBOX_CD", "");
item.Add("GREEN_PNT", 0.0);
item.Add("VNDR_CD", dtItem.Rows[i]["vndr_cd"].ToString());
item.Add("GREEN_PNT2", 0.0);
item.Add("SPECIAL_PNT", 0.0);
item.Add("FRESH_WEIGHT", 0.0);
item.Add("FRESH_QTY", 0.0);
item.Add("FRESH_DC_STICKER", "");
item.Add("PUBLIC_SERVANT_FLAG", "");
item.Add("TAX_FG", "2");
item.Add("TR_ITEM_DETAIL", null);
item.Add("OfferNmList", new JArray());
item.Add("TAX_RT", 0.0);
item.Add("GEO_FG", "1");
item.Add("RTNRESN_CODE", "");
item.Add("OriginalPrice", 0.0);
item.Add("TR_ITEM_COUPON", new JArray());
item.Add("REMARK", "");
item.Add("DESCRIPTION", "");
item.Add("SpecialCardNo", "");
item.Add("SpecialCardNoMask", "");
item.Add("INFANTFG", "");
item.Add("ITEMINFO", "");
item.Add("ITEM_LOCAL_CHECK", false);
item.Add("CalcPrice", salePrice);
item.Add("Position", 0);
item.Add("LIQUORFG", "000");
item.Add("LIQUOR_TOT_QTY", 0.0);
item.Add("STATFG", "1");
item.Add("DISP_UNIT", "");
item.Add("DISPTOTQTY", 0.0);
item.Add("DISPBASEQTY", 0.0);
item.Add("L3CD", "");
item.Add("PURCHASE_CAP_AMT", 0.0);
item.Add("EMP_DC_RT", 0.0);
item.Add("EMP_DC_EXCT_FG", "");
item.Add("PNT_EXCT_FG", "Y");
item.Add("DC_CPN_EXCT_FG", "");
item.Add("PNT_CPN_EXCT_FG", "");
item.Add("RCPT_CAMPAING_EXCT_FG", "");
item.Add("MINOR_LIMIT_FG", "");
item.Add("PIZZA_PRT_FG", "");
item.Add("ITEMFILLER1", dtItem.Rows[i]["plu_cd"].ToString());
item.Add("OFFERPLUPRTFG", "");
item.Add("OFFER_PLU_PRT_MARK", "");
item.Add("DISCOUNT_TYPE", "");
item.Add("EXPIRATION_DATE", "");
item.Add("PURCHASE_CAP_OVER_FG", false);
item.Add("OIL_AMT", 0.0);
item.Add("SCALE_FLAG", false);
item.Add("GOODS_RATE_CD", "00");
item.Add("itemWonAmt", 0.0);
item.Add("Subtotal", saleTotal);
item.Add("TaxSubtotal", saleTotal);
item.Add("GreenPntSum", 0.0);
item.Add("GreenSpecialPntSum", 0.0);
item.Add("DiscountTotal", unitTotal - saleTotal);
item.Add("TAX_AMT", 0);
item.Add("LOTTE_CARD_VOUCHER", "");
item.Add("POINT_RESERVE_RATE", 1.0);
item.Add("SALE_EVENT_DIV", "1");
item.Add("SALE_EVENT_NO", "");
item.Add("SALE_PRICE", salePrice);
item.Add("GROUP_EVENT_DIV", "1");
item.Add("GROUP_EVENT_NO", "");
item.Add("GROUP_PRICE_CD", "00");
item.Add("POINT_APP_AMT", 0.0);
item.Add("DEAL_TIME", dtLog.Rows[0]["sale_tm"].ToString());
JObject groupCdHash = new JObject();
item.Add("groupCdHash", groupCdHash);
groupCdHash.Add("00", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("01", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("02", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("03", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("04", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("05", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("06", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("07", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("08", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
groupCdHash.Add("09", Convert.ToDouble(dtItem.Rows[i]["tot_amt"].ToString()));
item.Add("GOODS_REGI_FG", "0");
item.Add("GOODS_REASON_DTL", null);
item.Add("Returntotal", saleTotal);
item.Add("DATA_STATE", "3");
}
JArray trTenderList = new JArray();
trTranSales.Add("TR_TENDER_LIST", trTenderList);
int seq = 0;
if (priceTotSaleUnit > 0)
{
seq++;
JObject tender = new JObject();
trTenderList.Add(tender);
tender.Add("TENDER_SEQ", seq);
tender.Add("TRAN_FG", "");
tender.Add("GOODS_TRAN_FG", "1");
tender.Add("RECEIVE_AMOUNT", priceTotSaleUnit);
tender.Add("SUBTOTAL_AMOUNT", priceTotSaleUnit);
JArray cashList = new JArray();
tender.Add("TR_TENDER_CASH", cashList);
tender.Add("TENDER_FG", "CA01");
JObject cash = new JObject();
cashList.Add(cash);
cash.Add("TENDER_SEQ", 1);
cash.Add("CASH_FG", "CA01");
cash.Add("RCV_AMT", priceTotSaleUnit);
cash.Add("PAY_AMT", priceTotSaleUnit);
cash.Add("CHG_AMT", 0);
tender.Add("TENDER_NM", "");
}
JObject trCashReceipt = new JObject();
trTranSales.Add("TR_CASHRECEIPT", trCashReceipt);
trCashReceipt.Add("NET_AMT", priceTotSaleUnit);
trCashReceipt.Add("TAX_AMT", 0.0);
trCashReceipt.Add("SVC_AMT", 0.0);
trCashReceipt.Add("TOT_AMT", priceTotSaleUnit);
trCashReceipt.Add("CASHBILL_FG", "");
trCashReceipt.Add("APPLY_FG", "");
trCashReceipt.Add("INPUT_DATA_FG", "");
trCashReceipt.Add("INPUT_DATA", "");
trCashReceipt.Add("INPUT_DATA_MASK", "");
trCashReceipt.Add("INPUT_FG", "01");
trCashReceipt.Add("APPLY_NO", "");
trCashReceipt.Add("AUTO_APPLY_FG", "00");
trCashReceipt.Add("VENDOR_CD", "");
trCashReceipt.Add("LPOINT_CASHBILL_FG", "0");
trTranSales.Add("TR_SPECAL_LIST", new JArray());
trTranSales.Add("TR_OFFER_SAVE", new JArray());
trTranSales.Add("TR_COUPON_LIST", new JArray());
JArray custInfoList = new JArray();
trTranSales.Add("CustInfoList", custInfoList);
JObject custInfo = new JObject();
custInfoList.Add(custInfo);
custInfo.Add("ANS_CD", "");
custInfo.Add("ANS_DESC", "");
custInfo.Add("CUST_CD", custCd);
custInfo.Add("CUST_NM", dt.Rows[0]["full_name"].ToString());
custInfo.Add("CUST_ABB", dt.Rows[0]["full_name"].ToString());
custInfo.Add("BUSI_NO", ""); // 모름
custInfo.Add("CEO_NM", dt.Rows[0]["full_name"].ToString());
custInfo.Add("GROUP_PRICE_CD", "00");
custInfo.Add("NATION_DIV", "V");
custInfo.Add("CUST_ADDR", "");
custInfo.Add("TEL_NO", "");
custInfo.Add("CEL_NO", custCd);
custInfo.Add("POINT_NO", dt.Rows[0]["point_no"].ToString());
custInfo.Add("ABLE_POINT", availPoint);
custInfo.Add("RESERVE_RATE", 1.0);
custInfo.Add("POINT_PWD", "");
custInfo.Add("CREDIT_TRADE_YN", "N");
custInfo.Add("LOAN_TRADE_YN", "N");
custInfo.Add("LOAN_AMT", "0");
custInfo.Add("MISU_AMT", "0");
custInfo.Add("DEAL_LIMIT_YN", "N");
custInfo.Add("DEAL_LIMIT_AMT", "0");
custInfo.Add("DEAL_AMT", "0");
custInfo.Add("CUST_SECTOR", "P");
custInfo.Add("SONATA_CD", "");
trTranSales.Add("ItemDiscountTotal", 0.0);
trTranSales.Add("ItemDiscountAmount", 0.0);
trTranSales.Add("ItemEnuriAmount", 0.0);
trTranSales.Add("ItemMCouponDiscountAmount", 0.0);
trTranSales.Add("ItemMCouponDiscountCount", 0);
trTranSales.Add("InfantAmount", 0.0);
trTranSales.Add("InfantDiscountAmount", 0.0);
trTranSales.Add("InfantSavePoint", 0.0);
trTranSales.Add("GiftAmount", 0.0);
trTranSales.Add("TenderMCouponCount", 0);
trTranSales.Add("TenderTotalAmount", priceTotSaleUnit);
trTranSales.Add("OpenCashDrawer", false);
trTranSales.Add("GetOfferTotalDiscount", 0);
trTranSales.Add("GetLPointCpn", new JArray());
string trInfo = JsonConvert.SerializeObject(trData);
string utf8String = Encoding.UTF8.GetString(Encoding.UTF8.GetBytes(trInfo));
byte[] bytes = Encoding.UTF8.GetBytes(utf8String);
string base64 = Convert.ToBase64String(bytes);
tranReq.Add("TR_DATA", base64);
COM.WmsSocket socket = new COM.WmsSocket();
JObject result = socket.Connect(30001, wmsRequest);
string reqInfo = JsonConvert.SerializeObject(wmsRequest);
string retInfo = JsonConvert.SerializeObject(result);
request = new JsonRequest();
logAction = request.NewAction();
logAction.proc = WebUtil.Values.PROC_SQL;
sql.Clear();
sql.Append("update tb_log_wms set req_info = #{req_info}, tr_info = #{tr_info}, ret_info = #{ret_info} ");
sql.Append(" WHERE log_id = #{log_id} ");
logAction.text = sql.ToString();
logAction.param.Add("log_id", dtLog.Rows[0]["log_id"]);
logAction.param.Add("req_info", reqInfo);
logAction.param.Add("tr_info", trInfo);
logAction.param.Add("ret_info", retInfo);
client = new WebClient();
client.Execute(request);
this.Close();
}
else
{
//MessageBox.Show(client.message);
XtraMessageBox.Show("Có lỗi xảy ra: \n" + client.message, "Lỗi");
}
}
private bool setSelectValue(object[] rows, bool isKeyDown)
{
Control ctl = this.Parent;
if (ctl == null || rows.Length == 0)
{
return(false);
}
DevExpress.XtraGrid.GridControl grdCtl = ctl as DevExpress.XtraGrid.GridControl;
if (grdCtl == null)
{
string sourceName = getSourceNameByTextField(_ColumnEditCfgInfo.TextFieldName);
if (!MB.Util.MyReflection.Instance.CheckObjectExistsProperty(rows[0], sourceName))
{
throw new MB.Util.APPException(string.Format("在赋值时类型 {0} 中不包含属性 {1} ,请检查对应的配置 {2} 是否正确!", rows[0].GetType().Name, sourceName, _ColumnEditCfgInfo.Name), Util.APPMessageType.SysErrInfo);
}
object stxt = MB.Util.MyReflection.Instance.InvokePropertyForGet(rows[0], sourceName);
this.Text = stxt.ToString();
return(false);
}
DevExpress.XtraGrid.Views.Grid.GridView gridView = grdCtl.DefaultView as DevExpress.XtraGrid.Views.Grid.GridView;
if (gridView.FocusedRowHandle < 0)
{
if (!isKeyDown)
{
//通过这种变态的方法自动增加一个空行，同时保证不重复增加
this.Text = "0";
this.Text = string.Empty;
}
}
object mainEntity = gridView.GetRow(gridView.FocusedRowHandle);
if (mainEntity == null)
{
throw new MB.Util.APPException("创建新对象为空,请检查 该绑定集合的Addnew是否设置为False", APPMessageType.SysErrInfo);
}
if (string.Compare(mainEntity.GetType().Name, "DataRowView", true) == 0)
{
System.Data.DataRowView drRow = mainEntity as System.Data.DataRowView;
foreach (MB.WinBase.Common.EditCtlDataMappingInfo info in _ColumnEditCfgInfo.EditCtlDataMappings)
{
object dataObject = rows[0];
if (!drRow.Row.Table.Columns.Contains(info.ColumnName))
{
MB.Util.TraceEx.Write(string.Format("在根据 XML 配置文件中 EditCtlDataMappings 数值行值时,发现配置值{0} 在指定的数据源中不存在", info.ColumnName));
continue;
}
object val = null;
if (!string.IsNullOrEmpty(info.SourceColumnName))
{
val = MB.Util.MyReflection.Instance.InvokePropertyForGet(rows[0], info.SourceColumnName);
}
if (val != null)
{
if (drRow[info.ColumnName] == null || drRow[info.ColumnName] == System.DBNull.Value || string.Compare(val.ToString(), drRow[info.ColumnName].ToString(), true) != 0)
{
drRow[info.ColumnName] = val;
}
}
else
{
drRow[info.ColumnName] = System.DBNull.Value;
}
}
gridView.RefreshData();
}
else
{
foreach (MB.WinBase.Common.EditCtlDataMappingInfo info in _ColumnEditCfgInfo.EditCtlDataMappings)
{
object dataObject = rows[0];
if (!MB.Util.MyReflection.Instance.CheckObjectExistsProperty(rows[0], info.SourceColumnName))
{
MB.Util.TraceEx.Write(string.Format("源数据中不包含属性{0}", info.SourceColumnName));
continue;
}
object val = MB.Util.MyReflection.Instance.InvokePropertyForGet(rows[0], info.SourceColumnName);
if (val != null)
{
MB.Util.MyReflection.Instance.InvokePropertyForSet(mainEntity, info.ColumnName, val.ToString());
}
else
{
MB.Util.MyReflection.Instance.InvokePropertyForSet(mainEntity, info.ColumnName, null);
}
}
}
object txt = MB.Util.MyReflection.Instance.InvokePropertyForGet(rows[0], _ColumnEditCfgInfo.TextFieldName);
this.Text = txt.ToString();
int entityHasCode = mainEntity.GetHashCode();
if (!_HasLoadData.ContainsKey(entityHasCode))
{
_HasLoadData.Add(entityHasCode, this.Text);
}
else
{
_HasLoadData[entityHasCode] = this.Text;
}
return(true);
}
