void TimChaConMoi(CompanyControl tempchacon) { if (tempchacon.Location.Y < caomotcap * LevelMax) { CompanyControl cha = new CompanyControl(); CompanyControl cungcap = new CompanyControl(); int kcchacony = 10000; int kchaconx = 10000; //Tim cha foreach (CompanyControl controlcu in dstemp) { if (controlcu.Location.Y < tempchacon.Location.Y) { int khoangcachchacony = Math.Abs(controlcu.Location.Y - tempchacon.Location.Y); int khoangcachchaconx = Math.Abs(controlcu.Location.X - tempchacon.Location.X); if (khoangcachchacony <= kcchacony && khoangcachchaconx <= kchaconx) { cha = controlcu; kcchacony = khoangcachchacony; kchaconx = khoangcachchaconx; } } } //Tim cung cap foreach (CompanyControl controlcu in dstemp) { if (controlcu.Tag.ToString() == cha.Name.ToString()) { cungcap = controlcu; break; } } DialogResult r; r = MessageBox.Show(String.Format("'{0}' sẽ thuộc '{1}'.Bạn có muốn cập nhật?", tempchacon.txtName.Text, cha.txtName.Text), "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (r == DialogResult.Yes) { string tentable = cungcap.tentable; string matable = tentable.Substring(3); string matablecha = cha.tentable.Substring(3); if (matablecha != "Company") { DBEngine.exec(String.Format("Insert into {0} ({1}ID,{2}Code,{3}Name) values({4},'{5}','{6}')", tentable, matablecha, matable, matable, cha.ID, tempchacon.txtCode.Text, tempchacon.txtName.Text)); } else { DBEngine.exec(String.Format("Insert into {0} ({1}Code,{2}Name) values('{3}','{4}')", tentable, matable, matable, tempchacon.txtCode.Text, tempchacon.txtName.Text)); } LoadTree(); } } }
private void EZLog(string Action, string keyName, string oldValue, string newValue, string TableName, string strEmpID) { try { DBEngine.exec("sp_EZLogMasterData", "@Action", Action, "@KeyName", keyName, "@EmployeeID", strEmpID, "@OldValue", oldValue, "@NewValue", newValue, "@FunctionClassName", string.Format("DataSetting.{0}", TableName), "@ScreenName", screenName, "@LoginID", UIMessage.userID); } catch (Exception ex) { throw ex; } }