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); }