private void btnAddCategory_Click(object sender, EventArgs e) { UnitName = txtUnit.Text.ToString().Trim().Replace("'", "''"); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; //chkNull or Empty if (UnitName == "") { FUNCT.msgWarning("Please Key Unit!"); txtUnit.Focus(); return; } else { //chkDup if (DB.DBQuery("SELECT OIDUNIT FROM Unit WHERE UnitName = N'" + UnitName + "' ").getString() != "") { FUNCT.msgWarning("Unit is Duplicate!"); txtUnit.Focus(); return; } else { //Confirm Save if (FUNCT.msgQuiz("Save Unit ? ") == true) { sql = "INSERT INTO Unit (UnitName, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate) VALUES(N'" + UnitName + "', '" + strCREATE + "', GETDATE(), '" + strCREATE + "', GETDATE())"; //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save Unit is Successufull."); this.Close(); } } } } }
private void btnAddCategory_Click(object sender, EventArgs e) { FabricPart = txtFabricParts.Text.ToString().Trim().Replace("'", "''"); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; //chkNull or Empty if (FabricPart == "") { FUNCT.msgWarning("Please Key Fabric Parts !"); txtFabricParts.Focus(); return; } else { //chkDup if (DB.DBQuery("SELECT TOP(1) OIDGParts FROM GarmentParts WHERE GarmentParts = N'" + FabricPart + "' ").getString() != "") { FUNCT.msgWarning("Fabric Parts is Duplicate!"); txtFabricParts.Focus(); return; } else { //Confirm Save if (FUNCT.msgQuiz("Save Fabric Parts ? ") == true) { sql = "INSERT INTO GarmentParts (GarmentParts, CreatedBy, CreatedDate) VALUES(N'" + FabricPart + "', '" + strCREATE + "', GETDATE())"; //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save Fabric Parts is Successufull."); this.Close(); } } } } }
private void btnAddCustomer_Click(object sender, EventArgs e) { string CustomerName = txtCustomerName.Text.ToString().Trim().Replace("'", "''"); string CustomerShortName = txtCustomerShortName.Text.ToString().Trim().Replace("'", "''"); CustomerCode = txtCustomerCode.Text.ToString().Trim().Replace("'", "''"); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; if (CustomerName == "") { chkNull("CustomerName", txtCustomerName); } else if (CustomerShortName == "") { chkNull("CustomerShortName", txtCustomerShortName); } else if (CustomerCode == "") { chkNull("CustomerCode", txtCustomerCode); } else { //chkDup if (DB.DBQuery("SELECT TOP (1) ShortName From Customer WHERE ShortName = '" + CustomerShortName + "' ").getString() != "") { FUNCT.msgWarning("CustomerShortName is Duplicate!"); txtCustomerShortName.Focus(); return; } else if (DB.DBQuery("SELECT TOP(1) Code FROM Customer WHERE Code = '" + CustomerCode + "' ").getString() != "") { FUNCT.msgWarning("CustomerCode is Duplicate!"); txtCustomerCode.Focus(); return; } else { if (FUNCT.msgQuiz("SAVE Customer?") == true) { sql = "INSERT INTO Customer(Name, ShortName, Code, CustomerType, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate) VALUES (N'" + CustomerName + "', N'" + CustomerShortName + "', N'" + CustomerCode + "', '9', '" + strCREATE + "', GETDATE(), '" + strCREATE + "', GETDATE())"; bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save Customer is Successfull."); this.Close(); } } } } }
private void btnAddCustomer_Click(object sender, EventArgs e) { ColorNo = txeColorNo.Text.ToString().ToUpper().Trim().Replace("'", "''"); string ColorName = txeColorName.Text.ToString().Trim().Replace("'", "''"); string ColorType = cbeColorType.EditValue.ToString(); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; if (ColorNo == "") { chkNull("Color No.", txeColorNo); } else if (ColorName == "") { chkNull("Color Name", txeColorName); } else if (cbeColorType.Text.Trim() == "") { chkNull("Color Type", cbeColorType); } else { //chkDup if (DB.DBQuery("SELECT TOP(1) ColorNo FROM ProductColor WHERE (ColorType = '" + ColorType + "') AND (ColorNo = N'" + ColorNo + "') ").getString() != "") { FUNCT.msgWarning("Color No. is Duplicate!"); txeColorNo.Focus(); return; } else { if (FUNCT.msgQuiz("SAVE Color ?") == true) { sql = "INSERT INTO ProductColor(ColorNo, ColorName, ColorType, CreatedBy, CreatedDate) VALUES(N'" + ColorNo + "', N'" + ColorName + "', '" + ColorType + "', '" + strCREATE + "', GETDATE()) "; //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save Color is Successfull."); this.Close(); } } } } }
private void btnAddStyle_Click(object sender, EventArgs e) { StyleName = txtStyleName.Text.ToString().Trim().Replace("'", "''"); string CategoryName = glCategoryName.Text.ToString(); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; //chkNull or Empty if (StyleName == "") { FUNCT.msgWarning("Please Key StyleName!"); txtStyleName.Focus(); return; } else if (CategoryName == "") { FUNCT.msgWarning("Please Select CategoryName!"); glCategoryName.Focus(); return; } else { //chkDup if (DB.DBQuery("SELECT TOP(1) StyleName FROM ProductStyle WHERE StyleName = '" + StyleName + "' ").getString() != "") { FUNCT.msgWarning("StyleName is Duplicate!"); txtStyleName.Focus(); return; } else { //Confirm Save if (FUNCT.msgQuiz("Save StyleName ? ") == true) { sql = "INSERT INTO ProductStyle (StyleName, OIDGCATEGORY, CreatedBy, CreatedDate) VALUES(N'" + StyleName + "', '" + glCategoryName.EditValue.ToString() + "', '" + strCREATE + "', GETDATE())"; //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save StyleName is Successufull."); this.Close(); } } } } }
private void btnAddCategory_Click(object sender, EventArgs e) { UseFor = txtUseFor.Text.ToString().Trim().Replace("'", "''"); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; //chkNull or Empty if (UseFor == "") { FUNCT.msgWarning("Please Key UseFor!"); txtUseFor.Focus(); return; } else { //chkDup if (DB.DBQuery("SELECT TOP(1) OIDUF FROM SMPLUseFor WHERE UseFor = N'" + UseFor + "' ").getString() != "") { FUNCT.msgWarning("UseFor is Duplicate!"); txtUseFor.Focus(); return; } else { //Confirm Save if (FUNCT.msgQuiz("Save UseFor ? ") == true) { StringBuilder sbSQL = new StringBuilder(); sbSQL.Append("INSERT INTO SMPLUseFor (OIDUF, UseFor, CreatedBy) "); sbSQL.Append(" SELECT MAX(OIDUF) + 1 AS OIDUF, N'" + UseFor + "' AS UseFor, '" + strCREATE + "' AS CreatedBy "); sbSQL.Append(" FROM SMPLUseFor "); //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sbSQL).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save UseFor is Successufull."); this.Close(); } } } } }
private void M11_01_FormClosed(object sender, FormClosedEventArgs e) { if (Application.OpenForms.OfType <M11>().Count() > 0) { var frmD01 = Application.OpenForms.OfType <M11>().FirstOrDefault(); StringBuilder sbSQL = new StringBuilder(); sbSQL.Append("SELECT CategoryName, OIDGCATEGORY AS ID "); sbSQL.Append("FROM GarmentCategory "); sbSQL.Append("ORDER BY CategoryName "); new ObjDE.setGridLookUpEdit(frmD01.glueCategory, sbSQL, "CategoryName", "ID").getData(true); if (CategoryName != "") { frmD01.glueCategory.EditValue = DB.DBQuery("SELECT TOP(1) OIDGCATEGORY FROM GarmentCategory WHERE CategoryName=N'" + CategoryName + "'").getString(); } frmD01.glueCategory.Properties.View.PopulateColumns(frmD01.glueCategory.Properties.DataSource); frmD01.glueCategory.Properties.View.Columns["ID"].Visible = false; } }
private void btnAddCustomer_Click(object sender, EventArgs e) { CusCode = txeCode.Text.ToString().ToUpper().Trim().Replace("'", "''"); string CusName = txeName.Text.ToString().Trim().Replace("'", "''"); string CusType = cbeType.EditValue.ToString(); string strCREATE = this._UserID.ToString() != "" ? this._UserID.ToString() : "0"; if (CusCode == "") { chkNull("Vendor Code", txeCode); } else if (CusName == "") { chkNull("Vendor Name", txeName); } else if (cbeType.Text.Trim() == "") { chkNull("Vendor Type", cbeType); } else { //chkDup if (DB.DBQuery("SELECT TOP(1) OIDVEND FROM Vendor WHERE (Code = N'" + CusCode + "') ").getString() != "") { FUNCT.msgWarning("Vendor Code is Duplicate!"); txeCode.Focus(); return; } else { if (FUNCT.msgQuiz("SAVE Supplier (Vendor) ?") == true) { sql = "INSERT INTO Vendor(Code, Name, VendorType, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate) VALUES(N'" + CusCode + "', N'" + CusName + "', '" + CusType + "', '" + strCREATE + "', GETDATE(), '" + strCREATE + "', GETDATE()) "; //Console.WriteLine(sql); bool chkSave = DB.DBQuery(sql).runSQL(); if (chkSave == true) { FUNCT.msgInfo("Save Supplier (Vendor) is Successfull."); this.Close(); } } } } }
private void DEV01_M07_FormClosed(object sender, FormClosedEventArgs e) { if (Application.OpenForms.OfType <DEV01>().Count() > 0) { var frmD01 = Application.OpenForms.OfType <DEV01>().FirstOrDefault(); StringBuilder sbSQL = new StringBuilder(); if (this._tmpType == "FB") //Fabric { sbSQL.Append("SELECT Code, Description, Type, ID "); //fabric & temporary sbSQL.Append("FROM ("); sbSQL.Append(" SELECT Code, Description, 'Fabric' AS Type, MaterialType, OIDITEM AS ID FROM Items WHERE (MaterialType = '" + TYPE_FABRIC + "') "); sbSQL.Append(" UNION ALL "); sbSQL.Append(" SELECT Code, Description, 'Temporary' AS Type, MaterialType, OIDITEM AS ID FROM Items WHERE (MaterialType = '" + TYPE_TEMPORARY + "') AND (Code LIKE 'TMPFB%') "); sbSQL.Append(") AS FBCode "); sbSQL.Append("ORDER BY MaterialType, Code "); new ObjDE.setSearchLookUpEdit(frmD01.slFBCode_FB, sbSQL, "Code", "ID").getData(); frmD01.slFBCode_FB.Properties.View.PopulateColumns(frmD01.slFBCode_FB.Properties.DataSource); frmD01.slFBCode_FB.Properties.View.Columns["ID"].Visible = false; frmD01.rep_slueFBCode.DataSource = frmD01.slFBCode_FB.Properties.DataSource; frmD01.rep_slueFBCode.DisplayMember = "Code"; frmD01.rep_slueFBCode.ValueMember = "ID"; frmD01.rep_slueFBCode.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; frmD01.rep_slueFBCode.View.PopulateColumns(frmD01.rep_slueFBCode.DataSource); frmD01.rep_slueFBCode.View.Columns["ID"].Visible = false; frmD01.lblDescription.Text = "-"; frmD01.lblDescription.AppearanceItemCaption.BackColor = Color.Empty; } else if (this._tmpType == "MT") //Material { sbSQL.Append("SELECT Code, Description, Type, ID "); //fabric & temporary sbSQL.Append("FROM ("); sbSQL.Append(" SELECT Code, Description, 'Meterial' AS Type, MaterialType, OIDITEM AS ID FROM Items WHERE (MaterialType IN ('" + TYPE_ACCESSORY + "', '" + TYPE_PACKAGING + "')) "); sbSQL.Append(" UNION ALL "); sbSQL.Append(" SELECT Code, Description, 'Temporary' AS Type, MaterialType, OIDITEM AS ID FROM Items WHERE (MaterialType = '" + TYPE_TEMPORARY + "') AND (Code LIKE 'TMPMT%') "); sbSQL.Append(") AS FBCode "); sbSQL.Append("ORDER BY MaterialType, Code "); new ObjDE.setSearchLookUpEdit(frmD01.slMatCode_Mat, sbSQL, "Code", "ID").getData(); frmD01.slMatCode_Mat.Properties.View.PopulateColumns(frmD01.slMatCode_Mat.Properties.DataSource); frmD01.slMatCode_Mat.Properties.View.Columns["ID"].Visible = false; frmD01.rep_MtrItem.DataSource = frmD01.slMatCode_Mat.Properties.DataSource; frmD01.rep_MtrItem.DisplayMember = "Code"; frmD01.rep_MtrItem.ValueMember = "ID"; frmD01.rep_MtrItem.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; frmD01.rep_MtrItem.View.PopulateColumns(frmD01.rep_MtrItem.DataSource); frmD01.rep_MtrItem.View.Columns["ID"].Visible = false; frmD01.txeMatDescription.Text = ""; frmD01.txeMatDescription.BackColor = Color.Empty; } if (ItemCode != "") { string[] arrFB = DB.DBQuery("SELECT TOP(1) Description, OIDITEM AS ID FROM Items WHERE (Code = N'" + ItemCode + "') ").getMultipleValue(); if (arrFB.Length > 0) { if (this._tmpType == "FB")//Fabric { frmD01.slFBCode_FB.EditValue = arrFB[1]; frmD01.lblDescription.Text = arrFB[0] == "" ? "-" : arrFB[0]; frmD01.lblDescription.AppearanceItemCaption.BackColor = Color.FromArgb(255, 255, 192); } else if (this._tmpType == "MT") //Material { frmD01.slMatCode_Mat.EditValue = arrFB[1]; frmD01.txeMatDescription.Text = arrFB[0] == "" ? "-" : arrFB[0]; frmD01.txeMatDescription.BackColor = Color.FromArgb(255, 255, 192); } } } } }