private void ReceiptDetailByRef_Load(object sender, EventArgs e)
{
try
{
FullDataSet.ProductDataTable _pr = new FullDataSet.ProductDataTable();
_mainForm.productTableAdapter1.FillByName(_pr, "А");
_productTable.Merge(_pr);
this.productBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void Find_Click(object sender, EventArgs e)
{
string name = this.productlookUpEdit.Text;
if (name.Length == 0)
{
return;
}
try
{
FullDataSet.ProductDataTable _pr = new FullDataSet.ProductDataTable();
_mainForm.productTableAdapter1.FillByName(_pr, name);
_product.Merge(_pr);
this.productBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btFind_Click(object sender, EventArgs e)
{
string name = this.gridViewProduct.GetRowCellDisplayText(GridControl.AutoFilterRowHandle, this.colName);
if (name.Length == 0)
{
return;
}
try
{
FullDataSet.ProductDataTable _pr = new FullDataSet.ProductDataTable();
_mainForm.productTableAdapter1.FillByName(_pr, name);
_productTable.Merge(_pr);
this.productBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void Import()
{
DataTable _curTable = (this.bindingSource.DataSource as DataTable);
string orgName = this.label1.Text.Trim();
//(this.bindingSource1.Current as DataRowView).Row["firm"].ToString().Trim();
int _idOrg;
DataRow[] organization = (this.ParentForm as MainForm).mDataSet.Organization.Select("ShortName='" + @orgName + "'");
if (organization.Length == 0)
{
//MessageBox.Show("Не найден поставщик в справочнике организаций");
_idOrg = 0;
}
else
{
_idOrg = Convert.ToInt32(organization[0]["ID"]);
}
/*создать приход*/
MDataSet.ReceiptMasterRow _mast;
_mast = (this.receiptMasterBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptMasterRow;
_mast.DocDate = DateTime.Parse((_curTable).Rows[0]["datedoc"].ToString());
_mast.OrganizationRef = _idOrg;
_mast.Note = (_curTable).Rows[0]["numdoc"].ToString();
if ((Convert.ToDecimal((_curTable).Rows[0]["nds"].ToString())) != 0)
{
_mast.MainStockRef = 1;
FullDataSet.ProductDataTable _proTable = new FullDataSet.ProductDataTable();
this.productTableAdapter.Fill(_proTable, true);
this.fullDataSet.Product.Merge(_proTable);
}
this.receiptMasterBindingSource.EndEdit();
/**/
/**/
foreach (DataRow _row in _curTable.Rows)
{
/*Товар */
string _idstr = _row["SCLCODE"].ToString().Trim().Replace(" ", "");
int _id;
if (_idstr.Length == 0)
{
_id = 0;
}
else
{
_id = Convert.ToInt32(_idstr);
}
// string nameT = _row["sclname"].ToString().Trim();
string nameT = _row["sclname"].ToString().Trim();
FullDataSet.ProductRow _prRow;
_prRow = null;
_prRow = this.fullDataSet.Product.FindByID(_id);
if (_prRow == null)
{
DataRow[] arrPr = this.fullDataSet.Product.Select("OldName='" + nameT + "'");
if (arrPr.Length == 0)
{
_row.RowError = "Не найдена";
}
else
{
_prRow = arrPr[0] as FullDataSet.ProductRow;
}
}
/* изготовитель */
int manufRef = 0;
DataRow[] _arr = this.fullDataSet.Manufacturer.Select("Name like '" + @_row["SCLMKNM"].ToString().Substring(0, 4) + "%'");
if (_arr.Length != 0)
{
manufRef = (_arr[0] as FullDataSet.ManufacturerRow).ID;
}
if (!(_row.HasErrors))
{
MDataSet.ReceiptDetailRow _det;
/**добавлять в детаил потом аддинг */
_det = (this.receiptDetailBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptDetailRow;
_det.ProductRef = _prRow.ID;
_det.Quantity = _prRow.OldKol * Convert.ToDecimal(_row["kolvo"].ToString());
_det.PricePurchase = Convert.ToDecimal(_row["cena"].ToString()) / _prRow.OldKol;
_det.ManufacturerRef = manufRef;
if (_row["serie"].ToString().Length >= 15)
{
_det.Series = _row["serie"].ToString().Substring(0, 15);
}
else
{
_det.Series = _row["serie"].ToString();
}
_det.UseByDate = DateTime.Parse(_row["tgodn"].ToString());
this.receiptDetailBindingSource.EndEdit();
{
MDataSet.ReceiptDetailAddingRow _add;
_add = (this.receiptDetailAddingBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptDetailAddingRow;
_add.NUMSERTF = _row["NUMSERTF"].ToString();
_add.NUMREG = _row["NUMREG"].ToString();
_add.DATREG = DateTime.Parse(_row["DATREG"].ToString());
_add.ENDDATREG = DateTime.Parse(_row["ENDDATREG"].ToString());
_add.TAMZAV = Decimal.Parse(_row["TAMZAV"].ToString());
// _add.MAXNACENKA = Decimal.Parse(_row["maxnacenka"].ToString());
_add.DATSERTF = DateTime.Parse(_row["DATSERTF"].ToString());
this.receiptDetailAddingBindingSource.EndEdit();
}
}
}
}
public virtual FullDataSet.ProductDataTable GetDataByName(string name) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((name == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
}
FullDataSet.ProductDataTable dataTable = new FullDataSet.ProductDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual FullDataSet.ProductDataTable GetData(System.Nullable<bool> isnds) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((isnds.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((bool)(isnds.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
FullDataSet.ProductDataTable dataTable = new FullDataSet.ProductDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
private void Find_Click(object sender, EventArgs e)
{
string name = this.productlookUpEdit.Text;
if (name.Length == 0) return;
try
{
FullDataSet.ProductDataTable _pr = new FullDataSet.ProductDataTable();
_mainForm.productTableAdapter1.FillByName(_pr, name);
_product.Merge(_pr);
this.productBindingSource.ResetBindings(false);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void Import()
{
DataTable _curTable = (this.bindingSource.DataSource as DataTable);
string orgName = this.label1.Text.Trim();
//(this.bindingSource1.Current as DataRowView).Row["firm"].ToString().Trim();
int _idOrg;
DataRow[] organization = (this.ParentForm as MainForm).mDataSet.Organization.Select("ShortName='" +@orgName+"'");
if (organization.Length == 0)
{
//MessageBox.Show("Не найден поставщик в справочнике организаций");
_idOrg = 0;
}
else
{
_idOrg = Convert.ToInt32(organization[0]["ID"]);
}
/*создать приход*/
MDataSet.ReceiptMasterRow _mast;
_mast = (this.receiptMasterBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptMasterRow;
_mast.DocDate =DateTime.Parse((_curTable).Rows[0]["datedoc"].ToString());
_mast.OrganizationRef = _idOrg;
_mast.Note = (_curTable).Rows[0]["numdoc"].ToString();
if ((Convert.ToDecimal((_curTable).Rows[0]["nds"].ToString())) != 0)
{
_mast.MainStockRef = 1;
FullDataSet.ProductDataTable _proTable = new FullDataSet.ProductDataTable();
this.productTableAdapter.Fill(_proTable, true);
this.fullDataSet.Product.Merge(_proTable);
}
this.receiptMasterBindingSource.EndEdit();
/**/
/**/
foreach (DataRow _row in _curTable.Rows)
{
/*Товар */
string _idstr = _row["SCLCODE"].ToString().Trim().Replace(" ", "");
int _id;
if (_idstr.Length == 0)
{
_id = 0;
}
else
{
_id = Convert.ToInt32(_idstr);
}
// string nameT = _row["sclname"].ToString().Trim();
string nameT = _row["sclname"].ToString().Trim();
FullDataSet.ProductRow _prRow;
_prRow = null;
_prRow = this.fullDataSet.Product.FindByID(_id);
if (_prRow ==null)
{
DataRow[] arrPr = this.fullDataSet.Product.Select("OldName='" + nameT + "'");
if (arrPr.Length == 0)
_row.RowError = "Не найдена";
else
{
_prRow = arrPr[0] as FullDataSet.ProductRow;
}
}
/* изготовитель */
int manufRef = 0;
DataRow[] _arr = this.fullDataSet.Manufacturer.Select("Name like '"+@_row["SCLMKNM"].ToString().Substring(0,4) +"%'");
if (_arr.Length !=0)
manufRef = (_arr[0] as FullDataSet.ManufacturerRow).ID;
if (!(_row.HasErrors))
{
MDataSet.ReceiptDetailRow _det;
/**добавлять в детаил потом аддинг */
_det = (this.receiptDetailBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptDetailRow;
_det.ProductRef = _prRow.ID;
_det.Quantity = _prRow.OldKol * Convert.ToDecimal(_row["kolvo"].ToString());
_det.PricePurchase = Convert.ToDecimal(_row["cena"].ToString()) / _prRow.OldKol;
_det.ManufacturerRef = manufRef;
if (_row["serie"].ToString().Length>=15)
_det.Series = _row["serie"].ToString().Substring(0,15);
else
_det.Series = _row["serie"].ToString();
_det.UseByDate =DateTime.Parse( _row["tgodn"].ToString());
this.receiptDetailBindingSource.EndEdit();
{
MDataSet.ReceiptDetailAddingRow _add;
_add = (this.receiptDetailAddingBindingSource.AddNew() as DataRowView).Row as MDataSet.ReceiptDetailAddingRow;
_add.NUMSERTF = _row["NUMSERTF"].ToString();
_add.NUMREG = _row["NUMREG"].ToString();
_add.DATREG =DateTime.Parse(_row["DATREG"].ToString());
_add.ENDDATREG = DateTime.Parse(_row["ENDDATREG"].ToString());
_add.TAMZAV = Decimal.Parse(_row["TAMZAV"].ToString());
// _add.MAXNACENKA = Decimal.Parse(_row["maxnacenka"].ToString());
_add.DATSERTF = DateTime.Parse(_row["DATSERTF"].ToString());
this.receiptDetailAddingBindingSource.EndEdit();
}
}
}
}