private void confirmEditInsert()
{
bool error = false;
string path = Directory.GetCurrentDirectory();
string connstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + @"\GameMuseumManagementSystem.accdb";
if (nametxt.Text.Equals(""))
{
error = true;
}
if (wrktxt.Text.Equals(""))
{
error = true;
}
int n;
bool isNumeric = int.TryParse(wrktxt.Text, out n);
if (!isNumeric)
{
error = true;
}
if (!error)
{
int check = 0;
using (OleDbConnection conn = new OleDbConnection(connstring))
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = conn;
conn.Open();
cmd.CommandText = "select count(*) from Employee where Emp_Name=@name";
cmd.Parameters.AddWithValue("@name", nametxt.Text);
check = (int)cmd.ExecuteScalar();
}
}
using (OleDbConnection conn = new OleDbConnection(connstring))
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = conn;
conn.Open();
if (function.Equals("insert"))
{
if (check == 0)
{
cmd.CommandText = "insert into Employee ([Emp_Name],[Emp_WorkingHrs],[Admin_ID]) values (?,?,?)";
cmd.Parameters.AddWithValue("@name", nametxt.Text);
cmd.Parameters.AddWithValue("@wrkhrs", wrktxt.Text);
cmd.Parameters.AddWithValue("@id", Admin_ID);
cmd.ExecuteNonQuery();
listbox.Items.Add(nametxt.Text);
listbox.Update();
listbox2.Items.Add(nametxt.Text);
listbox2.Update();
this.Close();
this.Dispose();
}
else
{
MessageBox.Show("This employee already existed");
}
}
else
{
cmd.CommandText = "update Employee set Emp_Name=@name,Emp_WorkingHrs=@wrkhrs,Admin_ID=@id where Emp_Name=@default";
cmd.Parameters.AddWithValue("@name", nametxt.Text);
cmd.Parameters.AddWithValue("@wrkhrs", wrktxt.Text);
cmd.Parameters.AddWithValue("@id", Admin_ID);
cmd.Parameters.AddWithValue("@default", name);
cmd.ExecuteNonQuery();
int index = listbox.FindString(name);
listbox.Items[index] = nametxt.Text;
listbox.Update();
listbox2.Items[index] = nametxt.Text;
listbox2.Update();
this.Close();
this.Dispose();
}
}
}
}
else
{
if (!isNumeric)
{
MessageBox.Show("Please fill a integer in working hour");
}
else
{
MessageBox.Show("Please fill up all information");
}
}
}
ICollection Orders_CreateDataSource()
{
// Orders Show begin
Orders_sSQL = "";
Orders_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
sOrder = " order by o.order_id Asc";
if (Utility.GetParam("FormOrders_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("FormOrders_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("item_id"))
{
string temp = Utility.GetParam("item_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, FieldTypes.Number);
}
else
{
temp = "";
}
Params.Add("item_id", temp);
}
if (!Params.ContainsKey("member_id"))
{
string temp = Utility.GetParam("member_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, FieldTypes.Number);
}
else
{
temp = "";
}
Params.Add("member_id", temp);
}
if (Params["item_id"].Length > 0)
{
HasParam = true;
sWhere += "o.[item_id]=" + Params["item_id"];
}
if (Params["member_id"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "o.[member_id]=" + Params["member_id"];
}
if (HasParam)
{
sWhere = " AND (" + sWhere + ")";
}
//-------------------------------
// Build base SQL statement
//-------------------------------
Orders_sSQL = "select [o].[item_id] as o_item_id, " +
"[o].[member_id] as o_member_id, " +
"[o].[order_id] as o_order_id, " +
"[o].[quantity] as o_quantity, " +
"[i].[item_id] as i_item_id, " +
"[i].[name] as i_name, " +
"[m].[member_id] as m_member_id, " +
"[m].[member_login] as m_member_login " +
" from [orders] o, [items] i, [members] m" +
" where [i].[item_id]=o.[item_id] and [m].[member_id]=o.[member_id] ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
Orders_sSQL = Orders_sSQL + sWhere + sOrder;
if (Orders_sCountSQL.Length == 0)
{
int iTmpI = Orders_sSQL.ToLower().IndexOf("select ");
int iTmpJ = Orders_sSQL.ToLower().LastIndexOf(" from ") - 1;
Orders_sCountSQL = Orders_sSQL.Replace(Orders_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = Orders_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
Orders_sCountSQL = Orders_sCountSQL.Substring(0, iTmpI);
}
}
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(Orders_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_Orders_curpage - 1) * Orders_PAGENUM, Orders_PAGENUM, "Orders");
OleDbCommand ccommand = new OleDbCommand(Orders_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
Orders_Pager.MaxPage = (PageTemp % Orders_PAGENUM) > 0?(int)(PageTemp / Orders_PAGENUM) + 1:(int)(PageTemp / Orders_PAGENUM);
bool AllowScroller = Orders_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
Orders_no_records.Visible = true;
AllowScroller = false;
}
else
{
Orders_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
Orders_Pager.Visible = AllowScroller;
return(Source);
// Orders Show end
}
/// <summary>
/// 获取条件查询的总记录数
/// </summary>
/// <param name="qs"></param>
/// <returns></returns>
public static int GetRecPageCount(RecQueryStatement qs, ref string errorInfo)
{
if (!Access.Connection(ref errorInfo))
{
return(-1);
}
bool b_Conditional = false;
string sql = "select count(*) from RecFileList where";
if (qs.CameraID != null)
{
if (qs.CameraID.Count != 0)
{
for (int j = 0; j < qs.CameraID.Count; j++)
{
sql += " CameraID='" + qs.CameraID[j] + "'or";
}
b_Conditional = true;
sql = sql.Substring(0, sql.Length - 2) + "and";
}
}
if (qs.RecType != null)
{
sql += " RecType='" + qs.RecType + "'and";
b_Conditional = true;
}
if (qs.UserName != null)
{
sql += " UserName='******'and";
b_Conditional = true;
}
if (qs.RecStartDate != null)
{
sql += " RecStartDate>='" + qs.RecStartDate + "'and";
b_Conditional = true;
}
if (qs.RecStartTime != null)
{
sql += " RecStartTime>='" + qs.RecStartTime + "'and";
b_Conditional = true;
}
if (qs.RecEndDate != null)
{
sql += " RecStartDate<='" + qs.RecEndDate + "'and";
b_Conditional = true;
}
if (qs.RecEndTime != null)
{
sql += " RecStartTime<='" + qs.RecEndTime + "'and";
b_Conditional = true;
}
if (!b_Conditional)
{
sql = sql.Substring(0, sql.Length - 5);
}
else
{
sql = sql.Substring(0, sql.Length - 3);
}
OleDbCommand oleDbCommand = new OleDbCommand(sql, Access.oleDb);
int i = (int)oleDbCommand.ExecuteScalar();
Access.CloseConn();
return(i);
}
/* Создать номер для документа Заказ */
String createDocNumber()
{
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL)
{
// OLEDB
OleDbConnection oleDbConnection = new OleDbConnection(connectionString);
OleDbCommand oleDbCommand = null;
try{
if (oleDbCommand != null)
{
oleDbCommand.Dispose();
}
oleDbCommand = new OleDbCommand("SELECT MAX(id) FROM Orders", oleDbConnection);
oleDbConnection.Open();
var order_id = oleDbCommand.ExecuteScalar();
oleDbConnection.Close();
int num;
if (order_id.ToString() == "")
{
num = 1;
}
else
{
num = (int)order_id + 1;
}
String idStr = num.ToString();
String numStr = "ЗА-0000000";
numStr = numStr.Remove((numStr.Length - idStr.Length));
numStr += idStr;
return(numStr);
}catch (Exception ex) {
Utilits.Console.Log("[ОШИБКА]: " + ex.Message, false, true);
}
if (oleDbConnection != null)
{
oleDbConnection.Close();
oleDbConnection.Dispose();
}
if (oleDbCommand != null)
{
oleDbCommand.Dispose();
}
}
else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER)
{
// MSSQL SERVER
SqlConnection sqlConnection = new SqlConnection(DataConfig.serverConnection);
SqlCommand sqlCommand = null;
try{
sqlCommand = new SqlCommand("SELECT MAX(id) FROM Orders", sqlConnection);
sqlConnection.Open();
var order_id = sqlCommand.ExecuteScalar();
sqlConnection.Close();
int num;
if (order_id.ToString() == "")
{
num = 1;
}
else
{
num = (int)order_id + 1;
}
String idStr = num.ToString();
String numStr = "ЗА-0000000";
numStr = numStr.Remove((numStr.Length - idStr.Length));
numStr += idStr;
return(numStr);
}catch (Exception ex) {
Utilits.Console.Log("[ОШИБКА]: " + ex.Message, false, true);
}
if (sqlConnection != null)
{
sqlConnection.Close();
sqlConnection.Dispose();
}
if (sqlCommand != null)
{
sqlCommand.Dispose();
}
}
return(null);
}
public static object ExecuteScalar(string sql, OleDbConnection conn)
{
OleDbCommand command = new OleDbCommand(sql, conn);
return(command.ExecuteScalar());
}
} //AlphabetSequenceDatabaseQuery()
/// <summary>The database query.</summary>
/// <param name="databaseConnectionString">The database connection string.</param>
/// <param name="exceptionMessage">The exception message.</param>
/// <param name="wordQuery">The word.</param>
/// <param name="scriptureReferenceAssociates">The scripture reference associates.</param>
/// <param name="alphabetSequenceIndex">The alphabet sequence index.</param>
/// <param name="scriptureReferenceAlphabetSequence">The scripture reference alphabet sequence.</param>
public static void AlphabetSequenceQuery
(
ref String databaseConnectionString,
ref String exceptionMessage,
ref String[] wordQuery,
String scriptureReferenceAssociates,
ref int[] alphabetSequenceIndex,
ref ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence
)
{
int sequenceOrderId = -1;
int theWordId = -1;
int wordQueryTotal = wordQuery.Length;
string chapterForward = null;
string chapterBackward = null;
//string commentary = null;
string scriptureReference = null;
string scriptureReferenceChapterBackward = null;
string scriptureReferenceChapterForward = null;
string scriptureReferenceVerseBackward = null;
string scriptureReferenceVerseForward = null;
string verseForward = null;
string verseBackward = null;
OleDbConnection oleDbConnection = null;
OleDbCommand oleDbCommand = null;
OleDbDataReader oleDbDataReader = null;
OleDbParameter oleDbParameterWord = null;
OleDbParameter oleDbParameterScriptureReferenceAssociates = null;
OleDbParameter oleDbParameterAlphabetSequence = null;
OleDbParameter oleDbParameterScriptureReferenceVerseForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterBackward = null;
OleDbParameter oleDbParameterScriptureReferenceVerseBackward = null;
OleDbParameter oleDbParameterScriptureReference = null;
OleDbParameter oleDbParameterSequenceOrderId = null;
OleDbParameter oleDbParameterVerseForward = null;
OleDbParameter oleDbParameterChapterForward = null;
OleDbParameter oleDbParameterChapterBackward = null;
OleDbParameter oleDbParameterVerseBackward = null;
OleDbParameter oleDbParameterCommentary = null;
OleDbParameter oleDbParameterTheWordId = null;
AlphabetSequenceIndexCalculate
(
ref wordQuery,
ref alphabetSequenceIndex
);
try
{
if
(
databaseConnectionString == null ||
databaseConnectionString.IndexOf("Bible") < 0
)
{
databaseConnectionString = DatabaseConnectionString;
}//if ( databaseConnectionString == null )
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
if (oleDbConnection == null || exceptionMessage != null)
{
return;
}//if ( oleDbConnection == null || exceptionMessage != null )
oleDbCommand = new OleDbCommand(SQLSelectAlphabetSequence, oleDbConnection);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameterWord = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceAssociates = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterAlphabetSequence = new OleDbParameter(ParameterAlphabetSequence, OleDbType.Integer);
oleDbParameterScriptureReferenceVerseForward = new OleDbParameter(ParameterScriptureReferenceVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterForward = new OleDbParameter(ParameterScriptureReferenceChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterBackward = new OleDbParameter(ParameterScriptureReferenceChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceVerseBackward = new OleDbParameter(ParameterScriptureReferenceVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReference = new OleDbParameter(ParameterScriptureReference, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseForward = new OleDbParameter(ParameterVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterForward = new OleDbParameter(ParameterChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterBackward = new OleDbParameter(ParameterChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseBackward = new OleDbParameter(ParameterVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterSequenceOrderId = new OleDbParameter(ParameterSequenceOrderId, OleDbType.Integer);
oleDbParameterCommentary = new OleDbParameter(ParameterCommentary, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterTheWordId = new OleDbParameter(ParameterTheWordId, OleDbType.Integer);
oleDbParameterSequenceOrderId = new OleDbParameter(ParameterSequenceOrderId, OleDbType.Integer);
/*
* @word VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceAssociates VARCHAR(600) = NULL OUTPUT,
* @alphabetSequence INT = -1 OUTPUT,
* @scriptureReferenceVerseForward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceChapterForward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceChapterBackward VARCHAR(600) = NULL OUTPUT,
* @scriptureReferenceVerseBackward VARCHAR(600) = NULL OUTPUT,
* @scriptureReference VARCHAR(600) = NULL OUTPUT,
* @verseForward VARCHAR(600) = NULL OUTPUT,
* @chapterForward VARCHAR(600) = NULL OUTPUT,
* @chapterBackward VARCHAR(600) = NULL OUTPUT,
* @verseBackward VARCHAR(600) = NULL OUTPUT,
* @sequenceOrderId INT = -1 OUTPUT
*/
oleDbCommand.Parameters.Add(oleDbParameterWord);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceAssociates);
oleDbCommand.Parameters.Add(oleDbParameterAlphabetSequence);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReference);
oleDbCommand.Parameters.Add(oleDbParameterVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterVerseBackward);
/*
* oleDbCommand.Parameters.Add(oleDbParameterCommentary);
* oleDbCommand.Parameters.Add(oleDbParameterTheWordId);
*/
oleDbCommand.Parameters.Add(oleDbParameterSequenceOrderId);
oleDbParameterWord.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceAssociates.Direction = ParameterDirection.InputOutput;
oleDbParameterAlphabetSequence.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceVerseForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceVerseBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReference.Direction = ParameterDirection.Output;
oleDbParameterVerseForward.Direction = ParameterDirection.Output;
oleDbParameterChapterForward.Direction = ParameterDirection.Output;
oleDbParameterChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterVerseBackward.Direction = ParameterDirection.Output;
/*
* oleDbParameterCommentary.Direction = ParameterDirection.InputOutput;
* oleDbParameterTheWordId.Direction = ParameterDirection.InputOutput;
*/
oleDbParameterSequenceOrderId.Direction = ParameterDirection.InputOutput;
for (int wordQueryIndex = 0; wordQueryIndex < wordQuery.Length; ++wordQueryIndex)
{
oleDbParameterAlphabetSequence.Value = alphabetSequenceIndex[wordQueryIndex];
oleDbParameterScriptureReferenceAssociates.Value = scriptureReferenceAssociates;
oleDbParameterSequenceOrderId.Value = -1;
oleDbParameterTheWordId.Value = null;
oleDbParameterWord.Value = wordQuery[wordQueryIndex];
oleDbCommand.ExecuteScalar();
//oleDbDataReader = oleDbCommand.ExecuteReader();
scriptureReferenceVerseForward = (oleDbParameterScriptureReferenceVerseForward.Value).ToString();
scriptureReferenceChapterForward = (oleDbParameterScriptureReferenceChapterForward.Value).ToString();
scriptureReferenceChapterBackward = (oleDbParameterScriptureReferenceChapterBackward.Value).ToString();
scriptureReferenceVerseBackward = (oleDbParameterScriptureReferenceVerseBackward.Value).ToString();
scriptureReference = (oleDbParameterScriptureReference.Value).ToString();
verseForward = (oleDbParameterVerseForward.Value).ToString();
chapterForward = (oleDbParameterChapterForward.Value).ToString();
chapterBackward = (oleDbParameterChapterBackward.Value).ToString();
verseBackward = (oleDbParameterVerseBackward.Value).ToString();
sequenceOrderId = Int32.Parse(oleDbParameterSequenceOrderId.Value.ToString());
/*
* theWordId = Int32.Parse ( oleDbParameterTheWordId.Value.ToString() );
*/
scriptureReferenceAlphabetSequence[wordQueryIndex] = new ScriptureReferenceAlphabetSequence
(
wordQuery[wordQueryIndex],
scriptureReferenceAssociates,
alphabetSequenceIndex[wordQueryIndex],
scriptureReferenceVerseForward,
scriptureReferenceChapterForward,
scriptureReferenceChapterBackward,
scriptureReferenceVerseBackward,
scriptureReference,
verseForward,
chapterForward,
chapterBackward,
verseBackward,
sequenceOrderId
);
#if (DEBUG)
System.Console.WriteLine("SequenceOrderId: {0}", sequenceOrderId);
System.Console.WriteLine("TheWordId: {0}", theWordId);
#endif
} //for ( int wordQueryIndex = 0; wordQueryIndex < wordQueryTotal; ++wordQueryIndex )
} //try
catch (OleDbException exception)
{
exceptionMessage = UtilityDatabase.DisplayOleDbErrorCollection(exception);
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
System.Console.WriteLine("OleDbException: {0}", oleDbParameterAlphabetSequence.Value);
return;
}//catch (OleDbException exception)
catch (Exception exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine("Exception: {0}", exception.Message);
return;
}//catch (Exception exception)
finally
{
if (oleDbDataReader != null)
{
oleDbDataReader.Close();
}
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
} //finally
return;
} //AlphabetSequenceQuery()
public bool BatchEmployeeUpload(string filePath, string Employer_number, string scheme_id)
{
try
{
if (System.IO.File.Exists(filePath) == false)
{
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "File does not exist.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(false);
}
//'get file extension
string file_ext = Path.GetExtension(filePath);
string consString_excel = "";
switch (file_ext)
{
case ".xls":
consString_excel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=Excel 8.0;HDR=Yes;IMEX=2";
break;
case ".xlsx":
consString_excel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\"";
break;
}
OleDbConnection con_ex = new OleDbConnection();
OleDbCommand cmd = new OleDbCommand();
string query1 = "Select COUNT(*) AS NOS From [EmployeeScheme$]";
string query2 = "Select * From [EmployeeScheme$]";
int totalsum = 1;
con_ex.ConnectionString = consString_excel;
con_ex.Open();
cmd.Connection = con_ex;
cmd.CommandText = query1;
totalsum = Convert.ToInt32(cmd.ExecuteScalar()); //();
con_ex.Close();
if (con_ex.State == ConnectionState.Closed)
{
con_ex.Open();
}
if (con_ex.State == ConnectionState.Open)
{
cmd.Connection = con_ex;
cmd.CommandText = query2;
OleDbDataReader srda = cmd.ExecuteReader();
int a_value = 0;
if (srda.HasRows)
{
string errormsg = "";
Stopwatch sw = new Stopwatch();
// Start The StopWatch ...From 000
sw.Start();
var app = new AppSettings();
//IDbConnection con;
DateTime date_default = Convert.ToDateTime("01/01/1901");
TransactionOptions tsOp = new TransactionOptions();
tsOp.IsolationLevel = System.Transactions.IsolationLevel.Snapshot;
TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew, tsOp);
tsOp.Timeout = TimeSpan.FromMinutes(20);
using (OracleConnection conn = new OracleConnection(app.conString())) //
{
conn.Open();
try
{
//check if pending list exist for employer already
var param_k = new DynamicParameters();
decimal emp_num = 0;
param_k.Add(name: "p_employer_id", value: Employer_number, dbType: DbType.String, direction: ParameterDirection.Input);
param_k.Add(name: "p_status", value: "ACTIVE", dbType: DbType.String, direction: ParameterDirection.Input);
param_k.Add(name: "p_result", value: emp_num, dbType: DbType.Decimal, direction: ParameterDirection.Output);
conn.Execute(sql: "sel_crm_employerbatchpendexist", param: param_k, commandType: CommandType.StoredProcedure);
decimal tot_emp = param_k.Get <decimal>("p_result");
if (tot_emp > 0)
{
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Pending upload exists for this employer already." + Environment.NewLine + "Approve the pending employees.Proces aborted",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(false);
}
///create log for the upload P_scheme_id
var paramb = new DynamicParameters();
string batchno = "na";
paramb.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input);
paramb.Add(name: "p_Make_Date", value: GlobalValue.Scheme_Today_Date, dbType: DbType.DateTime, direction: ParameterDirection.Input);
paramb.Add(name: "p_employer_id", value: Employer_number, dbType: DbType.String, direction: ParameterDirection.Input);
paramb.Add(name: "p_BatchNo", value: batchno, dbType: DbType.String, direction: ParameterDirection.Output);
paramb.Add(name: "p_scheme_id", value: scheme_id, dbType: DbType.String, direction: ParameterDirection.Input);
conn.Execute(sql: "ADD_CRM_EMPLOYEE_BATCH_TWO", param: paramb, commandType: CommandType.StoredProcedure);
batchno = paramb.Get <string>("p_BatchNo");
if (batchno == "na")
{
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employer details could not be logged.",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(false);
}
//-----end batch number
int error_nos = 0;
string erroor_msg = "Error:" + Environment.NewLine;
var param = new DynamicParameters();
//this.GetCmp<Label>("lblload").Text = "Loading";
while (srda.Read())
{
a_value += 1;
crm_EmployeeRepo employee_Repo = new crm_EmployeeRepo();
string employee_fund_id = "";
//surname
if (srda["Surname"] != DBNull.Value)
{
employee_Repo.Surname = srda["Surname"].ToString();
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Surname cannot be null." + Environment.NewLine;
}
//FirstName
if (srda["FirstName"] != DBNull.Value)
{
employee_Repo.First_Name = srda["FirstName"].ToString();
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Supply First Name For " + employee_Repo.Surname + Environment.NewLine;
}
//verify Company's EmployeID
//get CustNo for employee
int create_new_or_justacct = 1; // 1 for create new employee , 2 for creat just account
string cust_noo = "";
if (srda["CompanyEmployeeID"] != DBNull.Value)
{
employee_Repo.Employee_Id = srda["CompanyEmployeeID"].ToString();
//Validate EmployeeID against Employer to check if its already exist
OracleCommand cmd_emp_id = new OracleCommand();
cmd_emp_id.CommandText = "sel_crm_EmployeeIdExist";
cmd_emp_id.CommandType = CommandType.StoredProcedure;
cmd_emp_id.Connection = (OracleConnection)conn;
//Input param
cmd_emp_id.Parameters.Add("p_EmployerId", OracleDbType.Varchar2, ParameterDirection.Input).Value = Employer_number;
cmd_emp_id.Parameters.Add("p_EmployeeId", OracleDbType.Varchar2, ParameterDirection.Input).Value = employee_Repo.Employee_Id;
//Output param
OracleParameter count = new OracleParameter("p_result", OracleDbType.Decimal, 100, ParameterDirection.Output);
OracleParameter cust_num = new OracleParameter("p_custNo", OracleDbType.Varchar2, 4000, null, ParameterDirection.Output);
cmd_emp_id.Parameters.Add(count);
cmd_emp_id.Parameters.Add(cust_num);
cmd_emp_id.ExecuteNonQuery();
cust_noo = (cust_num.Value).ToString();
string mtotal = (count.Value).ToString();
int total = Convert.ToInt32(mtotal);
if (total > 0)
{
create_new_or_justacct = 2;
employee_Repo.Cust_No = cust_noo;
//error_nos += 1;
//erroor_msg = erroor_msg + "Employee ID already exist For this employer. - " + employee_Repo.Surname + Environment.NewLine;
//get custNo
}
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Supply Employee ID For " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
if (create_new_or_justacct == 1)
{
//Fundid
if (srda["FundID"] != DBNull.Value)
{
employee_fund_id = srda["FundID"].ToString();
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Scheme ID not provided for ." + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
if (employee_fund_id == "01")
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Employee cannot subscribe to system fund (01)- " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
//Sceme_Fund_ID
string Scheme_fund_id = scheme_id + employee_fund_id;
if (string.IsNullOrEmpty(Scheme_fund_id) == false)
{
//Validate Employee SchemeFundID to check if its already exist
OracleCommand cmd_emp_id = new OracleCommand();
cmd_emp_id.CommandText = "sel_pfm_SchemeFundIdExist";
cmd_emp_id.CommandType = CommandType.StoredProcedure;
cmd_emp_id.Connection = (OracleConnection)conn;
//Input param
cmd_emp_id.Parameters.Add("p_scheme_fund_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = Scheme_fund_id;
//Output param
OracleParameter count = new OracleParameter("p_result", OracleDbType.Decimal, 100, ParameterDirection.Output);
cmd_emp_id.Parameters.Add(count);
cmd_emp_id.ExecuteNonQuery();
string mtotal = (count.Value).ToString();
int total = Convert.ToInt32(mtotal);
if (total <= 0)
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Scheme fund does not exist for . - " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Scheme fund does not exist for . - " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
}
else if (create_new_or_justacct == 2) /////Just create schme fund account for employee
{
//Fundid
if (srda["FundID"] != DBNull.Value)
{
employee_fund_id = srda["FundID"].ToString();
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Fund ID not provided for ." + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
//Sceme_Fund_ID
string Scheme_fund_id = scheme_id + employee_fund_id;
if (string.IsNullOrEmpty(Scheme_fund_id) == false)
{
//Validate Employee SchemeFundID to check if its already exist
OracleCommand cmd_emp_id = new OracleCommand();
cmd_emp_id.CommandText = "sel_pfm_SchemeFundIdExist";
cmd_emp_id.CommandType = CommandType.StoredProcedure;
cmd_emp_id.Connection = (OracleConnection)conn;
//Input param
cmd_emp_id.Parameters.Add("p_scheme_fund_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = Scheme_fund_id;
//Output param
OracleParameter count = new OracleParameter("p_result", OracleDbType.Decimal, 100, ParameterDirection.Output);
cmd_emp_id.Parameters.Add(count);
cmd_emp_id.ExecuteNonQuery();
string mtotal = (count.Value).ToString();
int total = Convert.ToInt32(mtotal);
if (total <= 0)
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Scheme fund does not exist for . - " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
}
else
{
X.Mask.Hide();
error_nos += 1;
erroor_msg = erroor_msg + "Scheme fund does not exist for . - " + employee_Repo.First_Name + " " + employee_Repo.Surname + Environment.NewLine;
}
//create account now
////create scheme fund account for employee
decimal successs_1_2 = 0;
string Employee_Scheme_fund_id = cust_noo + Scheme_fund_id;
//check if ESF ID exist
var param_t = new DynamicParameters();
param_t.Add(name: "p_esf_id", value: Employee_Scheme_fund_id, dbType: DbType.String, direction: ParameterDirection.Input);
param_t.Add(name: "p_result", value: emp_num, dbType: DbType.Decimal, direction: ParameterDirection.Output);
conn.Execute(sql: "SEL_CRM_ESFIDEXIST", param: param_t, commandType: CommandType.StoredProcedure);
decimal t_res = param_t.Get <decimal>("p_result");
if (t_res > 0)
{
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = "Employer Scheme already exist for " + employee_Repo.First_Name + " " + employee_Repo.Surname,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
return(false);
}
param.Add(name: "p_emp_schme_fund_id", value: Employee_Scheme_fund_id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_scheme_fund_id", value: Scheme_fund_id, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_custNo", value: cust_noo, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_BatchNo", value: batchno, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_MakeId", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input);
param.Add(name: "p_MakeDate", value: GlobalValue.Scheme_Today_Date, dbType: DbType.DateTime, direction: ParameterDirection.Input);
param.Add(name: "p_result", value: successs_1_2, dbType: DbType.Decimal, direction: ParameterDirection.Output);
conn.Execute(sql: "ADD_CRM_REMITSCHEMEFUNDBNEW", param: param, commandType: CommandType.StoredProcedure);
} //end if for create_new_or_justacct =2
} ///while
ts.Complete();
// this.GetCmp<Window>("loading_EmpBatch").Hide();
return(true);
}
catch (TransactionException transexeption)
{
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = transexeption.ToString(),
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR,
Width = 350
});
errormsg = transexeption.ToString();
return(false);
//throw;
}
catch (System.Exception ex)
{
string ora_code = ex.Message.Substring(0, 9);
if (ora_code == "ORA-20000")
{
ora_code = "Record already exist. Process aborted..";
}
else if (ora_code == "ORA-20100")
{
ora_code = "Record is uniquely defined in the system. Process aborted..";
}
else
{
ora_code = ex.ToString();
}
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = ora_code,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
// logger.WriteLog(ex.Message);
return(false);
}
finally
{
ts.Dispose();
//a_value = a_value;
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (con_ex.State == ConnectionState.Open)
{
con_ex.Close();
}
}
} //end for transscope
}
}
return(true);
}
catch (Exception ex)
{
string ora_code = ex.Message.Substring(0, 9);
if (ora_code == "ORA-20000")
{
ora_code = "Record already exist. Process aborted..";
}
else if (ora_code == "ORA-20100")
{
ora_code = "Record is uniquely defined in the system. Process aborted..";
}
else
{
ora_code = ex.ToString();
}
X.Mask.Hide();
X.Msg.Show(new MessageBoxConfig
{
Title = "Error",
Message = ora_code,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO,
Width = 350
});
// logger.WriteLog(ex.Message);
return(false);
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
bool convertContact = IsDigitsOnly(txtEmpContact.Text);
bool convertPostCode = IsDigitsOnly(txtEmpPostcode.Text);
bool convertName = IsCharOnly(txtEmpName.Text);
double salary = 0.0;
bool convertSalary = double.TryParse(txtEmpSalary.Text, out salary);
if (convertContact == false)
{
MessageBox.Show("Please enter only numbers (no special characters) in the Contact field!", "Error");
return;
}
else if (convertSalary == false || salary < 0)
{
MessageBox.Show("Please enter positive numbers in the Salary field!", "Error");
return;
}
else if (convertPostCode == false || txtEmpPostcode.Text.Length != 5)
{
MessageBox.Show("Please enter 5 positive numbers in the Postcode field!", "Error");
return;
}
else if (String.IsNullOrWhiteSpace(txtEmpName.Text))
{
MessageBox.Show("Please enter data in the Name field!", "Error");
return;
}
else if (convertName == false)
{
MessageBox.Show("Please enter characters in the Name field!", "Error");
return;
}
salary = Math.Round(salary, 2);
string name = txtEmpName.Text;
string contact = txtEmpContact.Text;
string address = txtEmpAddress.Text;
string postcode = txtEmpPostcode.Text;
string city = txtEmpCity.Text;
string state = cbEmpState.GetItemText(cbEmpState.SelectedItem);
string position = txtPosition.Text;
OleDbCommand cmd = new OleDbCommand();
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Restaurant.accdb; Persist Security Info=False;";
cmd.Connection = cn;
bool successful = false;
try
{
//If loaded then UPDATE, if not loaded then INSERT
if (loaded == true)
{
string q = "UPDATE Employee SET empName='" + name + "', empContact='" + contact +
"', empSalary=" + salary + ", empAddress='" + address + "', empPostcode='" + postcode +
"', empCity='" + city + "', empState='" + state + "', empPosition='" + position + "' WHERE empID = " + empID + ";";
cmd.CommandText = q;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record successfully edited! Returning to previous screen!", "Successful");
successful = true;
}
else
{
string p = "SELECT Max(empID) FROM Employee";
cmd.CommandText = p;
cn.Open();
int maxId = 1;
if (cmd.ExecuteScalar() != DBNull.Value)
{
maxId = Convert.ToInt32(cmd.ExecuteScalar());
maxId = maxId + 1;
}
cn.Close();
string q = "INSERT INTO Employee(empID, empName, empContact, empSalary, empAddress, empPostcode, empCity, empState, empPosition)" +
" VALUES(" + maxId + ",'" + name + "','" + contact + "'," + salary + ",'" + address + "','"
+ postcode + "','" + city + "','" + state + "','" + position + "');";
cmd.CommandText = q;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record successfully added! Returning to previous screen!", "Successful");
successful = true;
}
}
catch (Exception ex)
{
cn.Close();
MessageBox.Show(ex.ToString());
MessageBox.Show("Oops... Something went wrong. Please contact the admin to make sure everything's all right!", "Sorry");
}
if (successful == true)
{
frmEmployee newForm = new frmEmployee();
newForm.Show();
this.Hide();
}
}
private void lblLoadMatchDate_Click(object sender, EventArgs e)
{
//Create match and the databse
string path = "";
saveFileDialog1.FileName = txtMatchName.Text + ".sdf";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
path = saveFileDialog1.FileName;
}
else
{
return;
}
if (!rbTeam1FirstBatting.Checked && !rbTeam2FirstBatting.Checked)
{
clsMessages.showMessage(clsMessages.msgType.exclamation, "Please select the first batting team to continue.");
return;
}
//show infor
txtInfo.Text = "Save path: " + path + "\n\n";
//Import data
//Get the two team names.
string team1Name = "", team2Name = "";
OleDbCommand comAc = new OleDbCommand("SELECT Teams.CountryID, Countries.Name, Teams.ID FROM Countries INNER JOIN Teams ON Countries.ID = Teams.CountryID", conACCESS);
OleDbDataAdapter adACC = new OleDbDataAdapter(comAc);
DataSet dsAC = new DataSet("countries");
adACC.Fill(dsAC, "countries");
team1Name = dsAC.Tables["countries"].Rows[0][1].ToString();
team2Name = dsAC.Tables["countries"].Rows[1][1].ToString();
int team1RefID = Convert.ToInt32(dsAC.Tables["countries"].Rows[0][2].ToString());
int team2RefID = Convert.ToInt32(dsAC.Tables["countries"].Rows[1][2].ToString());
//Indormation for creating a match
int matchId = clsMatch.getNextMatchId();
string matchName = txtMatchName.Text;
DateTime matchDate = dateTimePicker1.Value;
clsMatchTypes matchType = new clsMatchTypes(clsMatchTypes.getMatchTypeID(cmbMatchType.SelectedItem.ToString()), cmbMatchType.SelectedItem.ToString());
comAc = new OleDbCommand("SELECT Countries.Name FROM Countries INNER JOIN Venues ON Countries.ID = Venues.CountryID", conACCESS);
string countryNamePlayed = "";
try
{
countryNamePlayed = comAc.ExecuteScalar().ToString();
}
catch (Exception ex)
{
clsMessages.showMessage(clsMessages.msgType.error, ex.Message);
}
clsCountry countryPlayed = new clsCountry(clsCountry.getCountryCode(countryNamePlayed), countryNamePlayed);
comAc = new OleDbCommand("SELECT [Name] FROM Venues", conACCESS);
string venueName = comAc.ExecuteScalar().ToString();
//Check if venue is in database
if (clsGround.getGroundCode(venueName) <= 0)
{
int venueCode = clsGround.getNextGroundCode();
int endId = clsEnds.getNextEndID();
clsGround.addGround(new clsGround(venueCode, venueName, 30000, countryPlayed.countryId, new clsEnds(endId, "Scoreboard End", venueCode), new clsEnds(endId + 1, "Pavillion End", venueCode)));
}
clsGround groundPlayed = clsGround.getGround(venueName);
//Show info
txtInfo.Text += "Ground played in: " + groundPlayed.stadiumName + "\n\n";
txtInfo.Text += "Venue played: " + venueName + "\n\n";
txtInfo.Text += "Match name: " + matchName + "\n\n";
txtInfo.Text += "Team 1: " + team1Name + "\n\n";
txtInfo.Text += "Team 1: " + team2Name + "\n\n";
txtInfo.Text += "-----------------------\n\n";
//Get team 1 and 2
string playerFName = "", platerLName = "";
List <clsPlayer> team1 = new List <clsPlayer>();
List <clsPlayer> team2 = new List <clsPlayer>();
comAc = new OleDbCommand("SELECT CurrentTeamID, FirstName, LastName FROM Players", conACCESS);
adACC = new OleDbDataAdapter(comAc);
dsAC = new DataSet("Players");
adACC.Fill(dsAC, "Players");
//Show info
txtInfo.Text += "Players added..." + "\n\n";
foreach (DataRow rAC in dsAC.Tables["Players"].Rows)
{
int currentTeamID = Convert.ToInt32(rAC[0].ToString());
string currentTeam = "";
OleDbCommand comCurrentTeam = new OleDbCommand("SELECT [Name] FROM Teams WHERE ID=@p1", conACCESS);
comCurrentTeam.Parameters.AddWithValue("@p1", currentTeamID);
currentTeam = comCurrentTeam.ExecuteScalar().ToString();
playerFName = rAC[1].ToString();
platerLName = rAC[2].ToString();
if (currentTeam == team1Name)
{
team1.Add(clsPlayer.getPlayer(clsPlayer.getPlayerId(playerFName, platerLName, clsCountry.getCountryCode(team1Name))));
}
else
{
team2.Add(clsPlayer.getPlayer(clsPlayer.getPlayerId(playerFName, platerLName, clsCountry.getCountryCode(team2Name))));
}
//Display the data added.
txtInfo.Text += playerFName + " " + platerLName + "\n\n";
}
OleDbCommand comCaptain1 = new OleDbCommand("SELECT CaptainID FROM MatchTeams WHERE TeamID=@p1", conACCESS);
comCaptain1.Parameters.AddWithValue("@p1", team1RefID);
OleDbCommand comCaptain2 = new OleDbCommand("SELECT CaptainID FROM MatchTeams WHERE TeamID=@p1", conACCESS);
comCaptain2.Parameters.AddWithValue("@p1", team2RefID);
int captain1Id = 0;
int captain2Id = 0;
try
{
captain1Id = clsImportBallbyBall.mapPlayer(Convert.ToInt32(comCaptain1.ExecuteScalar().ToString()), conACCESS);
captain2Id = clsImportBallbyBall.mapPlayer(Convert.ToInt32(comCaptain2.ExecuteScalar().ToString()), conACCESS);
}
catch (Exception ex)
{
clsMessages.showMessage(clsMessages.msgType.error, "Error retrieving team capain IDs\n\n" + ex.Message);
}
List <clsTeams> squard = new List <clsTeams>();
squard.Add(new clsTeams(clsCountry.getCountry(team1Name), team1, captain1Id, 0, 0));
squard.Add(new clsTeams(clsCountry.getCountry(team2Name), team2, captain2Id, 0, 0));
string firstBatting = "";
if (rbTeam1FirstBatting.Checked)
{
firstBatting = cmbTeam1.SelectedItem.ToString();
}
else if (rbTeam2FirstBatting.Checked)
{
firstBatting = cmbTema2.SelectedItem.ToString();
}
new clsMatch(matchId, matchName, matchType, matchDate, path, countryPlayed, groundPlayed, squard, cmbTeam1.SelectedItem.ToString(), firstBatting);
SqlCeConnection conSQL = connection.creatDatabase(path, true);
//Create tables in the match database
clsCreateTables.createTables(conSQL);
//connection.CON_WORKING = conSQL;
//Creates the match in the main database
clsMatch.creatMatch();
if (chkMatchWon.Checked)
{
clsMatch.setWinningTeam(matchId, squard[0].country.countryId, "");
}
else
{
clsMatch.setWinningTeam(matchId, squard[1].country.countryId, "");
}
clsCreateTables.AddTeam(clsMatch.currentMatch.team1.players, clsMatch.currentMatch.matchID);
clsCreateTables.AddTeam(clsMatch.currentMatch.team2.players, clsMatch.currentMatch.matchID);
lblLoadMatchDate.Enabled = false;
btnBallByBall.Enabled = true;
clsMessages.showMessage(clsMessages.msgType.information, "Match data was Imported successfully");
}
public static List <string> TakeDances(GroupClass input_group, string cn)
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
List <string> CategoryList_New = new List <string>();
try
{
int i = 1;
int max = 0;
int counter = 0;
BitArray checkArray = Controller.GapCounter("Номер", "dances", "Номер_Группы", input_group.number, myConnection);
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT MAX(Номер) FROM dances WHERE Номер_Группы = @id";
command.Parameters.AddWithValue("id", input_group.number);
if (command.ExecuteScalar() != DBNull.Value && checkArray != null)
{
max = Convert.ToInt32(command.ExecuteScalar());
//MessageBox.Show($"MAX в группе {input_group.number}: " + Convert.ToString(max));
foreach (bool item in checkArray)
{
if (i <= max)
{
if (checkArray[i - 1])
{
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT Танец FROM dances WHERE Номер = @id AND Номер_Группы = @num";
command.Parameters.AddWithValue("id", i);
command.Parameters.AddWithValue("num", input_group.number);
string category = command.ExecuteScalar().ToString();
//MessageBox.Show(category);
CategoryList_New.Add(category); //ДОРАБОТКА
}
else
{
counter++;
}
}
i++;
}
}
else
{
MessageBox.Show("Нулевой результат запроса");
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка танцев\nError: " + ex.Message);
}
myConnection.Close();
return(CategoryList_New);
}
/// <summary>
/// Get ID of record from SQL query, issued to currently open database.
/// </summary>
/// <param name="sql"></param>
/// <returns>ID of selected record.</returns>
public static Object GetId(string sql)
{
OleDbCommand cmd = new OleDbCommand(sql, OpenConnection());
return((int)cmd.ExecuteScalar());
}
public static List <Judge> TakeJudges(GroupClass input_group, string cn)
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
Judge new_judge = new Judge();
List <Judge> judgeList = new List <Judge>();
try
{
string judgesString = "";
string[] judgesStringList;
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT Судьи FROM groups WHERE Номер_Группы = @id";
command.Parameters.AddWithValue("id", input_group.number);
judgesString = command.ExecuteScalar().ToString().Replace(" ", "");
judgesStringList = judgesString.Split(new char[] { ';' });
//MessageBox.Show(judgesString);
judgeList = new List <Judge>();
for (int i = 0; i < judgesStringList.Length - 1; i++)
{
new_judge = new Judge();
int number = Convert.ToInt32(judgesStringList[i]);
//MessageBox.Show(number.ToString());
OleDbCommand command1 = new OleDbCommand("", myConnection);
command1.CommandText = "SELECT ФИО FROM judges WHERE Номер = @num";
command1.Parameters.AddWithValue("num", number);
string jSNP = command1.ExecuteScalar().ToString();
command1 = new OleDbCommand("", myConnection);
command1.CommandText = "SELECT Категория_Судейства FROM judges WHERE Номер = @num";
command1.Parameters.AddWithValue("num", number);
string jcategory = command1.ExecuteScalar().ToString().Replace(" ", "");
string[] jSNPList = jSNP.Split(new char[] { ' ' });
if (jSNPList.Length >= 3)
{
new_judge.Surname = jSNPList[0];
new_judge.Name = jSNPList[1];
new_judge.Patronymic = jSNPList[2];
}
new_judge.JudgeClass = jcategory;
new_judge.Number = (ushort)number;
new_judge.judgeChar = (char)(64 + number);
//MessageBox.Show(new_judge.ToString());
judgeList.Add(new_judge);
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка судей\nError: " + ex.Message);
}
myConnection.Close();
return(judgeList);
}
public static List <Duet> TakeDuets(GroupClass input_group, string cn)
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
List <Duet> DuetList_New = new List <Duet>();
try
{
int max = 0;
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT Count(Номер) FROM duets WHERE Номер_Группы = @id";
command.Parameters.AddWithValue("id", input_group.number);
max = Convert.ToInt32(command.ExecuteScalar());
//MessageBox.Show(max.ToString());
for (int i = 0; i < max; i++)
{
string Type;
string SNP1;
string SNP2;
int number;
Duet set_new = new Duet();
OleDbCommand command1 = new OleDbCommand("", myConnection);
OleDbCommand command2 = new OleDbCommand("", myConnection);
OleDbCommand command3 = new OleDbCommand("", myConnection);
OleDbCommand command4 = new OleDbCommand("", myConnection);
command1.CommandText = "SELECT Номер FROM duets WHERE Номер_Группы = @num AND Номер = @id";
command1.Parameters.AddWithValue("num", input_group.number);
command1.Parameters.AddWithValue("id", i + 1);
number = Convert.ToInt32(command1.ExecuteScalar());
//MessageBox.Show(number.ToString());
command2 = new OleDbCommand("", myConnection);
command2.CommandText = "SELECT Тип FROM duets WHERE Номер_Группы = @num AND Номер = @id";
command2.Parameters.AddWithValue("num", input_group.number);
command2.Parameters.AddWithValue("id", i + 1);
Type = command2.ExecuteScalar().ToString().Replace(" ", "");
//MessageBox.Show(Type);
command3 = new OleDbCommand("", myConnection);
command3.CommandText = "SELECT ФИО1 FROM duets WHERE Номер_Группы = @num AND Номер = @id";
command3.Parameters.AddWithValue("num", input_group.number);
command3.Parameters.AddWithValue("id", i + 1);
SNP1 = command3.ExecuteScalar().ToString().Replace(" ", "");
//SNP1 = command3.ExecuteScalar().ToString();
//MessageBox.Show(SNP1);
if (Type == "Пара")
{
command4 = new OleDbCommand("", myConnection);
command4.CommandText = "SELECT ФИО2 FROM duets WHERE Номер_Группы = @num AND Номер = @id";
command4.Parameters.AddWithValue("num", input_group.number);
command4.Parameters.AddWithValue("id", i + 1);
SNP2 = command4.ExecuteScalar().ToString().Replace(" ", "");
//MessageBox.Show(SNP2);
set_new = new Duet(number, input_group.number, SNP1, SNP2);
}
else
{
set_new = new Duet(number, input_group.number, SNP1);
}
DuetList_New.Add(set_new); //ДОРАБОТКА
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка пар\nError: " + ex.Message);
}
myConnection.Close();
return(DuetList_New);
}
public static List <SetClass> TakeSet(GroupClass input_group, string cn)
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
List <SetClass> SetList_New = new List <SetClass>();
try
{
int i = 1;
int max = 0;
int counter = 0;
BitArray checkArray = Controller.GapCounter("Номер_Захода", "sets", "Номер_Группы", input_group.number, myConnection);
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT MAX(Номер_Захода) FROM sets WHERE Номер_Группы = @id";
command.Parameters.AddWithValue("id", input_group.number);
if (command.ExecuteScalar() != DBNull.Value && checkArray != null)
{
max = Convert.ToInt32(command.ExecuteScalar());
//MessageBox.Show($"MAX в группе {input_group.number}: " + Convert.ToString(max));
foreach (bool item in checkArray)
{
if (i <= max)
{
if (checkArray[i - 1])
{
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT Категория FROM categories WHERE Номер_Группы = @num";
command.Parameters.AddWithValue("id", i);
command.Parameters.AddWithValue("num", input_group.number);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//if (reader["Номер_Книжки2"].ToString() != "")
//{
// Sportsman sportsman1 = new Sportsman();
// Sportsman sportsman2 = new Sportsman();
// outStr += " ";
// Num1 = (Convert.ToInt32(reader["Номер_Книжки1"]));
// Num2 = (Convert.ToInt32(reader["Номер_Книжки2"]));
// sportsman1 = Controller.SearchByBookNumberShort(Num1);
// sportsman1.BookNumber = Num1;
// sportsman1.GroupNumber = i + 1;
// sportsman2 = Controller.SearchByBookNumberShort(Num2);
// sportsman2.BookNumber = Num2;
// sportsman2.GroupNumber = i + 1;
// DuetList_New.Add(new Duet(Convert.ToInt32(reader["Номер"]) - 1, i, sportsman1, sportsman2));
// outStr += DuetList_New[j1].ToString() + "\n";
// j1++;
//}
}
}
else
{
counter++;
}
}
i++;
}
}
else
{
MessageBox.Show("Нулевой результат запроса");
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка заходов\nError: " + ex.Message);
}
myConnection.Close();
return(SetList_New);
}
//figure out Assign Status
public Boolean checkAllAssigned()
{
conn.Open();
allAssigned = false;
string allItemSQL = "SELECT COUNT(*) FROM ORD_ITEM WHERE ORDER_ID = " + orderID + "";
OleDbCommand cmdallItem = new OleDbCommand(allItemSQL, conn);
int allItemNum = Convert.ToInt32(cmdallItem.ExecuteScalar().ToString());
conn.Close();
conn.Open();
string allAssignedtatusSQL = "SELECT COUNT(ASM_USER) FROM ORD_ITEM WHERE ORDER_ID = " + orderID + "";
OleDbCommand cmdallAssignedtatus = new OleDbCommand(allAssignedtatusSQL, conn);
int assignedNum = Convert.ToInt32(cmdallAssignedtatus.ExecuteScalar().ToString());
conn.Close();
if (allItemNum == assignedNum)
{
if (assignedNum == 0)
{
conn.Open();
//find max pallet ID
string maxPalletID = "SELECT MAX(PALLET_ID) FROM ORD_ITEM";
OleDbCommand cmdmaxPalletID = new OleDbCommand(maxPalletID, conn);
conn.Close();
max_pallet_ID = cmdmaxPalletID.ExecuteScalar().ToString();
new_pallet_ID = max_pallet_ID + 1;
new_pallet_ID = (Convert.ToInt32(max_pallet_ID) + 1).ToString();
return(allAssigned = false);
}
else
{
conn.Open();
string assignedPallet = "SELECT DISTINCT PALLET_ID FROM ORD_ITEM WHERE ORDER_ID = " + orderID + "";
OleDbCommand cmdAssignedPalletID = new OleDbCommand(assignedPallet, conn);
existing_pallet_ID = cmdAssignedPalletID.ExecuteScalar().ToString();
conn.Close();
return(allAssigned = true);
}
}
else
{
if (assignedNum == 0)
{
conn.Open();
//find max pallet ID
string maxPalletID = "SELECT MAX(PALLET_ID) FROM ORD_ITEM";
OleDbCommand cmdmaxPalletID = new OleDbCommand(maxPalletID, conn);
max_pallet_ID = cmdmaxPalletID.ExecuteScalar().ToString();
conn.Close();
new_pallet_ID = max_pallet_ID + 1;
new_pallet_ID = (Convert.ToInt32(max_pallet_ID) + 1).ToString();
return(allAssigned = false);
}
return(allAssigned = false);
}
}
public int UpdateEx(DatabaseSet.工作單品號DataTable table)
{
int count = 0;
foreach (DatabaseSet.工作單品號Row row in table)
{
if (row.RowState != DataRowState.Added)
continue;
string idCmdTxt = "SELECT MAX(編號) FROM 工作單品號 WHERE 單號 = ?";
OleDbCommand cmd = new OleDbCommand(idCmdTxt, Instance.Connection);
cmd.Parameters.Add(new OleDbParameter("單號", row.單號));
Instance.Connection.Open();
object result = cmd.ExecuteScalar();
Instance.Connection.Close();
int id = 0;
if (result != DBNull.Value)
id = Convert.ToInt32(result);
row.編號 = id+1;
count += Instance.Update(row);
}
//string insertCmdTxt = "INSERT INTO 工作單品號 (單號, 品號, 數量, 實際完成日, 客戶需貨日, 預計完成日, 客戶, 編號) " +
// "VALUES (?, ?, ?, ?, ?, ?, ?, (SELECT MAX(編號) FROM 工作單品號 WHERE 單號 = ?))";
//string updateCmdTxt = "UPDATE 工作單品號 SET 單號=?, 品號=?, 數量=?, 實際完成日=?, 客戶需貨日=?, 預計完成日=?, 客戶 = ?, 編號 = ?";
//OleDbCommand insertCmd = new OleDbCommand(insertCmdTxt, Instance.Connection);
//insertCmd.Parameters.Add("單號", OleDbType.VarWChar);
//insertCmd.Parameters.Add("品號", OleDbType.VarWChar);
//insertCmd.Parameters.Add("數量", OleDbType.VarWChar);
//insertCmd.Parameters.Add("實際完成日", OleDbType.Date);
//insertCmd.Parameters.Add("客戶需貨日", OleDbType.Date);
//insertCmd.Parameters.Add("預計完成日", OleDbType.Date);
//insertCmd.Parameters.Add("客戶", OleDbType.VarWChar);
//insertCmd.Parameters.Add("單號2", OleDbType.VarWChar,255,"單號");
//Instance.Adapter.InsertCommand = insertCmd;
////OleDbCommand updateCmd = new OleDbCommand(updateCmdTxt, Instance.Connection);
////Instance.Adapter.UpdateCommand = updateCmd;
count += Instance.Update(table);
return count;
}
public static TournirClass TakeTournir(string cn)
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
int Num = 1;
TournirClass RetTournir = new TournirClass();
OleDbCommand command1 = new OleDbCommand("", myConnection);
OleDbCommand command2 = new OleDbCommand("", myConnection);
OleDbCommand command3 = new OleDbCommand("", myConnection);
OleDbCommand command4 = new OleDbCommand("", myConnection);
OleDbCommand command5 = new OleDbCommand("", myConnection);
OleDbCommand command6 = new OleDbCommand("", myConnection);
OleDbCommand command7 = new OleDbCommand("", myConnection);
command1.CommandText = "SELECT Название FROM tournir WHERE ID = @Num";
command1.Parameters.AddWithValue("Num", Num);
command2.CommandText = "SELECT Дата_Проведения FROM tournir WHERE ID = @Num";
command2.Parameters.AddWithValue("Num", Num);
command3.CommandText = "SELECT Время_Проведения FROM tournir WHERE ID = @Num";
command3.Parameters.AddWithValue("Num", Num);
command4.CommandText = "SELECT Место_Проведения FROM tournir WHERE ID = @Num";
command4.Parameters.AddWithValue("Num", Num);
command5.CommandText = "SELECT Организация FROM tournir WHERE ID = @Num";
command5.Parameters.AddWithValue("Num", Num);
command6.CommandText = "SELECT ФИО_Секретаря FROM tournir WHERE ID = @Num";
command6.Parameters.AddWithValue("Num", Num);
command7.CommandText = "SELECT ФИО_Регистратора FROM tournir WHERE ID = @Num";
command7.Parameters.AddWithValue("Num", Num);
try
{
RetTournir.name = command1.ExecuteScalar().ToString();
RetTournir.date.ToInt(command2.ExecuteScalar().ToString());
RetTournir.time.ToInt(command3.ExecuteScalar().ToString());
RetTournir.place = command4.ExecuteScalar().ToString();
RetTournir.organisation = command5.ExecuteScalar().ToString();
RetTournir.secretary = command6.ExecuteScalar().ToString();
RetTournir.registrator = command7.ExecuteScalar().ToString();
//MessageBox.Show($"Турнир: {RetTournir.name}\nДата: {RetTournir.date}\nВремя: {RetTournir.time}\nМесто: {RetTournir.place}\nОрганизация: {RetTournir.organisation}\nСекретарь: {RetTournir.secretary}\nРегистратор: {RetTournir.registrator}");
//myConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так... код 1\nError: " + ex.Message);
} //заполнение Турнира
try
{
int i = 1;
int k = 0;
string name = "";
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT COUNT(Номер_Группы) FROM groups";
k = Convert.ToInt32(command.ExecuteScalar());
//MessageBox.Show("Количество групп: " + Convert.ToString(k));
while (i <= k)
{
myConnection = new OleDbConnection(connectString);
myConnection.Open();
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT Категория FROM groups WHERE Номер_Группы = @id";
command.Parameters.AddWithValue("id", i);
name = Convert.ToString(command.ExecuteScalar());
RetTournir.groups.Add(new GroupClass(i, RetTournir.name, name));
RetTournir.groups[i - 1].CategoryList = TakeCategory(RetTournir.groups[i - 1], cn);
RetTournir.groups[i - 1].DancesList = TakeDances(RetTournir.groups[i - 1], cn);
RetTournir.groups[i - 1].JudgeList = TakeJudges(RetTournir.groups[i - 1], cn);
//MessageBox.Show(RetTournir.groups[i - 1].show());
//MessageBox.Show("Вытягивание списка пар");
RetTournir.groups[i - 1].duetList = TakeDuets(RetTournir.groups[i - 1], cn);
//MessageBox.Show(RetTournir.groups[i - 1].show());
i++;
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка групп\nError: " + ex.Message);
} //заполнение групп
try
{
myConnection = new OleDbConnection(connectString);
myConnection.Open();
BitArray checkArray = Controller.GapCounter("Номер", "judges", myConnection);
int i1 = 0;
int counter = 0;
int k1 = 0;
int max = 0;
command = new OleDbCommand("", myConnection);
command.CommandText = "SELECT COUNT(Номер) FROM judges";
command3 = new OleDbCommand("", myConnection);
command3.CommandText = "SELECT MAX(Номер) FROM judges";
k1 = Convert.ToInt32(command.ExecuteScalar());
//MessageBox.Show("Количество судей: " + Convert.ToString(k1));
if (k1 > 0)
{
max = Convert.ToInt32(command3.ExecuteScalar());
//MessageBox.Show("Максимальный номер судьи: " + Convert.ToString(max));
foreach (bool item in checkArray)
{
if (i1 < max)
{
if (checkArray[i1])
{
Judge judge_new = new Judge();
command1 = new OleDbCommand("SELECT ФИО FROM judges WHERE Номер = @id", myConnection); //NSP
command1.Parameters.AddWithValue("id", i1 + 1);
command2 = new OleDbCommand("SELECT Категория_Судейства FROM judges WHERE Номер = @id", myConnection); //JudjeClass
command2.Parameters.AddWithValue("id", i1 + 1);
judge_new.ToJudge(command1.ExecuteScalar().ToString());
judge_new.JudgeClass = command2.ExecuteScalar().ToString();
judge_new.Number = (ushort)(i1 + 1);
judge_new.judgeChar = (char)(64 + judge_new.Number);
RetTournir.judges.Add(judge_new);
//MessageBox.Show(RetTournir.judges[i1 - counter].ToNSP() + " " + RetTournir.judges[i1 - counter].JudgeClass);
}
else
{
counter++;
}
}
i1++;
}
}
else
{
//MessageBox.Show($"Не зарегистрировано ниодного судьи!");
}
}
catch (Exception ex)
{
MessageBox.Show("Упс, что-то пошло не так при определении списка судей\nError: " + ex.Message);
} //заполнение судей
myConnection.Close();
RetTournir.Show();
return(RetTournir);
}
public int GetFinishProductAmount(string worksheet, int wpid)
{
string cmdTxt = "SELECT SUM(數量) FROM 工時 WHERE 工作單號 = '" + worksheet + "' AND 工品編號 = " + wpid + " GROUP BY 工作單號, 工品編號";
OleDbCommand cmd = new OleDbCommand(cmdTxt);
cmd.Connection = this.Connection;
this.Connection.Open();
object o = cmd.ExecuteScalar();
int result = 0;
if (o != null && o != DBNull.Value)
result = (int)(double)o;
this.Connection.Close();
return result;
}
//添加新物标信息到数据库，并返回物标的再数据库中的id，即serverId
public int API_AddObjToData(string objLayerId, string objType, string objName, string objContent, string objGeo, string company, string objStyleId, string objImgUrl)
{
int imgWidth = 0;
int imgHeight = 0;
if (!objImgUrl.Equals(""))
{
API_GetImgSizeByUrl(objImgUrl, ref imgWidth, ref imgHeight);
}
int iPointServerId = -1;
string strSql = "insert into ObjTable(iObjLayerId,strObjName,strObjContent,strObjGeo,dtObjDate,strCompany,iObjStyleId,strObjImgUrl,iObjImgWidth,iObjImgHeight)values(@objLayerId,@objName,@objContent,@objGeo,@objDate,@company,@objStyleId,@objImgUrl,@objImgWidth,@objImgHeight)";
string strConn = YimaDataBase.GetSqlConnectionString();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
using (OleDbCommand cmd = new OleDbCommand(strSql, conn))
{
cmd.Parameters.Add("objLayerId", OleDbType.Integer);
cmd.Parameters["objLayerId"].Value = Convert.ToInt32(objLayerId);
cmd.Parameters.Add("objName", OleDbType.VarChar, 50);
cmd.Parameters["objName"].Value = objName;
cmd.Parameters.Add("objContent", OleDbType.VarChar, 100);
cmd.Parameters["objContent"].Value = objContent;
cmd.Parameters.Add("objGeo", OleDbType.VarChar, 2000);
cmd.Parameters["objGeo"].Value = objGeo;
cmd.Parameters.Add("objDate", OleDbType.Date);
cmd.Parameters["objDate"].Value = DateTime.Now;
cmd.Parameters.Add("company", OleDbType.VarChar, 50);
cmd.Parameters["company"].Value = company;
cmd.Parameters.Add("objStyleId", OleDbType.Integer);
cmd.Parameters["objStyleId"].Value = Convert.ToInt32(objStyleId);
cmd.Parameters.Add("objImgUrl", OleDbType.VarChar, 50);
cmd.Parameters["objImgUrl"].Value = objImgUrl;
cmd.Parameters.Add("objImgWidth", OleDbType.Integer);
cmd.Parameters["objImgWidth"].Value = imgWidth;
cmd.Parameters.Add("objImgHeight", OleDbType.Integer);
cmd.Parameters["objImgHeight"].Value = imgHeight;
try
{
conn.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)//得到刚刚插入的记录id（即标注id）
{
cmd.CommandText = "select @@identity as id";
iPointServerId = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch (Exception ex)
{
string message = ex.ToString();
}
}
}
return(iPointServerId);
}
public int Reinspect(string from, string to, string qcn, int amount)
{
this.Connection.Open();
OleDbTransaction transaction = this.Connection.BeginTransaction();
int result = 0;
try
{
string cmdText = "SELECT 送檢次數 FROM 產品檢驗 WHERE 工時資料編號 = ?";
OleDbCommand cmd = new OleDbCommand(cmdText, this.Connection);
cmd.Transaction = transaction;
cmd.Parameters.Add(new OleDbParameter("工時資料編號", from));
int num = Convert.ToInt32(cmd.ExecuteScalar());
cmdText = "INSERT INTO 產品檢驗 (工時資料編號,QCN,待驗數量,送檢次數,最後送檢編號,送檢日期) VALUES (?,?,?,?,?,?)";
cmd = new OleDbCommand(cmdText, this.Connection);
cmd.Transaction = transaction;
cmd.Parameters.Add(new OleDbParameter("工時資料編號1", to));
cmd.Parameters.Add(new OleDbParameter("QCN", qcn));
cmd.Parameters.Add(new OleDbParameter("待驗數量", amount));
cmd.Parameters.Add(new OleDbParameter("送檢次數", num + 1));
cmd.Parameters.Add(new OleDbParameter("最後送檢編號", to));
//cmd.Parameters.Add(new OleDbParameter("送檢日期", DateTime.Today));
OleDbParameter paramDate = new OleDbParameter();
paramDate.OleDbType = OleDbType.DBTimeStamp;
paramDate.Value = DateTime.Now.ToString("s");
cmd.Parameters.Add(paramDate);
result = cmd.ExecuteNonQuery();
cmdText = "UPDATE 產品檢驗 SET 重驗 = True WHERE 工時資料編號 = ?";
cmd = new OleDbCommand(cmdText, this.Connection);
cmd.Transaction = transaction;
//cmd.Parameters.Add(new OleDbParameter("最後送檢編號", to));
cmd.Parameters.Add(new OleDbParameter("工時資料編號", from));
cmd.ExecuteNonQuery();
cmdText = "UPDATE 產品檢驗 SET 最後送檢編號 = ? WHERE 最後送檢編號 = ?";
cmd = new OleDbCommand(cmdText, this.Connection);
cmd.Transaction = transaction;
cmd.Parameters.Add(new OleDbParameter("最後送檢編號1", to));
cmd.Parameters.Add(new OleDbParameter("最後送檢編號2", from));
cmd.ExecuteNonQuery();
cmdText = "INSERT INTO NG原因 (工時資料編號, 原因, 來源編號) SELECT '" + to + "' as 工時資料編號, 原因, 來源編號 FROM NG原因 WHERE 工時資料編號 = ?";
cmd = new OleDbCommand(cmdText, this.Connection);
cmd.Transaction = transaction;
cmd.Parameters.Add(new OleDbParameter("工時資料編號", from));
cmd.ExecuteNonQuery();
transaction.Commit();
this.Connection.Close();
return result;
}
catch (Exception ex)
{
transaction.Rollback();
this.Connection.Close();
throw ex;
}
}
/// <summary>
/// Insert Order and Order Items
/// </summary>
/// <param name="nCustomerId">customer id</param>
/// <param name="bIsPaymentOnDelivery">is payment on delivery</param>
/// <param name="dDepositAmt">deposit amount</param>
/// <param name="nStatusId">status id</param>
/// <param name="nPaymentId">payment id</param>
/// <param name="dtOrderItems">Data table of order items</param>
/// <returns></returns>
public bool InsertOrder(int nCustomerId, bool bIsPaymentOnDelivery, decimal dDepositAmt, int nStatusId, int nPaymentId, DataTable dtOrderItems)
{
OleDbCommand dbCommand;
int nOrderId = 0;
bool bSuccess = false;
try
{
//New Database connection
using (dbConnection = new OleDbConnection(sConnString))
{
// Open database connection
dbConnection.Open();
// SQL statement insert the customer
string sqlStmt = "INSERT INTO OrderT([CustomerID],[IsPaymentOnDelivery],[DepositAmt],[StatusID],[OrderDate],[PaymentID]) " +
"VALUES (@customerid,@ispaymentondelivery,@depositamt,@statusid,@orderdate,@paymentid)";
// New command passing sql statement and the connection to the database
dbCommand = new OleDbCommand(sqlStmt, dbConnection);
// Parameters
dbCommand.Parameters.Add(new OleDbParameter("@customerid", nCustomerId));
dbCommand.Parameters.Add(new OleDbParameter("@ispaymentondelivery", bIsPaymentOnDelivery));
dbCommand.Parameters.Add(new OleDbParameter("@depositamt", dDepositAmt));
dbCommand.Parameters.Add(new OleDbParameter("@statusid", nStatusId));
//Order Date
OleDbParameter parm = new OleDbParameter("@orderdate", OleDbType.Date);
parm.Value = DateTime.Now;
dbCommand.Parameters.Add(parm);
dbCommand.Parameters.Add(new OleDbParameter("@paymentid", nPaymentId));
//Execute query
if (dbCommand.ExecuteNonQuery() > 0)
{
//Get OrderId (Autonumber from database)
dbCommand.CommandText = "SELECT @@IDENTITY";
nOrderId = (int)dbCommand.ExecuteScalar();
if (nOrderId > 0)
{
bSuccess = true;
}
}
}
if (bSuccess)
{
//Insert Items
if (InsertOrderItems(nOrderId, dtOrderItems))
{
return(true);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(bSuccess);
}
protected void Page_Load(object sender, EventArgs e)
{
uyegetir();
reklamgetir();
resimgoster();
sayfagetir();
filmgetir();
salongetir();
kampanyagetir();
seansgetir();
kullanicigetir();
if (!IsPostBack)
{
seansbilgigetir();
}
if (Session["giriskontrol"] == "0" || Session["giriskontrol"] == null)
{
Response.Redirect("admin.aspx");
}
List <object> lijst = new List <object>();
lijst.Add(DateTime.Now.Date.AddDays(-4));
lijst.Add(DateTime.Now.Date.AddDays(-3));
lijst.Add(DateTime.Now.Date.AddDays(-2));
lijst.Add(DateTime.Now.Date.AddDays(-1));
lijst.Add(DateTime.Now.Date);
Button4.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button4.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
Button5.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button5.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
Button6.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button6.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
Button7.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button7.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
Button8.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button8.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
Button12.Attributes.Add("onmouseover", "this.style.backgroundColor='#F57365'");
Button12.Attributes.Add("onmouseout", "this.style.backgroundColor='#E73523'");
Button16.Attributes.Add("onmouseover", "this.style.backgroundColor='#4B4B4B'");
Button16.Attributes.Add("onmouseout", "this.style.backgroundColor='#322F2F'");
if (!IsPostBack)
{
MultiView1.ActiveViewIndex = 3;
}
Label3.Text = Application.Get("ziyaretci").ToString();
try
{
baglanti.ConnectionString = "provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("Srezervasyon.mdb");
baglanti.Open();
OleDbCommand komut = new OleDbCommand("SELECT COUNT(*) FROM ziyaretci", baglanti);
Label4.Text = komut.ExecuteScalar().ToString();
OleDbCommand komut2 = new OleDbCommand("SELECT COUNT(*) FROM filmler", baglanti);
Label5.Text = komut2.ExecuteScalar().ToString();
OleDbCommand komut3 = new OleDbCommand("SELECT COUNT(*) FROM uyeler", baglanti);
Label6.Text = komut3.ExecuteScalar().ToString();
OleDbCommand komut4 = new OleDbCommand("SELECT COUNT(*) FROM biletler", baglanti);
Label8.Text = komut4.ExecuteScalar().ToString();
baglanti.Close();
}
catch
{
baglanti.Close();
Label4.Text = "Veritabanı Bağlantısı Kurulamadı";
}
foreach (var series in Chart1.Series)
{
series.Points.Clear();
}
Chart1.ChartAreas[0].AxisX.LabelStyle.Angle = -70;
baglanti.ConnectionString = "provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("Srezervasyon.mdb");
baglanti.Open();
OleDbDataAdapter adap = new OleDbDataAdapter("SELECT * FROM ziyaretci WHERE tarih like '" + lijst[4] + "'", baglanti);
DataSet dc = new DataSet();
adap.Fill(dc, "ziyaretci");
Chart1.Series["Tarih"].Points.Add(dc.Tables[0].Rows.Count);
OleDbDataAdapter adap2 = new OleDbDataAdapter("SELECT * FROM ziyaretci WHERE tarih like '" + lijst[3] + "'", baglanti);
DataSet dc2 = new DataSet();
adap2.Fill(dc2, "ziyaretci");
Chart1.Series["Tarih"].Points.Add(dc2.Tables[0].Rows.Count);
OleDbDataAdapter adap3 = new OleDbDataAdapter("SELECT * FROM ziyaretci WHERE tarih like '" + lijst[2] + "'", baglanti);
DataSet dc3 = new DataSet();
adap3.Fill(dc3, "ziyaretci");
Chart1.Series["Tarih"].Points.Add(dc3.Tables[0].Rows.Count);
OleDbDataAdapter adap4 = new OleDbDataAdapter("SELECT * FROM ziyaretci WHERE tarih like '" + lijst[1] + "'", baglanti);
DataSet dc4 = new DataSet();
adap4.Fill(dc4, "ziyaretci");
Chart1.Series["Tarih"].Points.Add(dc4.Tables[0].Rows.Count);
OleDbDataAdapter adap5 = new OleDbDataAdapter("SELECT * FROM ziyaretci WHERE tarih like '" + lijst[0] + "'", baglanti);
DataSet dc5 = new DataSet();
adap5.Fill(dc5, "ziyaretci");
Chart1.Series["Tarih"].Points.Add(dc5.Tables[0].Rows.Count);
baglanti.Close();
Chart1.Series["Tarih"].Points[0].AxisLabel = lijst[4].ToString();
Chart1.Series["Tarih"].Points[1].AxisLabel = lijst[3].ToString();
Chart1.Series["Tarih"].Points[2].AxisLabel = lijst[2].ToString();
Chart1.Series["Tarih"].Points[3].AxisLabel = lijst[1].ToString();
Chart1.Series["Tarih"].Points[4].AxisLabel = lijst[0].ToString();
}
ICollection editorial_categories_CreateDataSource()
{
// editorial_categories Show begin
editorial_categories_sSQL = "";
editorial_categories_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
sOrder = " order by e.editorial_cat_name Asc";
if (Utility.GetParam("Formeditorial_categories_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("Formeditorial_categories_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
//-------------------------------
// Build base SQL statement
//-------------------------------
editorial_categories_sSQL = "select [e].[editorial_cat_id] as e_editorial_cat_id, " +
"[e].[editorial_cat_name] as e_editorial_cat_name " +
" from [editorial_categories] e ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
editorial_categories_sSQL = editorial_categories_sSQL + sWhere + sOrder;
if (editorial_categories_sCountSQL.Length == 0)
{
int iTmpI = editorial_categories_sSQL.ToLower().IndexOf("select ");
int iTmpJ = editorial_categories_sSQL.ToLower().LastIndexOf(" from ") - 1;
editorial_categories_sCountSQL = editorial_categories_sSQL.Replace(editorial_categories_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = editorial_categories_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
editorial_categories_sCountSQL = editorial_categories_sCountSQL.Substring(0, iTmpI);
}
}
System.Data.SqlClient.SqlDataAdapter c;
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(editorial_categories_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_editorial_categories_curpage - 1) * editorial_categories_PAGENUM, editorial_categories_PAGENUM, "editorial_categories");
OleDbCommand ccommand = new OleDbCommand(editorial_categories_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
editorial_categories_Pager.MaxPage = (PageTemp % editorial_categories_PAGENUM) > 0?(int)(PageTemp / editorial_categories_PAGENUM) + 1:(int)(PageTemp / editorial_categories_PAGENUM);
bool AllowScroller = editorial_categories_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
editorial_categories_no_records.Visible = true;
AllowScroller = false;
}
else
{
editorial_categories_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
editorial_categories_Pager.Visible = AllowScroller;
return(Source);
// editorial_categories Show end
}
private void SubCat_TextChanged(object sender, EventArgs e)
{
OleDbConnection Connection = new OleDbConnection(Con.ConnectionString());
try
{
OleDbCommand SELECT = new OleDbCommand("SELECT COUNT(SubCatagory) FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
SELECT.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
SELECT.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
Connection.Open();
if (SELECT.ExecuteScalar().ToString() == "1")
{
button1.Text = "Update";
button3.Enabled = true;
OleDbCommand FINDDESC = new OleDbCommand("SELECT Descriptions FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
FINDDESC.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
FINDDESC.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
Des.Text = FINDDESC.ExecuteScalar().ToString();
OleDbCommand FINDSUP1 = new OleDbCommand("SELECT Supplier1 FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
FINDSUP1.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
FINDSUP1.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
if (Sup1.Text.ToString() == FINDSUP1.ExecuteScalar().ToString())
{
Sup1.Checked = true;
}
else
{
Sup1.Checked = false;
}
OleDbCommand FINDSUP2 = new OleDbCommand("SELECT Supplier2 FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
FINDSUP2.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
FINDSUP2.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
if (Sup2.Text.ToString() == FINDSUP2.ExecuteScalar().ToString())
{
Sup2.Checked = true;
}
else
{
Sup2.Checked = false;
}
OleDbCommand FINDSUP3 = new OleDbCommand("SELECT Supplier3 FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
FINDSUP3.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
FINDSUP3.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
if (Sup3.Text.ToString() == FINDSUP3.ExecuteScalar().ToString())
{
Sup3.Checked = true;
}
else
{
Sup3.Checked = false;
}
OleDbCommand FINDUNIT = new OleDbCommand("SELECT Units FROM SubCatagory WHERE SubCatagory=@SubCatagory AND Catagory=@Catagory", Connection);
FINDUNIT.Parameters.AddWithValue("@SubCatagory", SubCat.Text.ToString());
FINDUNIT.Parameters.AddWithValue("@Catagory", Cat.SelectedItem.ToString());
unit.Text = FINDUNIT.ExecuteScalar().ToString();
}
else
{
button1.Text = "Save";
button3.Enabled = false;
Des.Text = "";
Sup1.Checked = true;
Sup2.Checked = true;
Sup3.Checked = true;
unit.Text = "";
}
Connection.Close();
}
catch
{
//----------------------------------------------------------------
}
}
private void pictureBox10_Click(object sender, EventArgs e)
{
string message = "Você deseja abrir um novo cadastro?";
string caption = "Novo Cadastro";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(this, message, caption, buttons,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
string strConnection = "Data Source=.\\SQLEXPRESS;Initial Catalog=GC;User ID=sa;Password=#lecoteco1975 ;Provider=SQLOLEDB";
//define a instrução SQL para somar Quantidade e agrupar resultados
String strSQL = "SELECT IDENT_CURRENT ( 'Participantes' )";
//cria a conexão com o banco de dados
OleDbConnection dbConnection = new OleDbConnection(strConnection);
//cria a conexão com o banco de dados
OleDbConnection con = new OleDbConnection(strConnection);
//cria o objeto command para executar a instruçao sql
OleDbCommand cmd = new OleDbCommand(strSQL, con);
//abre a conexao
con.Open();
cmd.CommandType = CommandType.Text;
label41.Text = Convert.ToString(cmd.ExecuteScalar());
con.Dispose();
con.Close();
cmd.Dispose();
dbConnection.Dispose();
dbConnection.Close();
//atribui o datatable ao datagridview para exibir o resultado
//dataGridView1.DataSource = clientes;
comboBox21.Text = "Cliente";
comboBox20.Text = "Ativo";
comboBox13.Text = "Brasil";
comboBox12.Text = "SP";
textBox12.Text = "";
textBox16.Text = "";
textBox14.Text = "";
textBox13.Text = "";
textBox25.Text = "";
richTextBox1.Text = "";
textBox17.Text = "";
textBox11.Text = "";
textBox8.Text = "";
textBox19.Text = "";
textBox22.Text = "";
textBox23.Text = "";
textBox7.Text = "";
textBox24.Text = "";
textBox2.Text = "";
textBox4.Text = "";
Global.Margem.cadParticipantesEstado = "ok";
MessageBox.Show("Aberto novo cadastro de Participantes");
}
if (result == DialogResult.No)
{
return;
}
}
private void vyvod(string s)
{
try
{
back.Visibility = Visibility.Hidden;
int count = 0;
string str1 = "select count (*) from " + s;
string str2 = "select " + s + "_name ," + s + "_id from " + s + " where " + s + "_id = ";
content1.Children.Clear();
con.Open();
OleDbCommand com = new OleDbCommand();
com.CommandText = str1;
com.Connection = con;
count = Convert.ToInt16(com.ExecuteScalar());
OleDbDataReader reader = com.ExecuteReader();
reader.Close();
string textblock = "";
string id = "";
for (int i = 1; i <= count; i++)
{
StackPanel stp = new StackPanel();
TextBlock txb = new TextBlock();
com.CommandText = str2 + i;
reader = com.ExecuteReader();
while (reader.Read())
{
textblock = reader.GetValue(0).ToString();
id = reader.GetValue(1).ToString();
}
reader.Close();
//MessageBox.Show(str2);
stp.Orientation = Orientation.Horizontal;
stp.Width = content1.Width;
stp.Height = 40;
txb.Text = textblock;
txb.TextWrapping = TextWrapping.Wrap;
txb.FontSize = 14;
txb.Tag = id;
txb.VerticalAlignment = VerticalAlignment.Center;
txb.TextWrapping = TextWrapping.WrapWithOverflow;
txb.Width = content1.Width;
txb.Foreground = Brushes.Black;
txb.FontFamily = new FontFamily("Segoe UI");
stp.Margin = new Thickness(10, 10, 0, 0);
stp.Background = Brushes.LightSteelBlue;
txb.Margin = new Thickness(5, 0, 0, 0);
content1.Children.Add(stp);
stp.Children.Add(txb);
txb.PreviewMouseUp += new System.Windows.Input.MouseButtonEventHandler(txb_MouseUp);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
finally
{
con.Close();
}
}
/// <summary>
/// Tests the connection.
/// </summary>
public override void TestConnection()
{
using (var con = CreateConnection())
using (var cmd = new OleDbCommand("SELECT 1", con))
cmd.ExecuteScalar();
}
protected void Page_Load(object sender, EventArgs e)
{
//Controleren als de gebruiker is aangemeld en welk type
if (Session["SoortGebr"] == null)
{
Server.Transfer("Home.aspx");
}
if (!IsPostBack)
{
lblMelding.Visible = false;
}
//Filteren van de detailsviews
try
{
dtsArtikel.FilterExpression = "ArtikelID=" + Session["ArtikelID"];
ddvArtikel.DataBind();
dtsGebruikers.FilterExpression = "ArtikelID=" + Session["ArtikelID"];
gdvGebruiker.DataBind();
}
catch
{
Server.Transfer("Menu.aspx");
}
//opvragen van de startprijs en einddatum voor controle te kunnen uitvoeren bij het bod plaatsen
OleDbCommand cmdStartprijs = new OleDbCommand();
cmdStartprijs.Connection = cnn;
cmdStartprijs.CommandText = "SELECT StartPrijs, Einddatum FROM Artikel WHERE ArtikelID = @artikel";
cmdStartprijs.Parameters.AddWithValue("@artikel", Session["ArtikelID"]);
cnn.Open();
OleDbDataReader drGegevens = cmdStartprijs.ExecuteReader();
while (drGegevens.Read())
{
Session["Startprijs"] = Convert.ToInt32(drGegevens[0]);
Session["Einddatum"] = Convert.ToDateTime(drGegevens[1]);
}
cnn.Close();
//Het hoogste bod opvragen van het artikel voor te controleren bij het plaatsten van een bod
OleDbCommand cmdhoogste = new OleDbCommand();
cmdhoogste.Connection = cnn;
cmdhoogste.CommandText = "SELECT TOP 1 Bod.Bod, Artikel.ArtikelID FROM Gebruiker INNER JOIN(Artikel INNER JOIN Bod ON Artikel.ArtikelID = Bod.ArtikelID) ON Gebruiker.GebruikerID = Bod.GebruikerID WHERE Bod.ArtikelID = @artikel ORDER BY BodID DESC";
cmdhoogste.Parameters.AddWithValue("@artikel", Session["ArtikelID"]);
cnn.Open();
Session["HBod"] = cmdhoogste.ExecuteScalar();
cnn.Close();
if (Convert.ToInt16(Session["HBod"]) <= 0)
{
Session["HBod"] = 0;
}
//Bieden onmogelijk maken als de einddatum is bereikt
if (Convert.ToDateTime(Session["Einddatum"]) < DateTime.Today)
{
pnlBieden.Visible = false;
lblFout.Visible = true;
lblFout.Text = "Het bieden voor dit artikel is afgesloten.";
}
else
{
pnlBieden.Visible = true;
lblFout.Visible = false;
}
}
/// <summary>
/// 结账
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
//=========================
if (this.txtzf.Text.Trim() == "")
{
MessageBox.Show("没有输入支付金额");
return;
}
string j1 = this.labzy.Text.ToString();
int jj = int.Parse(j1);
if (jj >= 0)
{
string wz = null;
conn = new OleDbConnection(str);
conn.Open();
string sqlcxz = "select sum(zjg) from tb_Zongjine ";
cmd = new OleDbCommand(sqlcxz, conn);
object jine = cmd.ExecuteScalar();
for (int i = 0; i < this.trezj.Nodes.Count; i++)
{
wz = this.trezj.Nodes[i].Text;
//没有消费结账
if (this.txtshje.Text == null)
{
string sqlxg1 = "update tb_Room set RoomZT='待用' where RoomJC='" + wz + "'";
cmd.CommandText = sqlxg1;
cmd.ExecuteScalar();
}
//修改状态为待用跟ROOM时间状态
string sqlxg = "update tb_Room set RoomZT='待用',zhangdanDate=null where RoomJC='" + wz + "'";
cmd.CommandText = sqlxg;
cmd.ExecuteScalar();
//添加消费表
string cslei = "select * from tb_xfxf where cth='" + wz + "' ";
cmd.CommandText = cslei;
OleDbDataReader der = cmd.ExecuteReader();
//查询餐台号循环添加 到离店消费
while (der.Read())
{
string dqxf = "insert into tb_xfcxlx(cth,xmmc,dj,zk,sl,je,dcsj,jzr)values('" + der["cth"].ToString() + "','" + der["xmmc"].ToString() + "'," + der["dj"].ToString() + "," + der["zk"].ToString() + "," + der["sl"].ToString() + "," + der["je"].ToString() + ",'" + der["dcsj"].ToString() + "','" + der["jzr"].ToString() + "') ";
cmd = new OleDbCommand(dqxf, conn);
cmd.ExecuteScalar();
}
der.Close();
string sqlsc = "delete from tb_xfxf where cth='" + wz + "'";
cmd.CommandText = sqlsc;
cmd.ExecuteScalar();
}
string bqh = null;
//往会员卡添加累加金额
this.zongjie = this.labje.Text;//结算总金额
if (this.txtbkmc.Text.Trim() != "")
{
string sbqsl = "select c.id from tb_huiyuan a,tb_huiyuk b,tb_kxf c where a.id=b.kx and b.id=c.bh1 and name='" + this.txtbkmc.Text + "' "; //拿到顾客姓名进行多表联查
cmd = new OleDbCommand(sbqsl, conn);
int jkid = Convert.ToInt32(cmd.ExecuteScalar()); //获取人手中的金卡id
string jkljxf = "update tb_kxf set ljxf = ljxf+" + this.labje.Text + " where id=" + jkid + "";
cmd.CommandText = jkljxf;
cmd.ExecuteScalar();
string cxhybh = "select hybh from tb_huiyuan where name='" + this.txtbkmc.Text + "' ";
cmd = new OleDbCommand(cxhybh, conn);
object a = cmd.ExecuteScalar();
//判断是否为空
if (a == null)
{
bqh = "";
}
else
{
bqh = a.ToString();
}
}
//-----------------------------------------------添加到消费查询表 tb_htxf
if (this.checkBox4.Checked == true)
{
string sqljxf = "insert into tb_hyxf (mc,xfrq,jsrq,hybh,zdh,ysje,shje,jszt,cth) values('" + this.txtbkmc.Text + "','" + FrmMain.jdzsj + "','" + DateTime.Now.ToString() + "','" + bqh + "','" + this.labzhh.Text + "'," + FrmJz.jcc + "," + this.txtshje.Text + ",'退单','" + this.labjzct.Text + "') ";
cmd = new OleDbCommand(sqljxf, conn);
cmd.ExecuteScalar();
}
else
{
string sqljxf = "insert into tb_hyxf (mc,xfrq,jsrq,hybh,zdh,ysje,shje,jszt,cth) values('" + this.txtbkmc.Text + "','" + FrmMain.jdzsj + "','" + DateTime.Now.ToString() + "','" + bqh + "','" + this.labzhh.Text + "'," + this.labje.Text + "," + this.txtshje.Text + ",'已结单','" + this.labjzct.Text + "') ";
cmd = new OleDbCommand(sqljxf, conn);
cmd.ExecuteScalar();
}
//----------------------------------------------------------删除来宾消息表
string sclbn = "delete from tb_LaiBing where cth='" + FrmJz.jcc + "'";
cmd = new OleDbCommand(sclbn, conn);
cmd.ExecuteScalar();
this.Dispose();
}
else
{
MessageBox.Show("金额不够");
}
conn.Close();
}
/// <summary>
/// Returns a page of errors from the databse in descending order
/// of logged time.
/// </summary>
public override int GetErrors(int pageIndex, int pageSize, IList errorEntryList)
{
if (pageIndex < 0)
{
throw new ArgumentOutOfRangeException("pageIndex", pageIndex, null);
}
if (pageSize < 0)
{
throw new ArgumentOutOfRangeException("pageSize", pageSize, null);
}
using (OleDbConnection connection = new OleDbConnection(this.ConnectionString))
using (OleDbCommand command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = "SELECT COUNT(*) FROM ELMAH_Error";
connection.Open();
int totalCount = (int)command.ExecuteScalar();
if (errorEntryList != null && pageIndex * pageSize < totalCount)
{
int maxRecords = pageSize * (pageIndex + 1);
if (maxRecords > totalCount)
{
maxRecords = totalCount;
pageSize = totalCount - pageSize * (totalCount / pageSize);
}
StringBuilder sql = new StringBuilder(1000);
sql.Append("SELECT e.* FROM (");
sql.Append("SELECT TOP ");
sql.Append(pageSize.ToString(CultureInfo.InvariantCulture));
sql.Append(" TimeUtc, ErrorId FROM (");
sql.Append("SELECT TOP ");
sql.Append(maxRecords.ToString(CultureInfo.InvariantCulture));
sql.Append(" TimeUtc, ErrorId FROM ELMAH_Error ");
sql.Append("ORDER BY TimeUtc DESC, ErrorId DESC) ");
sql.Append("ORDER BY TimeUtc ASC, ErrorId ASC) AS i ");
sql.Append("INNER JOIN Elmah_Error AS e ON i.ErrorId = e.ErrorId ");
sql.Append("ORDER BY e.TimeUtc DESC, e.ErrorId DESC");
command.CommandText = sql.ToString();
using (OleDbDataReader reader = command.ExecuteReader())
{
Debug.Assert(reader != null);
while (reader.Read())
{
string id = Convert.ToString(reader["ErrorId"], CultureInfo.InvariantCulture);
Error error = new Error();
error.ApplicationName = reader["Application"].ToString();
error.HostName = reader["Host"].ToString();
error.Type = reader["Type"].ToString();
error.Source = reader["Source"].ToString();
error.Message = reader["Message"].ToString();
error.User = reader["UserName"].ToString();
error.StatusCode = Convert.ToInt32(reader["StatusCode"]);
error.Time = Convert.ToDateTime(reader["TimeUtc"]).ToLocalTime();
errorEntryList.Add(new ErrorLogEntry(this, id, error));
}
reader.Close();
}
}
return(totalCount);
}
}
public FormZap(string table, int x)
{
InitializeComponent();
xx = x;
tablename = table;
//////////////////////////////////////////////////
switch (x)
{
case 1:
OleDbConnection myConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = apteka.mdb");
OleDbDataAdapter myAdapter = new OleDbDataAdapter("select * from " + table + "\"", myConnection);
DataSet dataSet = new DataSet();
myConnection.Open();
try
{
myAdapter.Fill(dataSet, "tabl");
}
catch
{
MessageBox.Show("Неверная SQL команда: либо Connection ");
}
finally { myConnection.Close(); }
label1.Text = dataSet.Tables[0].Columns[tekatr].ColumnName;
/////////////////////
nameid = dataSet.Tables[0].Columns[0].ColumnName;
break;
case 2:
OleDbConnection myConnection2 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = apteka.mdb");
OleDbDataAdapter myAdapter2 = new OleDbDataAdapter("select id_zakazch,Login,Password,who from Zakazchik", myConnection2);
DataSet dataSet2 = new DataSet();
myConnection2.Open();
try
{
myAdapter2.Fill(dataSet2, "tabl");
}
catch
{
MessageBox.Show("Неверная SQL команда: либо Connection ");
}
finally { myConnection2.Close(); }
label1.Text = dataSet2.Tables[0].Columns[tekatr].ColumnName;
/////////////////////
nameid = dataSet2.Tables[0].Columns[0].ColumnName;
break;
case 3:
OleDbConnection myConnection3 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = apteka.mdb");
OleDbDataAdapter myAdapter3 = new OleDbDataAdapter("select id_reg,Log,Pas from reg", myConnection3);
DataSet dataSet3 = new DataSet();
myConnection3.Open();
try
{
myAdapter3.Fill(dataSet3, "tabl");
}
catch
{
MessageBox.Show("Неверная SQL команда: либо Connection ");
}
finally { myConnection3.Close(); }
label1.Text = dataSet3.Tables[0].Columns[tekatr].ColumnName;
/////////////////////
nameid = dataSet3.Tables[0].Columns[0].ColumnName;
break;
}
if (x == 1)
{
OleDbConnection DB = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source =apteka.mdb");
DB.Open();
OleDbCommand command = new OleDbCommand("SELECT MAX(" + nameid + ") FROM " + table, DB);
string prom = command.ExecuteScalar().ToString();
try
{
id = Convert.ToInt32(prom);
id++;
DB.Close();
OleDbConnection DB1 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = apteka.mdb");
DB1.Open();
OleDbDataAdapter DA1 = new OleDbDataAdapter("insert into " + table + "(" + nameid + ") values(" + id.ToString() + ")", DB1);
DataTable DT1 = new DataTable();
DA1.Fill(DT1);
DB1.Close();
/////////////////////////////////////////////////////////////
}
catch
{
id = 1;
OleDbConnection DB1 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = apteka.mdb");
DB1.Open();
OleDbDataAdapter DA1 = new OleDbDataAdapter("insert into " + table + "(" + nameid + ") values(" + id.ToString() + ")", DB1);
DataTable DT1 = new DataTable();
DA1.Fill(DT1);
DB1.Close();
}
}
}
}//public static void DatabaseQuery()
/// <summary>The database query.</summary>
/// <param name="databaseConnectionString">The database connection string.</param>
/// <param name="exceptionMessage">The exception message.</param>
/// <param name="word">The word.</param>
/// <param name="scriptureReferenceAssociates">The scripture reference associates.</param>
/// <param name="alphabetSequence">The alphabet sequence.</param>
/// <param name="scriptureReferenceAlphabetSequence">The scripture reference alphabet sequence.</param>
public static void DatabaseQuery
(
ref string databaseConnectionString,
ref string exceptionMessage,
string[] word,
string scriptureReferenceAssociates,
ref int[] alphabetSequence,
ref ScriptureReferenceAlphabetSequence[] scriptureReferenceAlphabetSequence
)
{
int wordTotal = word.Length;
string chapterForward = null;
string chapterBackward = null;
string scriptureReference = null;
string scriptureReferenceChapterBackward = null;
string scriptureReferenceChapterForward = null;
string scriptureReferenceVerseBackward = null;
string scriptureReferenceVerseForward = null;
string verseForward = null;
string verseBackward = null;
OleDbConnection oleDbConnection = null;
OleDbCommand oleDbCommand = null;
OleDbDataReader oleDbDataReader = null;
OleDbParameter oleDbParameterWord = null;
OleDbParameter oleDbParameterScriptureReferenceAssociates = null;
OleDbParameter oleDbParameterAlphabetSequence = null;
OleDbParameter oleDbParameterScriptureReferenceVerseForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterForward = null;
OleDbParameter oleDbParameterScriptureReferenceChapterBackward = null;
OleDbParameter oleDbParameterScriptureReferenceVerseBackward = null;
OleDbParameter oleDbParameterScriptureReference = null;
OleDbParameter oleDbParameterVerseForward = null;
OleDbParameter oleDbParameterChapterForward = null;
OleDbParameter oleDbParameterChapterBackward = null;
OleDbParameter oleDbParameterVerseBackward = null;
AlphabetSequenceIndexCalculate
(
ref word,
ref alphabetSequence
);
try
{
if (databaseConnectionString == null)
{
databaseConnectionString = DatabaseConnectionString;
}//if ( databaseConnectionString == null )
oleDbConnection = UtilityDatabase.DatabaseConnectionInitialize
(
databaseConnectionString,
ref exceptionMessage
);
if (oleDbConnection == null || exceptionMessage != null)
{
return;
}//if ( oleDbConnection == null || exceptionMessage != null )
oleDbCommand = new OleDbCommand(SQLSelectAlphabetSequence, oleDbConnection);
oleDbCommand.CommandType = CommandType.StoredProcedure;
oleDbParameterWord = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceAssociates = new OleDbParameter(ParameterWord, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterAlphabetSequence = new OleDbParameter(ParameterAlphabetSequence, OleDbType.Integer);
oleDbParameterScriptureReferenceVerseForward = new OleDbParameter(ParameterScriptureReferenceVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterForward = new OleDbParameter(ParameterScriptureReferenceChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceChapterBackward = new OleDbParameter(ParameterScriptureReferenceChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReferenceVerseBackward = new OleDbParameter(ParameterScriptureReferenceVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterScriptureReference = new OleDbParameter(ParameterScriptureReference, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseForward = new OleDbParameter(ParameterVerseForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterForward = new OleDbParameter(ParameterChapterForward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterChapterBackward = new OleDbParameter(ParameterChapterBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbParameterVerseBackward = new OleDbParameter(ParameterVerseBackward, OleDbType.VarChar, DatabaseOutputParameterSize);
oleDbCommand.Parameters.Add(oleDbParameterWord);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceAssociates);
oleDbCommand.Parameters.Add(oleDbParameterAlphabetSequence);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReferenceVerseBackward);
oleDbCommand.Parameters.Add(oleDbParameterScriptureReference);
oleDbCommand.Parameters.Add(oleDbParameterVerseForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterForward);
oleDbCommand.Parameters.Add(oleDbParameterChapterBackward);
oleDbCommand.Parameters.Add(oleDbParameterVerseBackward);
oleDbParameterWord.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceAssociates.Direction = ParameterDirection.InputOutput;
oleDbParameterAlphabetSequence.Direction = ParameterDirection.InputOutput;
oleDbParameterScriptureReferenceVerseForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterForward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReferenceVerseBackward.Direction = ParameterDirection.Output;
oleDbParameterScriptureReference.Direction = ParameterDirection.Output;
oleDbParameterVerseForward.Direction = ParameterDirection.Output;
oleDbParameterChapterForward.Direction = ParameterDirection.Output;
oleDbParameterChapterBackward.Direction = ParameterDirection.Output;
oleDbParameterVerseBackward.Direction = ParameterDirection.Output;
for (int wordCount = 0; wordCount < wordTotal; ++wordCount)
{
oleDbParameterWord.Value = word[wordCount];
oleDbParameterScriptureReferenceAssociates.Value = scriptureReferenceAssociates;
oleDbParameterAlphabetSequence.Value = alphabetSequence[wordCount];
oleDbCommand.ExecuteScalar();
scriptureReferenceVerseForward = (oleDbParameterScriptureReferenceVerseForward.Value).ToString();
scriptureReferenceChapterForward = (oleDbParameterScriptureReferenceChapterForward.Value).ToString();
scriptureReferenceChapterBackward = (oleDbParameterScriptureReferenceChapterBackward.Value).ToString();
scriptureReferenceVerseBackward = (oleDbParameterScriptureReferenceVerseBackward.Value).ToString();
scriptureReference = (oleDbParameterScriptureReference.Value).ToString();
verseForward = (oleDbParameterVerseForward.Value).ToString();
chapterForward = (oleDbParameterChapterForward.Value).ToString();
chapterBackward = (oleDbParameterChapterBackward.Value).ToString();
verseBackward = (oleDbParameterVerseBackward.Value).ToString();
scriptureReferenceAlphabetSequence[wordCount] = new ScriptureReferenceAlphabetSequence
(
word[wordCount],
scriptureReferenceAssociates,
alphabetSequence[wordCount],
scriptureReferenceVerseForward,
scriptureReferenceChapterForward,
scriptureReferenceChapterBackward,
scriptureReferenceVerseBackward,
scriptureReference,
verseForward,
chapterForward,
chapterBackward,
verseBackward
);
return;
} //for ( int wordCount = 0; wordCount < word.Length; ++wordCount )
} //try
catch (OleDbException exception)
{
exceptionMessage = UtilityDatabase.DisplayOleDbErrorCollection(exception);
System.Console.WriteLine("OleDbException: {0}", exceptionMessage);
System.Console.WriteLine("OleDbException: {0}", oleDbParameterAlphabetSequence.Value);
return;
}//catch (OleDbException exception)
catch (Exception exception)
{
exceptionMessage = exception.Message;
System.Console.WriteLine("Exception: {0}", exception.Message);
return;
}//catch (Exception exception)
finally
{
if (oleDbDataReader != null)
{
oleDbDataReader.Close();
}
UtilityDatabase.DatabaseConnectionHouseKeeping
(
oleDbConnection,
ref exceptionMessage
);
} //finally
return;
} //AlphabetSequenceDatabaseQuery()
ICollection Items_CreateDataSource()
{
// Items Show begin
Items_sSQL = "";
Items_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//-------------------------------
// Build ORDER BY statement
//-------------------------------
if (Utility.GetParam("FormItems_Sorting").Length > 0 && !IsPostBack)
{
ViewState["SortColumn"] = Utility.GetParam("FormItems_Sorting");
ViewState["SortDir"] = "ASC";
}
if (ViewState["SortColumn"] != null)
{
sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString();
}
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("category_id"))
{
string temp = Utility.GetParam("category_id");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, FieldTypes.Number);
}
else
{
temp = "";
}
Params.Add("category_id", temp);
}
if (!Params.ContainsKey("is_recommended"))
{
string temp = Utility.GetParam("is_recommended");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, FieldTypes.Number);
}
else
{
temp = "";
}
Params.Add("is_recommended", temp);
}
if (Params["category_id"].Length > 0)
{
HasParam = true;
sWhere += "i.[category_id]=" + Params["category_id"];
}
if (Params["is_recommended"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "i.[is_recommended]=" + Params["is_recommended"];
}
if (HasParam)
{
sWhere = " AND (" + sWhere + ")";
}
//-------------------------------
// Build base SQL statement
//-------------------------------
Items_sSQL = "select [i].[author] as i_author, " +
"[i].[category_id] as i_category_id, " +
"[i].[is_recommended] as i_is_recommended, " +
"[i].[item_id] as i_item_id, " +
"[i].[name] as i_name, " +
"[i].[price] as i_price, " +
"[c].[category_id] as c_category_id, " +
"[c].[name] as c_name " +
" from [items] i, [categories] c" +
" where [c].[category_id]=i.[category_id] ";
//-------------------------------
//-------------------------------
//-------------------------------
//-------------------------------
// Assemble full SQL statement
//-------------------------------
Items_sSQL = Items_sSQL + sWhere + sOrder;
if (Items_sCountSQL.Length == 0)
{
int iTmpI = Items_sSQL.ToLower().IndexOf("select ");
int iTmpJ = Items_sSQL.ToLower().LastIndexOf(" from ") - 1;
Items_sCountSQL = Items_sSQL.Replace(Items_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) ");
iTmpI = Items_sCountSQL.ToLower().IndexOf(" order by");
if (iTmpI > 1)
{
Items_sCountSQL = Items_sCountSQL.Substring(0, iTmpI);
}
}
//-------------------------------
OleDbDataAdapter command = new OleDbDataAdapter(Items_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, (i_Items_curpage - 1) * Items_PAGENUM, Items_PAGENUM, "Items");
OleDbCommand ccommand = new OleDbCommand(Items_sCountSQL, Utility.Connection);
int PageTemp = (int)ccommand.ExecuteScalar();
Items_Pager.MaxPage = (PageTemp % Items_PAGENUM) > 0?(int)(PageTemp / Items_PAGENUM) + 1:(int)(PageTemp / Items_PAGENUM);
bool AllowScroller = Items_Pager.MaxPage == 1?false:true;
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
Items_no_records.Visible = true;
AllowScroller = false;
}
else
{
Items_no_records.Visible = false;
AllowScroller = AllowScroller && true;
}
Items_Pager.Visible = AllowScroller;
return(Source);
// Items Show end
}
public FuncStatus DataBind(BindOperator _bo)
{
bool _tf = true;
OleDbConnection _conn = new OleDbConnection(Prument.Properties.Settings.Default.Properties["dataConnectionString"].DefaultValue.ToString());
OleDbCommand _cmd = new OleDbCommand();
OleDbDataReader _dr;
_cmd.Connection = _conn;
try
{
_conn.Open();
if (_bo == BindOperator.Select)
{
_cmd.CommandText = "select Products.ID,Products.Name,Products.Description from Products where " + (this.ID != 0 ? "ID=" + this.ID.ToString() : (this.Name != null ? "Name='" + this.Name : "Description like '_" + this.Description + "_") + "'");
}
if (_bo == BindOperator.Insert)
{
_cmd.CommandText = "insert into Products (Name,Description) values ('" + this.Name + "','" + this.Description + "')";
_cmd.ExecuteScalar();
_cmd.CommandText = "select ID,Name,Description from products where id = (select Max(ID) from Products)";
}
if (_bo == BindOperator.Update) {
_cmd.CommandText = "update products set Name='" + this.Name + "',Description='" + this.Description + "' where ID=" +this.ID;
_cmd.ExecuteNonQuery();
_cmd.CommandText = "select ID,Name,Description from products where id = " + this.ID;
}
if (_bo == BindOperator.Delete)
{
_cmd.CommandText = "select ID,Name,Description from products where id = " + this.ID;
}
_dr = _cmd.ExecuteReader();
_dr.Read();
this.ID = _dr.GetInt32(0);
this.Name = _dr.GetValue(1).ToString();
this.Description = _dr.GetValue(2).ToString();
this.Images.pID = this.ID;
_dr.Close();
if (_bo == BindOperator.Select) {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Insert) {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Update && this.Images.Path[0] != "") {
Images.DataBind(_bo);
}
if (_bo == BindOperator.Delete)
{
_cmd.CommandText = "delete from products where ID=" + this.ID;
_cmd.ExecuteNonQuery();
this.Images.clear();
this.Images.DataBind(BindOperator.Update);
}
this.Status = ORMStatus.Saved;
}
catch (Exception ex)
{
_tf = false;
Exception _ex = new Exception("ORM.Products["+this.ID+"]:" + ex.Message);
throw _ex;
}
finally {
_conn.Close();
}
return _tf == false?FuncStatus.Fail:FuncStatus.Success;
}
