private void TransferItem(clsListItemMain itm)
{
try
{
using (var db = new Gobibase())
{
if (Transactionid == 0)
{
Transactionid = CFunctions.GetLastMassCounter();
CFunctions.SetLastMassCounter(1);
}
SqlConnection conn = new SqlConnection(db.Connection.ConnectionString);
SqlCommand cmd = new SqlCommand(@"INSERT INTO [t_orderlist] ([transactionid],[zahialgach],[zahnum],[createdU],[createdDate],[itemcode]) VALUES (@p1,@p2,@p3,@p4,@p5,@p6)", conn);
cmd.Parameters.Add("@p1", SqlDbType.Int).Value = Transactionid;
cmd.Parameters.Add("@p2", SqlDbType.NVarChar, 50).Value = txtOrder.Text;
cmd.Parameters.Add("@p3", SqlDbType.NVarChar, 50).Value = txtZahnum.Text;
cmd.Parameters.Add("@p4", SqlDbType.NVarChar, 50).Value = frmMain.cLoginUser.Uname;
cmd.Parameters.Add("@p5", SqlDbType.NVarChar, 50).Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
cmd.Parameters.Add("@p6", SqlDbType.NVarChar, 50).Value = itm.Itemcode;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Aлдаа гарлаа!" + Environment.NewLine + ex.Message, "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadListData(string _code)
{
try
{
Cursor.Current = Cursors.WaitCursor;
using (var db = new Gobibase())
{
lst_savedData.Clear();
SqlConnection conn = new SqlConnection(db.Connection.ConnectionString);
SqlCommand cmd = new SqlCommand(@"SELECT itemcode, lev5, lev6, lev7, lev8, lev9, color1, l6n, color2, l8n, l9n, colorpart FROM t_main AS m WHERE (zagvartype = N'масс') AND (SUBSTRING(itemcode, 1, 8) = @p1) order by itemcode;", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@p1", SqlDbType.NVarChar, 50).Value = _code;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
clsListItemMain g = new clsListItemMain();
g.Itemcode = dr.IsDBNull(0) ? "" : Core.ToStr(dr.GetString(0));
g.Lev5 = dr.IsDBNull(1) ? "" : Core.ToStr(dr.GetString(1));
g.Lev6 = dr.IsDBNull(2) ? "" : Core.ToStr(dr.GetString(2));
g.Lev7 = dr.IsDBNull(3) ? "" : Core.ToStr(dr.GetString(3));
g.Lev8 = dr.IsDBNull(4) ? "" : Core.ToStr(dr.GetString(4));
g.Lev9 = dr.IsDBNull(5) ? "" : Core.ToStr(dr.GetString(5));
g.Color1 = dr.IsDBNull(6) ? "" : Core.ToStr(dr.GetString(6));
g.L6n = dr.IsDBNull(7) ? "" : Core.ToStr(dr.GetString(7));
g.Color2 = dr.IsDBNull(8) ? "" : Core.ToStr(dr.GetString(8));
g.L8n = dr.IsDBNull(9) ? "" : Core.ToStr(dr.GetString(9));
g.L9n = dr.IsDBNull(10) ? "" : Core.ToStr(dr.GetString(10));
g.Colorpart = dr.IsDBNull(11) ? "" : Core.ToStr(dr.GetString(11));
g.Itemcodemain = g.Itemcode.Substring(0, 8);
g.IsSend = false;
lst_savedData.Add(g);
}
}
conn.Close();
dr.Close();
Cursor.Current = Cursors.Default;
}
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show("Aлдаа гарлаа!" + Environment.NewLine + ex.Message, "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnFind_Click(object sender, EventArgs e)
{
frmFindEZ f = new frmFindEZ();
f.ShowDialog();
if (f.Tag != null)
{
Itemcode = new clsListItemMain();
Itemcode = (clsListItemMain)f.Tag;
txtVer.Text = Itemcode.Version.ToString();
EhCode = Itemcode.Itemcode.Substring(0, 8);
CodeWord = Itemcode.Itemcode.Substring(0, 1);
for (int i = 1; i <= 9; i++)
{
Control[] tbxs = this.Controls.Find(("luplbl" + i), true);
if (tbxs != null && tbxs.Length > 0)
{
DevExpress.XtraEditors.LookUpEdit lup = tbxs[0] as DevExpress.XtraEditors.LookUpEdit;
lup.EditValueChanged -= new EventHandler(this.LookUp_EditValueChanged);
}
}
this.luplbl6.EditValueChanged -= new EventHandler(this.luplbl6_EditValueChanged);
SetControlValue();
for (int i = 1; i <= 9; i++)
{
Control[] tbxs = this.Controls.Find(("luplbl" + i), true);
if (tbxs != null && tbxs.Length > 0)
{
DevExpress.XtraEditors.LookUpEdit lup = tbxs[0] as DevExpress.XtraEditors.LookUpEdit;
lup.Properties.DataSource = lst_info.Where(s => (s.Angilal.Contains("W") || s.Angilal.Contains("S") || s.Angilal.Contains("K")) && s.L_name == "Level" + (i == 7 ? 5 : i)).OrderBy(o => o.Sortid).ToList();
lup.Properties.DisplayMember = "CodeName";
lup.Properties.ValueMember = "Code";
lup.EditValueChanged += new EventHandler(this.LookUp_EditValueChanged);
}
}
this.luplbl6.EditValueChanged += new EventHandler(this.luplbl6_EditValueChanged);
}
}
private void LoadData()
{
try
{
using (var db = new Gobibase())
{
list_main.Clear();
SqlConnection conn = new SqlConnection(db.Connection.ConnectionString);
SqlCommand cmd = new SqlCommand(@"SELECT m.[id],m.[itemcode],[itemname],[itemnameen],[lev1],[lev2],[lev3],[lev4],[lev5],
[lev6],[lev7],[lev8],[lev9],[createddate],u.uname, m.color1, m.color2,[l1n],[l2n],[l3n],
[l6n],[l8n],[l9n],[zagvartype],[itemcode_eh],u.id,
d.gobidugaar, d.onlinenum, d.code26, d.version
from t_main as m
inner join t_user as u on u.id = m.[createduser]
left outer join t_details as d on d.itemcode = m.itemcode
where [zagvartype] = N'эх загвар'" + CFunctions.StrMainWhere(true), conn);
cmd.CommandType = CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
clsListItemMain g = new clsListItemMain();
g.ID = dr.IsDBNull(0) ? 0 : Core.ToInt(dr.GetInt32(0));
g.Itemcode = dr.IsDBNull(1) ? "" : Core.ToStr(dr.GetString(1));
g.Itemname = dr.IsDBNull(2) ? "" : Core.ToStr(dr.GetString(2));
g.Itemnameen = dr.IsDBNull(3) ? "" : Core.ToStr(dr.GetString(3));
g.Lev1 = dr.IsDBNull(4) ? "" : Core.ToStr(dr.GetString(4));
g.Lev2 = dr.IsDBNull(5) ? "" : Core.ToStr(dr.GetString(5));
g.Lev3 = dr.IsDBNull(6) ? "" : Core.ToStr(dr.GetString(6));
g.Lev4 = dr.IsDBNull(7) ? "" : Core.ToStr(dr.GetString(7));
g.Lev5 = dr.IsDBNull(8) ? "" : Core.ToStr(dr.GetString(8));
g.Lev6 = dr.IsDBNull(9) ? "" : Core.ToStr(dr.GetString(9));
g.Lev7 = dr.IsDBNull(10) ? "" : Core.ToStr(dr.GetString(10));
g.Lev8 = dr.IsDBNull(11) ? "" : Core.ToStr(dr.GetString(11));
g.Lev9 = dr.IsDBNull(12) ? "" : Core.ToStr(dr.GetString(12));
g.Cdate = dr.IsDBNull(13) ? DateTime.Now : Core.ToDateTime(dr.GetDateTime(13));
g.Cuser = dr.IsDBNull(14) ? "" : Core.ToStr(dr.GetString(14));
g.Color1 = dr.IsDBNull(15) ? "" : Core.ToStr(dr.GetString(15));
g.Color2 = dr.IsDBNull(16) ? "" : Core.ToStr(dr.GetString(16));
g.L1n = dr.IsDBNull(17) ? "" : Core.ToStr(dr.GetString(17));
g.L2n = dr.IsDBNull(18) ? "" : Core.ToStr(dr.GetString(18));
g.L3n = dr.IsDBNull(19) ? "" : Core.ToStr(dr.GetString(19));
g.L6n = dr.IsDBNull(20) ? "" : Core.ToStr(dr.GetString(20));
g.L8n = dr.IsDBNull(21) ? "" : Core.ToStr(dr.GetString(21));
g.L9n = dr.IsDBNull(22) ? "" : Core.ToStr(dr.GetString(22));
g.Zagvartype = dr.IsDBNull(23) ? "" : Core.ToStr(dr.GetString(23));
g.Itemcode_eh = dr.IsDBNull(24) ? "" : Core.ToStr(dr.GetString(24));
g.Cuserid = dr.IsDBNull(25) ? 0 : Core.ToInt(dr.GetInt32(25));
g.Gobidugaar = dr.IsDBNull(26) ? "" : Core.ToStr(dr.GetString(26));
g.Onlinenum = dr.IsDBNull(27) ? "" : Core.ToStr(dr.GetString(27));
g.Code26 = dr.IsDBNull(28) ? "" : Core.ToStr(dr.GetString(28));
g.Version = dr.IsDBNull(29) ? 0 : Core.ToInt(dr.GetInt32(29));
list_main.Add(g);
}
}
conn.Close();
dr.Close();
gcMain.DataSource = list_main.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show("Aлдаа гарлаа!" + Environment.NewLine + ex.Message, "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private clsListItemMain LoadDataEh(string _p1)
{
clsListItemMain g = new clsListItemMain();
try
{
using (var db = new Gobibase())
{
SqlConnection conn = new SqlConnection(db.Connection.ConnectionString);
SqlCommand cmd = new SqlCommand(@"SELECT m.[id],[itemcode],[itemname],[itemnameen],[lev1],[lev2],[lev3],[lev4],[lev5],[lev6],[lev7],[lev8],[lev9],
[createddate],u.uname, color1, color2,[l1n],[l2n],[l3n],[l6n],[l8n],[l9n],[zagvartype],[itemcode_eh],u.id
from t_main as m inner join t_user as u on u.id = m.[createduser] where itemcode = @p1 and zagvartype = N'Эх загвар';", conn);
cmd.Parameters.Add("@p1", SqlDbType.NVarChar, 50).Value = _p1;
cmd.CommandType = CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
g.ID = dr.IsDBNull(0) ? 0 : Core.ToInt(dr.GetInt32(0));
g.Itemcode = dr.IsDBNull(1) ? "" : Core.ToStr(dr.GetString(1));
g.Itemname = dr.IsDBNull(2) ? "" : Core.ToStr(dr.GetString(2));
g.Itemnameen = dr.IsDBNull(3) ? "" : Core.ToStr(dr.GetString(3));
g.Lev1 = dr.IsDBNull(4) ? "" : Core.ToStr(dr.GetString(4));
g.Lev2 = dr.IsDBNull(5) ? "" : Core.ToStr(dr.GetString(5));
g.Lev3 = dr.IsDBNull(6) ? "" : Core.ToStr(dr.GetString(6));
g.Lev4 = dr.IsDBNull(7) ? "" : Core.ToStr(dr.GetString(7));
g.Lev5 = dr.IsDBNull(8) ? "" : Core.ToStr(dr.GetString(8));
g.Lev6 = dr.IsDBNull(9) ? "" : Core.ToStr(dr.GetString(9));
g.Lev7 = dr.IsDBNull(10) ? "" : Core.ToStr(dr.GetString(10));
g.Lev8 = dr.IsDBNull(11) ? "" : Core.ToStr(dr.GetString(11));
g.Lev9 = dr.IsDBNull(12) ? "" : Core.ToStr(dr.GetString(12));
g.Cdate = dr.IsDBNull(13) ? DateTime.Now : Core.ToDateTime(dr.GetDateTime(13));
g.Cuser = dr.IsDBNull(14) ? "" : Core.ToStr(dr.GetString(14));
g.Color1 = dr.IsDBNull(15) ? "" : Core.ToStr(dr.GetString(15));
g.Color2 = dr.IsDBNull(16) ? "" : Core.ToStr(dr.GetString(16));
g.L1n = dr.IsDBNull(17) ? "" : Core.ToStr(dr.GetString(17));
g.L2n = dr.IsDBNull(18) ? "" : Core.ToStr(dr.GetString(18));
g.L3n = dr.IsDBNull(19) ? "" : Core.ToStr(dr.GetString(19));
g.L6n = dr.IsDBNull(20) ? "" : Core.ToStr(dr.GetString(20));
g.L8n = dr.IsDBNull(21) ? "" : Core.ToStr(dr.GetString(21));
g.L9n = dr.IsDBNull(22) ? "" : Core.ToStr(dr.GetString(22));
g.Zagvartype = dr.IsDBNull(23) ? "" : Core.ToStr(dr.GetString(23));
g.Itemcode_eh = dr.IsDBNull(24) ? "" : Core.ToStr(dr.GetString(24));
g.Cuserid = dr.IsDBNull(25) ? 0 : Core.ToInt(dr.GetInt32(25));
}
}
conn.Close();
dr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Aлдаа гарлаа!" + Environment.NewLine + ex.Message, "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(g);
}
private void btnAddRow_Click(object sender, EventArgs e)
{
foreach (int i in gvSize.GetSelectedRows())
{
if (txtColorPart.Text == null || Core.ToStr(txtColorPart.Text) == "")
{
MessageBox.Show("Үйлдвэрийн өнгө талбар хоосон байна.!", "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtColorPart.Focus();
txtColorPart.SelectAll();
return;
}
clsInfo rw = (clsInfo)gvSize.GetRow(i);
try
{
Cursor.Current = Cursors.WaitCursor;
clsListItemMain g = new clsListItemMain();
g.ID = 0;
g.Itemcode = CreateNewCode(rw.Code);
if (g.Itemcode.Contains("#"))
{
MessageBox.Show(g.Itemcode + " гэсэн ITEMCODE Level дутуу оруулсан байна.!", " Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (CheckItemCode(g.Itemcode))
{
MessageBox.Show(g.Itemcode + " гэсэн ITEMCODE өмнө нь үүсгэсэн байна. Мэдээллээ шалгана уу.!", " Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Warning);
int index = gvList.LocateByValue("Itemcode", g.Itemcode);
if (index > -1)
{
gvList.FocusedRowHandle = index;
}
continue;
}
if (CheckItemCodeInLocal(g.Itemcode))
{
MessageBox.Show(g.Itemcode + " гэсэн ITEMCODE доор нэмсэн байна.!", " Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Warning);
int index = gvMain.LocateByValue("Itemcode", g.Itemcode);
if (index > -1)
{
gvMain.FocusedRowHandle = index;
}
continue;
}
g.Itemcode_eh = txtItemcode.Text;
g.Version_eh = Core.ToInt(txtVer.Text);
g.Itemname = Itemcode.Itemname;
g.Itemnameen = Itemcode.Itemnameen;
g.Lev1 = Itemcode.Lev1;
g.Lev2 = Itemcode.Lev2;
g.Lev3 = Itemcode.Lev3;
g.Lev4 = Itemcode.Lev4;
g.Lev5 = txtMainColor1.Text;
g.Lev6 = Core.ToStr(luplbl6.EditValue);
g.Lev7 = Core.ToStr(txtMainColor2.EditValue);
g.Lev8 = rw.Code;
g.Lev9 = Core.ToStr(luplbl9.EditValue);
g.Color1 = Core.ToStr(luplbl5.EditValue);
g.Color2 = Core.ToStr(luplbl7.EditValue);
g.L1n = Itemcode.L1n;
g.L2n = Itemcode.L2n;
g.L3n = Itemcode.L3n;
g.L6n = Core.ToStr(luplbl6.Text);
g.L8n = Core.ToStr(rw.Code) + " - " + Core.ToStr(rw.Name);
g.L9n = Core.ToStr(luplbl9.Text);
g.Itemcodemain = txtItemcode.Text.Substring(0, 8);
g.Colorpart = Core.ToStr(txtColorPart.Text);
list_main.Add(g);
gcMain.DataSource = list_main.ToList();
gvMain.FocusedRowHandle = gvMain.DataRowCount - 1;
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
Cursor.Current = Cursors.Default;
MessageBox.Show("Aлдаа гарлаа!" + Environment.NewLine + ex.Message, "Анхааруулга", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
