private bool DBSave() { this.uniGrid1.UpdateData(); cstdsY8101M2_KO883.I_PMS_PROJECT_RATE.Clear(); DataTable saveDt = new DataTable(); try { cstdsY8101M2_KO883.I_PMS_PROJECT_RATE.Merge(cstdsY8101M2_KO883.E_PMS_PROJECT_RATE.GetChanges(), false, MissingSchemaAction.Ignore); saveDt.Merge(cstdsY8101M2_KO883.I_PMS_PROJECT_RATE, false, MissingSchemaAction.Add); saveDt.AcceptChanges(); using (uniCommand _uniCmd = uniBase.UDatabase.GetStoredProcCommand("dbo.USP_H4006M4_KO883_CUD")) { uniBase.UDatabase.AddInParameter(_uniCmd, "@TBL_DATA", SqlDbType.Structured, saveDt); uniBase.UDatabase.AddInParameter(_uniCmd, "@USER_ID", SqlDbType.NVarChar, 15, CommonVariable.gUsrID); uniBase.UDatabase.AddOutParameter(_uniCmd, "@MSG_CD", SqlDbType.NVarChar, 6); uniBase.UDatabase.AddOutParameter(_uniCmd, "@MESSAGE", SqlDbType.NVarChar, 200); uniBase.UDatabase.AddOutParameter(_uniCmd, "@ERR_POS", SqlDbType.Int, 6); uniBase.UDatabase.AddReturnParameter(_uniCmd, "RETURN_VALUE", SqlDbType.Int, 1); uniBase.UDatabase.ExecuteNonQuery(_uniCmd, false); int iReturn = (int)uniBase.UDatabase.GetParameterValue(_uniCmd, "RETURN_VALUE"); if (iReturn < 0) { string sMsgCd = uniBase.UDatabase.GetParameterValue(_uniCmd, "@MSG_CD") as string; string sMessage = uniBase.UDatabase.GetParameterValue(_uniCmd, "@MESSAGE") as string; if (string.IsNullOrEmpty(sMsgCd)) { sMsgCd = "DT9999"; } uniBase.UMessage.DisplayMessageBox(sMsgCd, MessageBoxButtons.OK, sMessage); return(false); } } } catch (Exception ex) { bool reThrow = ExceptionControler.AutoProcessException(ex); if (reThrow) { throw; } return(false); } finally { } return(true); }
public DataTable SelectDataTable(string sQuery) { DataTable dtNew = new DataTable(); try { SqlDataAdapter sqlDA = new SqlDataAdapter(sQuery, Connection); sqlDA.Fill(dtNew); } catch (Exception e) { /* * SELECT errorSelect = new SELECT(); * errorSelect.addInQuery("BEGIN TRY"); * errorSelect.addInQuery("--- ----- ---"); * errorSelect.addInQuery( sQuery + ";"); * errorSelect.addInQuery("--- ----- ---"); * errorSelect.addInQuery(" END TRY "); * errorSelect.addInQuery("BEGIN CATCH"); * errorSelect.addInQuery(" SELECT ERROR_NUMBER() AS ErrorNumber "); * errorSelect.addInQuery(" , ERROR_SEVERITY() AS ErrorSeverity "); * errorSelect.addInQuery(" , ERROR_STATE() AS ErrorState "); * errorSelect.addInQuery(" , ERROR_PROCEDURE() AS ErrorProcedure "); * errorSelect.addInQuery(" , ERROR_LINE() AS ErrorLine "); * errorSelect.addInQuery(" , ERROR_MESSAGE() AS ErrorMessage "); * errorSelect.addInQuery(" END CATCH;"); * * DataTable dtError = errorSelect.getData(); * * StringBuilder errorMessage = new StringBuilder("Erro(s) = "+dtError.DefaultView.Count); * * foreach(DataRow row in dtError.Rows) * { * errorMessage.Append("Error( " +row[0].ToString()+" )"); * errorMessage.Append(", Severity( " +row[1].ToString()+" )"); * errorMessage.Append(", State( " +row[2].ToString()+" )"); * errorMessage.AppendLine(", Procedure( " +row[3].ToString()+" )"); * errorMessage.Append(", Line: " +row[4].ToString() ); * errorMessage.AppendLine(" - Message \" "+row[5].ToString()+" \""); * * errorMessage.AppendLine(new string('=', 100)); * } * * errorMessage.Append(ExceptionControler.getFullException(e)); * throw new Exception( errorMessage.ToString() ); * //*/ throw ExceptionControler.getFullException(e); } return(dtNew); }
private bool DBQuery() { cstdsY8101M2_KO883.Clear(); DataSet dsResult = null; try { using (uniCommand uniCommand = uniBase.UDatabase.GetStoredProcCommand("USP_H4006M1_KO883P_111")) { uniBase.UDatabase.AddInParameter(uniCommand, "@YYYY", SqlDbType.NVarChar, dtYYYYMM.uniValue.ToString("yyyy")); uniBase.UDatabase.AddInParameter(uniCommand, "@DILIG_EMP_NO", SqlDbType.NVarChar, popEmpNo.CodeValue.Trim()); uniBase.UDatabase.AddInParameter(uniCommand, "@DEPT_CD", SqlDbType.NVarChar, popDeptCd.CodeValue.Trim()); uniBase.UDatabase.AddInParameter(uniCommand, "@STD_DATE", SqlDbType.DateTime, dtDocumentDt.uniValue.ToString()); dsResult = uniBase.UDatabase.ExecuteDataSet(uniCommand); } if (dsResult == null || dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { uniBase.UMessage.DisplayMessageBox("900014", MessageBoxButtons.OK); return(false); } cstdsY8101M2_KO883.E_PMS_PROJECT_RATE.Merge(dsResult.Tables[0], false, MissingSchemaAction.Ignore); } catch (Exception ex) { bool reThrow = ExceptionControler.AutoProcessException(ex); if (reThrow) { throw; } return(false); } finally { } return(true); }