public Linq_098_098()
{
this._TestDS = DataSetHelper.CreateTestDataset();
}
public bool ConnectTo(MasterEntry me, string username, string userpsw)
{
string filename = GetFileName(me);
if (!File.Exists(filename))
{
throw new Exception($"Nav faila: [{filename}]");
}
if (CurrentDBTag != null)
{
try
{
Params.Save();
if (KlonsTableAdapterManager?.TUSERSTableAdapter?.Connection != null)
{
KlonsTableAdapterManager.TUSERSTableAdapter.Connection.StateChange -= Connection_StateChange;
}
}
catch (Exception) { }
}
_klonsDataSetHelper = new DataSetHelper(
typeof(KlonsPDataSet),
typeof(KlonsAdapters.TableAdapterManager),
typeof(KlonsAdapters.QueriesTableAdapter),
"ConnectionString1",
KlonsP.Properties.Settings.Default);
_dataSetHelpers["KlonsData"] = _klonsDataSetHelper;
_klonsRepDataSetHelper = new DataSetHelper(
typeof(KlonsPRepDataSet),
typeof(KlonsRepAdapters.TableAdapterManager),
null,
"ConnectionString1",
KlonsP.Properties.Settings.Default);
_dataSetHelpers["KlonsRep"] = _klonsRepDataSetHelper;
string newconnstr = MasterList.GetTemplateByName(me.ConnStr);
if (string.IsNullOrEmpty(newconnstr))
{
newconnstr = "character set=UTF8;" +
"data source=localhost;" +
@"initial catalog={0};" +
"user id=aivars;" +
"password=parole";
}
newconnstr = string.Format(newconnstr, filename, username);
var s1 = CheckConnectionString(newconnstr);
if (s1 == null)
{
throw new Exception($"Nekorekti pieslēguma dati:\n{newconnstr}");
}
newconnstr = s1;
_currentUserName = username;
_klonsDataSetHelper.ConnectTo(newconnstr);
_klonsRepDataSetHelper.ConnectTo(newconnstr);
KlonsTableAdapterManager.TUSERSTableAdapter.Connection.StateChange += Connection_StateChange;
KlonsTableAdapterManager.TUSERSTableAdapter.Connection.Open();
CurrentDBTag = new MasterEntry(me);
return(true);
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (ReadOnly)
{
return;
}
var productLocation = ProductLocationManager.GetVWByBranchAndDate(BranchID, Date);
DataSetHelper.DeleteAllRows(ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail);
short i = 0;
var rate = CurrencyRate;
var id = WarehouseDescriptionID;
var t_product = new DS_PurchaseOrderInfo.T_ProductDataTable();
foreach (var row in productLocation)
{
i++;
var newRow = ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail.NewSP_GetWarehouseDescriptionDetailRow();
newRow.WarehouseDescriptionID = id;
newRow.OrdinalNumber = i;
newRow.MedicamentID = row.MedicamentID;
newRow.MedicamentName = row.MedicamentName;
newRow.UnitsInStock = row.UnitsInStock;
newRow.ProductID = row.ProductID;
newRow[ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail.CountryCodeColumn] = row[productLocation.CountryCodeColumn.ColumnName];
newRow[ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail.BrandIDColumn] = row[productLocation.BrandIDColumn];
newRow.UnitPrice = row.StandardCost * rate;
newRow.Quantity = row.Quantity;
newRow.DescrQty = 0m;
ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail.AddSP_GetWarehouseDescriptionDetailRow(newRow);
t_product.AddT_ProductRow(row.ProductID);
}
DataTable t_xml = DataSetHelper.PackAlternationDataTable(t_product);
var purchaseInfo = ProductionManager.GetPurchaseOrderInfo(0, CurrencyCode, DataSetHelper.InnerBytesData(t_xml));
var view = new DataView(purchaseInfo);
view.Sort = purchaseInfo.ProductIDColumn.ColumnName;
foreach (var row in ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail)
{
if (DataSetHelper.IsDataRowDeleted(row))
{
continue;
}
var j = view.Find(row.ProductID);
if (j == -1)
{
continue;
}
var purchaseRow = (DS_PurchaseOrderInfo.SP_GetPurchaseOrderInfoRow)view[j].Row;
row.UnitPrice = ProductionManager.GetPurchaseUnitPrice(purchaseRow.UnitPrice, purchaseRow.AverageRate1, purchaseRow.AverageRate2);
}
}
private void btnMaterialsTransfer_Click(object sender, EventArgs e)
{
if (m_lnqWSCode == null)
{
return;
}
FormDataTableCheck frm =
new FormDataTableCheck(m_serverMaterials.GetMaterialsTransferInfo(m_lnqWSCode.WSCode));
frm.OnFormDataTableCheckFind += new GlobalObject.DelegateCollection.FormDataTableCheckFindDelegate(frm_OnFormDataTableCheckFind);
frm._BlDateTimeControlShow = true;
if (frm.ShowDialog() == DialogResult.OK)
{
List <string> listRequisition = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");
DataTable tempTable =
m_serverMaterials.SumMaterialsTransferGoods(listRequisition,
(int)CE_SubsidiaryOperationType.物料转换后, (int)CE_SubsidiaryOperationType.领料退库,
m_lnqWSCode.WSCode);
foreach (DataRow dr in tempTable.Rows)
{
S_MaterialListReturnedInTheDepot goods = new S_MaterialListReturnedInTheDepot();
goods.Bill_ID = m_billNo;
goods.GoodsID = Convert.ToInt32(dr["物品ID"]);
StoreQueryCondition condition = new StoreQueryCondition();
condition.GoodsID = Convert.ToInt32(txtCode.Tag);
condition.BatchNo = dr["批次号"].ToString();
condition.StorageID = m_strStorage;
S_Stock tempStock = m_serverStock.GetStockInfo(condition);
if (tempStock != null)
{
goods.Provider = tempStock.Provider;
goods.ProviderBatchNo = tempStock.ProviderBatchNo;
}
else
{
goods.Provider = "";
goods.ProviderBatchNo = "";
}
goods.BatchNo = dr["批次号"].ToString();
goods.ReturnedAmount = Convert.ToDecimal(dr["数量"]);
goods.Remark = txtRemark.Text;
goods.ShelfArea = "";
goods.ColumnNumber = "";
goods.LayerNumber = "";
//产品状态 设置 2012.3.30 by cjb
if (cmbProductStatus.Text.Trim() != "")
{
if (cmbProductStatus.Text.Trim() == "已返修")
{
goods.RepairStatus = true;
}
else
{
goods.RepairStatus = false;
}
}
if (!m_goodsServer.AddGoods(goods, out m_error))
{
MessageDialog.ShowErrorMessage(m_error);
return;
}
}
m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
RefreshDataGridView(m_queryGoodsInfo);
}
}
static void TrainNetwork()
{
network.Train(DataSetHelper.GetDatasetsFromFile(learningFileName, learningFileDelimiter, network.InputLayer.Count, network.OutputLayer.Count), minimumError: 0.06f);
}
protected override bool SaveData()
{
view.CloseEditor();
bsGrid.EndEdit();
DS_WarehouseDescription.SP_GetWarehouseDescriptionDetailDataTable t1 = DataSetHelper.PackAlternationTypedDataTable <DS_WarehouseDescription.SP_GetWarehouseDescriptionDetailDataTable>(ds_WarehouseDescription.SP_GetWarehouseDescriptionDetail);
DataSetHelper.RemoveColumns(t1, true,
t1.WarehouseDescriptionDetailIDColumn,
t1.OrdinalNumberColumn,
t1.ProductIDColumn,
t1.MedicamentIDColumn,
t1.CountryCodeColumn,
t1.BrandIDColumn,
t1.UnitPriceColumn,
t1.QuantityColumn,
t1.DescrQtyColumn,
t1.CommentColumn,
t1.ActionColumn
);
var id = ProductionManager.AddOrEditWarehouseDescription(WarehouseDescriptionID, BranchID, Date, ProductCount, ProductQty, DescrQty, ProductTotalDue, DescrTotalDue, CurrencyCode, DataSetHelper.InnerBytesData(t1), Status, CreateDate, CreatorID, BaseGlobalVariable.ServerDateTime, BaseGlobalVariable.UserID, ApproverID, Action);
if (id > 0)
{
WarehouseDescriptionID = id;
if (!OptionsEditForm.IsSaveAndCloseExecuting)
{
BindingDetail();
}
}
return(id > 0);
}
private void miChangeCurrencyCode_ItemClick(object sender, ItemClickEventArgs e)
{
if (!IsAllowedEdit || !IsPermitted(DatabaseAction.Edit))
{
return;
}
try
{
Application.DoEvents();
using (var frm = new frmChangeCurencyCode())
{
if (frm.ShowDialog(this) != DialogResult.OK)
{
return;
}
Cursor = Cursors.WaitCursor;
var table = new DS_Product.T_ProductIDDataTable();
foreach (var id in OptionsGrid.SelectedRecordIDs)
{
table.AddT_ProductIDRow((int)id);
}
DataSetHelper.SetColumnMappingType(table);
ProductionManager.ChangeProductCurrencyCode(frm.ProductCurrencyCode, frm.ChangePrice, DataSetHelper.InnerBytesData(table), BaseGlobalVariable.ServerDateTime, BaseGlobalVariable.UserID);
}
}
catch (Exception ex)
{
ExceptionHelper.Show(this, ex, "შეცდომა პ/ე ვალუტის შეცვლისას", MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
private static void ExportBin(string filePath, string filename)
{
ByteArray ba = new ByteArray();
Assembly asm = Assembly.LoadFile(Application.dataPath + "/../Library/ScriptAssemblies/Assembly-CSharp.dll");
DataSet dataSet = DataSetHelper.CreateDataSet(filePath + filename + FILE_SUFFIX);
if (dataSet != null)
{
//int sheetNum = dataSet.Tables.Count;
int canreadSheet = 0;
foreach (DataTable sheet in dataSet.Tables)
{
string className = sheet.TableName;
object obj = asm.CreateInstance(className);
//Debug.Log("当前表名是： " + sheet.TableName);
if (obj == null)
{
continue;
}
++canreadSheet;
}
ba.writeInt(canreadSheet);
//Converter.WriteInt(writer, sheetNum);
foreach (DataTable sheet in dataSet.Tables)
{
string className = sheet.TableName;
object obj = asm.CreateInstance(className);
if (obj == null)
{
//MUtils.ShowNotice("Load data error: "+className+" in "+filePath+" has no data.");
continue;
}
FieldInfo[] fis = obj.GetType().GetFields();
ba.writeUTF(sheet.TableName);
//Converter.WriteJavaString(writer,sheet.TableName);
int rows = sheet.Rows.Count;
int rowCount = 0;
for (int r = 0; r != rows; ++r)
{
if (string.IsNullOrEmpty(sheet.Rows[r].ItemArray[0].ToString()))
{
break;
}
rowCount++;
}
ba.writeInt(rowCount);
if (rows > 0)
{
ba.writeInt(sheet.Rows[0].ItemArray.Length);
}
else
{
ba.writeInt(0);
}
foreach (DataRow row in sheet.Rows)
{
int i = 0;
foreach (object item in row.ItemArray)
{
if (i >= fis.Length)
{
break;
}
if (fis[i].FieldType == typeof(int))
{
int val = 0;
int.TryParse(item.ToString(), out val);
ba.writeInt(val);
}
else if (fis[i].FieldType == typeof(short))
{
short val = 0;
short.TryParse(item.ToString(), out val);
ba.writeShort(val);
}
else if (fis[i].FieldType == typeof(long))
{
long val = 0;
long.TryParse(item.ToString(), out val);
ba.writeLong(val);
}
else if (fis[i].FieldType == typeof(float) || fis[i].FieldType == typeof(double) ||
fis[i].FieldType == typeof(string))
{
ba.writeUTF(item.ToString());
}
++i;
}
}
}
}
//string binpath = AssetBundlePath.GetStreamingAssetsPath() + "bin/".Replace("file://","");
string binpath = AssetBundlePath.GetStreamingAssetsPath().Replace("file://", "");
binpath = binpath.Replace("file://", "");
var file = new FileStream(binpath + filename + FILE_BIN_SUFFIX, FileMode.Create, System.IO.FileAccess.Write);
byte[] bytes = ba.data;
file.Write(bytes, 0, bytes.Length);
file.Close();
}
public void Synchronize(ObjectNames objectName, DataSet ds, bool isOnline)
{
string xml = DataSetHelper.InnerXmlData(ds);
try
{
var id = SynchronizationManager.Synchronize(objectName, BaseGlobalVariable.UserID, BaseGlobalVariable.ServerDateTime, DatabaseAction.Synchronize, isOnline, DataSetHelper.InnerBytesData(xml));
if (id <= 0)
{
throw new Exception("შეცდომა ცხრილის სინქრონიზაციის დროს.");
}
}
catch
{
if (isOnline)
{
txtServerErrorObjectID.Text = ((int)objectName).ToString();
memoServerXml.Text = xml;
}
else
{
txtLocalErrorObjectID.Text = ((int)objectName).ToString();
memoLocalXml.Text = xml;
}
throw;
}
}
public static DataSet DsApDocListing_Detail(DateTime d1, DateTime d2, string partyTo, string docType, string userId)
{
DataSet set = new DataSet();
DataTable mast = new DataTable("Mast");
mast.Columns.Add("Title");
mast.Columns.Add("DatePeriod");
mast.Columns.Add("UserId");
mast.Columns.Add("Index");
mast.Columns.Add("DocNo");
mast.Columns.Add("DocType");
mast.Columns.Add("DocDate");
mast.Columns.Add("DueDate");
mast.Columns.Add("PartyId");
mast.Columns.Add("PartyName");
mast.Columns.Add("ChqNo");
mast.Columns.Add("Currency");
mast.Columns.Add("ExRate");
mast.Columns.Add("LocAmt");
mast.Columns.Add("AcCode");
mast.Columns.Add("AcDesc");
mast.Columns.Add("DbAmt");
mast.Columns.Add("CrAmt");
mast.Columns.Add("LocDbAmt");
mast.Columns.Add("LocCrAmt");
mast.Columns.Add("DbAmt1");
mast.Columns.Add("CrAmt1");
mast.Columns.Add("LocDbAmt1");
mast.Columns.Add("LocCrAmt1");
string sql = "";
if (docType == "PL" || docType == "SC" || docType == "SD")
{
sql = string.Format(@"SELECT SequenceId, AcCode, AcSource, SupplierBillNo AS DocNo, DocType, DocDate AS DocDate, PartyTo, CurrencyId, ExRate, '' AS ChqNo, DocAmt, LocAmt
FROM XAApPayable where DocDate>='{0}' and DocDate<'{1}' and DocType='{2}'", d1.ToString("yyyy-MM-dd"), d2.AddDays(1).ToString("yyyy-MM-dd"), docType);
if (partyTo.Length > 0 && "null" != partyTo)
{
sql += " and PartyTo'" + partyTo + "'";
}
sql += " order by PartyTo,DocType,DocNo";
}
else if (docType == "PS" || docType == "SR")
{
sql = string.Format(@"SELECT SequenceId, AcCode, AcSource, DocNo, DocType, DocDate, PartyTo, CurrencyId, ExRate, ChqNo, DocAmt, LocAmt
FROM XAApPayment where DocDate>='{0}' and DocDate<'{1}' and DocType='{2}'", d1.ToString("yyyy-MM-dd"), d2.AddDays(1).ToString("yyyy-MM-dd"), docType);
if (partyTo.Length > 0 && "null" != partyTo)
{
sql += " and PartyTo'" + partyTo + "'";
}
sql += " order by PartyTo,DocType,DocNo";
}
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnectString"].ConnectionString;
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
// Call Read before accessing data.
int index = 1;
while (reader.Read())
{
string sequenceId = reader["SequenceId"].ToString();
string sql_det = "";
string title = "AP SUPPLIER INVOICE LISTING";
if (docType == "PL")
{
sql_det = string.Format("SELECT AcCode, AcSource, DocAmt, LocAmt FROM XAApPayableDet where DocId='{0}'", sequenceId);
}
else if (docType == "SD")
{
title = "AP SUPPLIER DEBIT NOTE LISTING";
sql_det = string.Format("SELECT AcCode, AcSource, DocAmt, LocAmt FROM XAApPayableDet where DocId='{0}'", sequenceId);
}
else if (docType == "SC")
{
title = "AP SUPPLIER CREDIT NOTE LISTING";
sql_det = string.Format("SELECT AcCode, AcSource, DocAmt, LocAmt FROM XAApPayableDet where DocId='{0}'", sequenceId);
}
else if (docType == "PS")
{
title = "AP SUPPLIER PAYMENT LISTING";
sql_det = string.Format("SELECT AcCode, AcSource, DocAmt, LocAmt FROM XAApPaymentDet WHERE PayId = '{0}'", sequenceId);
}
else if (docType == "PC")
{
title = "AP SUPPLIER REFUND LISTING";
sql_det = string.Format("SELECT AcCode, AcSource, DocAmt, LocAmt FROM XAApPaymentDet WHERE PayId = '{0}'", sequenceId);
}
decimal locAmt = SafeValue.SafeDecimal(reader["LocAmt"], 0);
decimal docAmt = SafeValue.SafeDecimal(reader["DocAmt"], 0);
DataTable tab = Helper.Sql.List(sql_det);
for (int i = 0; i < tab.Rows.Count; i++)
{
DataRow row1 = mast.NewRow();
row1["Title"] = title;
row1["DatePeriod"] = string.Format("Doc Date :{0} To :{1}", d1.ToString("dd/MM/yyyy"), d2.ToString("dd/MM/yyyy"));
row1["UserId"] = userId;
row1["Index"] = index;
row1["DocNo"] = reader["DocNo"].ToString();
row1["DocType"] = docType;
row1["DocDate"] = SafeValue.SafeDateStr(reader["DocDate"]);
row1["DueDate"] = "";
if (docType == "IV" || docType == "CN" || docType == "DN")
{
row1["DueDate"] = SafeValue.SafeDateStr(reader["DocDueDate"]);
}
string partyId1 = reader["PartyTo"].ToString();
string partyName1 = EzshipHelper.GetPartyName(partyId1);
row1["PartyId"] = partyId1;
row1["PartyName"] = partyName1;
row1["ChqNo"] = reader["ChqNo"].ToString();
row1["Currency"] = reader["CurrencyId"].ToString();
row1["ExRate"] = SafeValue.SafeDecimal(reader["ExRate"], 1).ToString("0.000");
row1["LocAmt"] = 0;
row1["AcCode"] = tab.Rows[i]["AcCode"].ToString();
row1["DbAmt"] = 0;
row1["CrAmt"] = 0;
row1["LocDbAmt"] = 0;
row1["LocCrAmt"] = 0;
string acDorc1 = tab.Rows[i]["AcSource"].ToString();
decimal detDocAmt = SafeValue.SafeDecimal(tab.Rows[i]["DocAmt"], 0);
decimal detLocAmt = SafeValue.SafeDecimal(tab.Rows[i]["LocAmt"], 0);
if (acDorc1 == "DB")
{
row1["DbAmt"] = detDocAmt;
row1["LocDbAmt"] = detLocAmt;
if (docAmt > 0)
{
row1["DbAmt1"] = detDocAmt.ToString("#,##0.00");
row1["LocDbAmt1"] = detLocAmt.ToString("#,##0.00");
}
}
else
{
row1["CrAmt"] = SafeValue.SafeDecimal(tab.Rows[i]["DocAmt"], 0);
row1["LocCrAmt"] = SafeValue.SafeDecimal(tab.Rows[i]["LocAmt"], 0);
if (docAmt > 0)
{
row1["CrAmt1"] = detDocAmt.ToString("#,##0.00");
row1["LocCrAmt1"] = detLocAmt.ToString("#,##0.00");
}
}
mast.Rows.Add(row1);
if (i == 0)
{
DataRow row = mast.NewRow();
row["Title"] = title;
row["DatePeriod"] = string.Format("Doc Date :{0} To :{1}", d1.ToString("dd/MM/yyyy"), d2.ToString("dd/MM/yyyy"));
row["UserId"] = userId;
row["Index"] = index;
row["DocNo"] = reader["DocNo"].ToString();
row["DocType"] = docType;
row["DocDate"] = SafeValue.SafeDateStr(reader["DocDate"]);
row["DueDate"] = "";
if (docType == "IV" || docType == "CN" || docType == "DN")
{
row["DueDate"] = SafeValue.SafeDateStr(reader["DocDueDate"]);
}
string partyId = reader["PartyTo"].ToString();
string partyName = EzshipHelper.GetPartyName(partyId);
row["PartyId"] = partyId;
row["PartyName"] = partyName;
row["ChqNo"] = reader["ChqNo"].ToString();
row["Currency"] = reader["CurrencyId"].ToString();
row["ExRate"] = SafeValue.SafeDecimal(reader["ExRate"], 1).ToString("0.000");
row["LocAmt"] = locAmt.ToString("#,##0.00");
row["AcCode"] = reader["AcCode"].ToString();
row["DbAmt"] = 0;
row["CrAmt"] = 0;
row["LocDbAmt"] = 0;
row["LocCrAmt"] = 0;
string acDorc = reader["AcSource"].ToString();
if (acDorc == "DB")
{
row["DbAmt"] = docAmt;
row["LocDbAmt"] = locAmt;
if (docAmt > 0)
{
row["DbAmt1"] = docAmt.ToString("#,##0.00");
row["LocDbAmt1"] = locAmt.ToString("#,##0.00");
}
}
else
{
row["CrAmt"] = docAmt;
row["LocCrAmt"] = locAmt;
if (docAmt > 0)
{
row["CrAmt1"] = docAmt.ToString("#,##0.00");
row["LocCrAmt1"] = locAmt.ToString("#,##0.00");
}
}
mast.Rows.Add(row);
}
else if (i == tab.Rows.Count - 1)
{
index++;
}
}
}
reader.Close();
reader.Dispose();
DataSetHelper help = new DataSetHelper();
DataTable tab1 = help.SelectGroupByInto("table1", mast, "AcCode,sum(DbAmt) DbAmt,sum(CrAmt) CrAmt,sum(LocDbAmt) LocDbAmt,sum(LocCrAmt) LocCrAmt", "", "AcCode");
DataTable rptDet = new DataTable("Detail");
rptDet.Columns.Add("AcCode");
rptDet.Columns.Add("AcDesc");
rptDet.Columns.Add("DbAmt");
rptDet.Columns.Add("CrAmt");
rptDet.Columns.Add("LocDbAmt");
rptDet.Columns.Add("LocCrAmt");
for (int i = 0; i < tab1.Rows.Count; i++)
{
DataRow rptRow = rptDet.NewRow();
rptRow["AcCode"] = tab1.Rows[i]["AcCode"];
rptRow["AcDesc"] = GetObj("Select AcDesc from XXChartAcc where Code='" + tab1.Rows[i]["AcCode"] + "'");
rptRow["DbAmt"] = tab1.Rows[i]["DbAmt"];
rptRow["CrAmt"] = tab1.Rows[i]["CrAmt"];
rptRow["LocDbAmt"] = tab1.Rows[i]["LocDbAmt"];
rptRow["LocCrAmt"] = tab1.Rows[i]["LocCrAmt"];
rptDet.Rows.Add(rptRow);
}
set.Tables.Add(mast);
set.Tables.Add(rptDet);
return(set);
}
public static void SetNewIDs(params string[] tablenames)
{
DataRow[] drs;
foreach (var tablename in tablenames)
{
switch (tablename)
{
case "CAT1":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.CAT1);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.CAT1Row;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_CAT1_ID();
}
break;
case "CATD":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.CATD);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.CATDRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_CATD_ID();
}
break;
case "CATT":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.CATT);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.CATTRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_CATT_ID();
}
break;
case "PLACES":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.PLACES);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.PLACESRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_PLACES_ID();
}
break;
case "DEPARTMENTS":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.DEPARTMENTS);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.DEPARTMENTSRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_DEPARTMENTS_ID();
}
break;
case "ITEMS":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.ITEMS);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.ITEMSRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_ITEMS_ID();
}
break;
case "ITEMS_EVENTS":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.ITEMS_EVENTS);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.ITEMS_EVENTSRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_ITEMS_EVENTS_ID();
}
break;
case "TAXDEPRECYEAR":
drs = DataSetHelper.GetNewRows(MyData.DataSetKlons.TAXDEPRECYEAR);
foreach (var dr in drs)
{
var pdr = dr as KlonsPDataSet.TAXDEPRECYEARRow;
if (pdr.ID >= 0)
{
continue;
}
pdr.ID = (int)MyData.KlonsQueriesTableAdapter.SP_GEN_TAXDEPRECYEAR_ID();
}
break;
}
}
}
public void InputQuestionsBank(int courseID, DataTable questionsTable)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
try
{
questionsTable = DataSetHelper.OrderBy(questionsTable, "考题ID,选项");
List <string> lstQuestions = DataSetHelper.ColumnsToList_Distinct(questionsTable, "考题ID");
foreach (string questionsID in lstQuestions)
{
DataTable tempQuestions = DataSetHelper.SiftDataTable(questionsTable, "考题ID = '" + questionsID + "'");
if (tempQuestions.Rows.Count > 0)
{
CE_HR_Train_QuesitonsType quesType =
GeneralFunction.StringConvertToEnum <CE_HR_Train_QuesitonsType>(tempQuestions.Rows[0]["考题类型"].ToString());
HR_Train_QuestionBank bank = new HR_Train_QuestionBank();
switch (quesType)
{
case CE_HR_Train_QuesitonsType.判断题:
bank.Answer = tempQuestions.Rows[0]["答案"].ToString().ToUpper();
bank.CourseID = courseID;
bank.ID = Guid.NewGuid();
bank.Questions = tempQuestions.Rows[0]["考题内容"].ToString();
bank.Type = tempQuestions.Rows[0]["考题类型"].ToString();
ctx.HR_Train_QuestionBank.InsertOnSubmit(bank);
break;
case CE_HR_Train_QuesitonsType.单选题:
case CE_HR_Train_QuesitonsType.多选题:
Guid guid = Guid.NewGuid();
bank.Answer = tempQuestions.Rows[0]["答案"].ToString().ToUpper();
bank.CourseID = courseID;
bank.ID = guid;
bank.Questions = tempQuestions.Rows[0]["考题内容"].ToString();
bank.Type = tempQuestions.Rows[0]["考题类型"].ToString();
ctx.HR_Train_QuestionBank.InsertOnSubmit(bank);
ctx.SubmitChanges();
foreach (DataRow dr in tempQuestions.Rows)
{
HR_Train_QuestionBank_Option option = new HR_Train_QuestionBank_Option();
option.OptionContent = dr["选项内容"].ToString();
option.OptionTag = dr["选项"].ToString().ToUpper();
option.QuestionID = guid;
ctx.HR_Train_QuestionBank_Option.InsertOnSubmit(option);
}
ctx.SubmitChanges();
break;
default:
break;
}
}
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
throw new Exception(ex.Message);
}
}
private void iCardGift_ItemClick(object sender, ItemClickEventArgs e)
{
if (gridView.SelectedRowsCount != 1)
{
return;
}
try
{
Application.DoEvents();
Cursor = Cursors.WaitCursor;
var rowguid = ((DS_Sales.VW_SalesOrderHeaderRow)gridView.GetDataRow(OptionsGrid.SelectedRowHandle)).rowguid;
var id = ConvertHelper.ToInt32(OptionsGrid.SelectedRecordID);
if (id == 0)
{
return;
}
using (var frm = new frmCardGiftEdit())
{
frm.IsOnline = IsOnline;
frm.PrimaryKey = id;
if (frm.ShowDialog(this) != DialogResult.OK)
{
return;
}
if (frm.IsOnline)
{
using (var ds = new DataSet("root"))
{
var t1 = DataSetHelper.PackAlternationDataTable(frm.T_CardHandle);
var t2 = DataSetHelper.PackAlternationDataTable(frm.ds_Operation.T_Operation);
ds.Tables.Add(t1);
ds.Tables.Add(t2);
CardManager.SaveCardHandle(DataSetHelper.InnerBytesData(ds), BaseGlobalVariable.UserID);
}
}
else
{
SynchronizationManager.SynchronizeSalesOrder(id, DataSetHelper.PackAlternationDataTable(frm.T_CardHandle), DataSetHelper.PackAlternationDataTable(frm.ds_Operation.T_Operation));
}
BindGrid();
//SyncOrder(id, DataSetHelper.PackAlternationDataTable(frm.T_CardHandle), DataSetHelper.PackAlternationDataTable(frm.ds_Operation.T_Operation));
var serverSalesOrderID = SalesManager.FindSalesOrderID(rowguid);
if (serverSalesOrderID == 0)
{
throw new Exception("სერვერზე გადაგზავნილი ფაქტურა არ მოიძებნა");
}
SaveAndPrintAct(serverSalesOrderID);
}
}
catch (Exception ex)
{
ExceptionHelper.Show(ex);
}
finally
{
Cursor = Cursors.Default;
}
}
private void btnSaveUserInGroup_Click(object sender, EventArgs e)
{
if (!IsPermitted(ObjectNames.UserInGroup, DatabaseAction.Manage))
{
XtraMessageBox.Show(this, "თქვენ არ გაქვთ უფლება მომხმარებლის ჯგუფებში განაწილების.", "გაფრთხილება", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try
{
Application.DoEvents();
Cursor = Cursors.WaitCursor;
btnSaveUserInGroup.Enabled = false;
DS_User.SP_GetUserInGroupDataTable table = DataSetHelper.PackAlternationTypedDataTable <DS_User.SP_GetUserInGroupDataTable>(ds_Right.SP_GetUserInGroup);
table.PrimaryKey = null;
DataSetHelper.RemoveColumns(table, true, table.UserGroupIDColumn, table.ActionColumn);
var ds = new DataSet("root");
ds.Tables.Add(table);
var id = UserManager.AddOrEditUserInGroup(UserID, 0, BaseGlobalVariable.UserID, BaseGlobalVariable.ServerDateTime, (DatabaseAction.Add | DatabaseAction.Delete), DataSetHelper.InnerBytesData(ds));
if (id > 0)
{
ds_Right.SP_GetUserInGroup.AcceptChanges();
}
else
{
XtraMessageBox.Show(this, "მონაცემი არ შენახულა.", "შეცდომა", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
BindingUserInGroup(false);
}
catch (Exception ex)
{
XtraMessageBox.Show(this, "შეცდომა მომხმარებლის ჯგუფებში განაწილებისას.\r" + ex.Message, "შეცდომა", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
private void FilterGrid()
{
string pattern = DataSetHelper.EscapeLikeValue(txtFilter.Text);
((DataTable)grdRoles.DataSource).DefaultView.RowFilter = String.Format("{0} LIKE '%{1}%'", COLUMN_ROLENAME, pattern);
}
