public string getAutoNum()
{
string str = "";
try
{
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
IDbCommand myComm = this.dboperator_0.Connection.CreateCommand();
myComm.Connection = (this.dboperator_0.Connection);
str = this.getAutoNum(myComm);
myComm.Dispose();
this.dboperator_0.Close();
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
return(str);
}
public static string Load(HttpRequest Request, DBOperator oDb, string sFileName)
{
string str = "";
try
{
string strSql = "select sText from fc_reportfile where sName='" + sFileName + "'";
oDb.Open();
IDataReader reader = oDb.exeSql(strSql);
if (reader.Read())
{
str = reader.GetString(0);
}
reader.Close();
}
catch (Exception exception)
{
str = exception.Message;
}
finally
{
try
{
oDb.Close();
}
catch (Exception)
{
}
}
return(str);
}
public void readImage(HttpResponse Response)
{
try
{
string strSql = "select " + this.string_1 + " from " + this.string_0 + " where " + this.string_2 + "='" + this.string_3 + "'";
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
Logger.debug("dbimg的读SQL语句:" + strSql);
IDataReader reader = this.dboperator_0.exeSql(strSql);
if (reader.Read())
{
byte[] buffer = (byte[])reader[(this.string_1)];
if (buffer != null)
{
Response.BinaryWrite(buffer);
}
}
reader.Close();
this.dboperator_0.Close();
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
}
/// <summary>
/// 初始化一个应用系统用户
/// </summary>
public static ResultOfInitBasicLogin InitBasicLogin(DBOperator dbOperator, int userID)
{
ResultOfInitBasicLogin myResult = new ResultOfInitBasicLogin();
Bigdesk2010.Business.UserRightManager.IUserRightInfo ur = new Bigdesk2010.Business.UserRightManager.UserRightInfo(dbOperator, userID);
if (ur.CountOfUserMatched < 1)
{
myResult.ResultCode = ResultCodeOfInitBasicLogin.用户不存在;
myResult.Message = "用户不存在！";
return(myResult);
}
else if (ur.CountOfUserMatched > 1)
{
myResult.ResultCode = ResultCodeOfInitBasicLogin.用户重复;
myResult.Message = "用户重复，请与系统管理员联系！";
return(myResult);
}
myResult.ResultCode = ResultCodeOfInitBasicLogin.唯一用户;
BasicLoginInfo workUser = new BasicLoginInfo();
workUser.UserID = ur.UserID;
workUser.LoginName = ur.LoginName;
workUser.UserName = ur.UserName;
workUser.UserType = ur.UserType;
workUser.OrgUnitName = ur.OrgUnitName;
myResult.WorkUser = workUser;
return(myResult);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string rep = comboBox1.SelectedValue.ToString();
string month = DateTime.Now.AddMonths(-1).ToString("MMMM, yyyy");
string condition = "";
if (rep != "All")
{
condition = " Rep = '" + rep + "' and ";
}
string sql = @"select Accountno as 'ID', Customer as 'Company', Contact, Phone, AltPhone, BalanceTotal as 'Balance', SalesTax, SalesTaxNum,
LiquorTax_Phila as 'LiquorTax', U_OTax from ClientDetail
where " + condition + @" (JobStatus='pending'
or (SalesTax in ('Monthly','Monthly(w/ Prepay)','Monthly(Sugar)') and JobStatus='current')
or (JobStatus<>'closed' and (LiquorTax_Phila='Yes' or U_OTax like 'Yes%')) )
order by JobStatus, Accountno";
DataTable dt = DBOperator.QuerySql(sql);
List <SalesTaxRep> items = DBOperator.getListFromTable <SalesTaxRep>(dt);
int total = dt.Rows.Count;
reportViewer1.LocalReport.DataSources.Clear();
ReportParameter repTitle = new ReportParameter("repTitle", "Monthly Query - " + rep);
ReportParameter repMonth = new ReportParameter("repMonth", month);
ReportParameter totalPar = new ReportParameter("totalNum", "Total #: " + total.ToString());
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { repTitle, repMonth, totalPar });
ReportDataSource rds = new ReportDataSource("dsMonthlySalesTax", items);
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.RefreshReport();
}
public string readClob()
{
string str = "";
try
{
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
IDbCommand command = this.dboperator_0.Connection.CreateCommand();
command.Connection = (this.dboperator_0.Connection);
command.CommandText = ("select " + this.string_1 + " from " + this.string_0 + " where " + this.string_2 + "='" + this.string_3 + "'");
str = command.ExecuteScalar().ToString();
command.Dispose();
this.dboperator_0.Close();
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
return(str);
}
private void importData(string filePath, string tableName, Label tMessage)
{
Label.CheckForIllegalCrossThreadCalls = false;
tMessage.Text = "Reading data from excel";
DataTable dt = ReadExcelToDataTable(filePath, tableName);
int total = dt.Rows.Count;
tMessage.Text = "Data has been read, there are " + total + " records.";
string sql = "";
sql = "delete " + tableName + "; ";
DBOperator.ExecuteSql(sql);
sql = "insert into " + tableName + " values";
for (int i = 0; i < dt.Rows.Count; i++)
{
sql += "(";
for (int j = 0; j < dt.Columns.Count; j++)
{
sql += "'" + dt.Rows[i][j].ToString().Replace("'", "''") + "',";
}
sql = sql.Substring(0, sql.Length - 1) + "), ";
if (i % 10 == 0)
{
sql = sql.Substring(0, sql.Length - 2);
DBOperator.ExecuteSql(sql);
sql = "insert into " + tableName + " values";
tMessage.Text = i + " records has been imported, " + (total - i) + " left.";
}
}
if (sql.Length > 40)
{
sql = sql.Substring(0, sql.Length - 2);
DBOperator.ExecuteSql(sql);
}
tMessage.Text = "begin to update ClientPayroll with new data of ClientDetail.";
if (tableName == "ClientDetail")
{
sql = @"update ClientPayroll set EIN=cd.EIN, AccRep=cd.Rep, Entity=cd.Customer, TradeName=cd.Company, BusAdd1=cd.BusAdd1,
CkRep=cd.PaycheckRep, PayRep=cd.PayrollRep,
BusAdd2=cd.BusAdd2, BusCity=cd.BusAdd3, BusSt=cd.BusAdd4 , BusZip=cd.BusAdd5, Fax=cd.Fax
from ClientDetail cd, ClientPayroll where AccNum=cd.AccountNo";
DBOperator.ExecuteSql(sql);
sql = @"select AccountNo, EIN, Rep, Customer, Company, BusAdd1, PaycheckRep, PayrollRep, BusAdd2, BusAdd3, BusAdd4, BusAdd5, Fax
from ClientDetail where AccountNo not in (select AccNum from ClientPayroll)";
dt = DBOperator.QuerySql(sql);
sql = "";
foreach (DataRow dr in dt.Rows)
{
sql += @" insert into ClientPayroll(AccNum, EIN, AccRep, Entity, TradeName, BusAdd1, CkRep, PayRep, BusAdd2, BusCity, BusSt, BusZip, Fax)
values('" + dr[0].ToString() + "', '" + dr[1].ToString() + "', '" + dr[2].ToString() + "', '" + dr[3].ToString().Replace("'", "''") + @"',
'" + dr[4].ToString().Replace("'", "''") + "', '" + dr[5].ToString().Replace("'", "''") + "', '" + dr[6].ToString() + "', '" + dr[7].ToString() + @"',
'" + dr[8].ToString() + "', '" + dr[9].ToString() + "', '" + dr[10].ToString() + "', '" + dr[11].ToString() + "', " +
"'" + dr[12].ToString() + "'); ";
}
if (sql != "")
{
DBOperator.ExecuteSql(sql);
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = @"select AccountNo, Contact, Customer, Company, Mailto1, Mailto2, Mailto3, Fee,
YearEnd, Phone, AltPhone,Fax, EIN, SalesTaxNum, StartDate, '2016' as 'corpNum'
from ClientDetail where AccountNo='" + comboBox1.Text + "'";
DataTable dt = DBOperator.QuerySql(sql);
reportViewer1.LocalReport.DataSources.Clear();
ReportParameter accountNo = new ReportParameter("accountNo", dt.Rows[0][0].ToString());
ReportParameter contact = new ReportParameter("contact", dt.Rows[0][1].ToString());
ReportParameter customer = new ReportParameter("customer", dt.Rows[0][2].ToString());
ReportParameter company = new ReportParameter("company", "DBA:" + dt.Rows[0][3].ToString());
ReportParameter mailto1 = new ReportParameter("mailto1", dt.Rows[0][4].ToString());
ReportParameter mailto2 = new ReportParameter("mailto2", dt.Rows[0][5].ToString());
ReportParameter mailto3 = new ReportParameter("mailto3", dt.Rows[0][6].ToString());
ReportParameter fee = new ReportParameter("fee", dt.Rows[0][7].ToString());
ReportParameter yearEnd = new ReportParameter("yearEnd", dt.Rows[0][8].ToString());
ReportParameter phone = new ReportParameter("phone", dt.Rows[0][9].ToString());
ReportParameter altphone = new ReportParameter("altphone", dt.Rows[0][10].ToString());
ReportParameter fax = new ReportParameter("fax", dt.Rows[0][11].ToString());
ReportParameter ein = new ReportParameter("ein", dt.Rows[0][12].ToString());
ReportParameter saleTaxNum = new ReportParameter("saleTaxNum", dt.Rows[0][13].ToString());
ReportParameter startDate = new ReportParameter("startDate", dt.Rows[0][14].ToString());
ReportParameter corpNum = new ReportParameter("corpNum", dt.Rows[0][15].ToString());
ReportParameter rep = new ReportParameter("rep", comboBox1.Text);
reportViewer1.LocalReport.SetParameters(
new ReportParameter[] {
accountNo, contact, customer, company, mailto1, mailto2, mailto3, fee, yearEnd, phone, altphone, fax, ein, saleTaxNum, startDate, corpNum, rep
});
this.reportViewer1.RefreshReport();
}
public string SqlToField(string strsql)
{
string str = "";
try
{
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
IDataReader rs = this.dboperator_0.exeSql(strsql);
if (rs.Read())
{
str = SQLTool.getStr(rs, 0, this.string_0);
}
rs.Close();
this.dboperator_0.Close();
}
catch (Exception exception)
{
throw new SqlRunException(strsql, exception.Message);
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
return(str);
}
public static bool GeneratedCode(string sql, EnvDTE.Project pjt, string classname)
{
bool ok = Kit.CheckDataBase();
if (ok)
{
DBOperator <Keel.DB.Common> obc = new DBOperator <Keel.DB.Common>();
DataTable dt = obc.ExecuteFillDataTable(sql);
ok = false;
if (classname == null || classname == "")
{
classname = dt.TableName;
}
if (classname != null && classname != "")
{
ViewGenerator mg = new ViewGenerator((string)pjt.Properties.Item("RootNamespace").Value, classname, sql);
for (int i = 0; i < dt.Columns.Count; i++)
{
DataColumn dc = dt.Columns[i];
mg.AddProperty(dc.ColumnName, dc.DataType, null);
}
cfLangType cl = Kit.GetProjectLangType(pjt);
string filename = mg.Save(pjt.FileName, cl);
pjt.ProjectItems.AddFromFile(filename);
ok = true;
}
}
return(ok);
}
private void LabelFolderReport_Load(object sender, EventArgs e)
{
DBOperator.SetComboxRepData(comboBox1);
string sql = "select AccountNo from ClientDetail ";
string condition = "";
if (Main.cUser.UserLevel >= Setting.ReporterLevel)
{
comboBox1.Enabled = true;
comboBox1.SelectedIndex = 0;
}
else
{
comboBox1.Enabled = false;
comboBox1.Text = Main.cUser.Rep;
condition = " where Rep='" + Main.cUser.Rep + "'";
}
sql += condition;
DataTable dt = DBOperator.QuerySql(sql);
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "AccountNo";
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
comboBox1.SelectedIndex = 0;
WindowState = FormWindowState.Maximized;
}
private void CkRepFrm_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
DBOperator.SetComboxRepData(cmbRep);
cmbRep.SelectedIndex = DateTime.Now.Month - 1;
comMonth.SelectedIndex = 0;
int year = DateTime.Now.Year;
for (int i = 0; i < 5; i++)
{
comYear.Items.Add(year--);
}
comYear.SelectedIndex = 0;
if (Main.cUser.UserLevel >= Setting.ReporterLevel)
{
cmbRep.Enabled = true;
cmbRep.SelectedIndex = 0;
}
else
{
cmbRep.Enabled = false;
cmbRep.Text = Main.cUser.FirstName + " " + Main.cUser.LastName;
cmbRep.SelectedValue = Main.cUser.Rep;
}
}
static async Task Main(string[] args)
{
Timer.Reset();
IPreprocessable preprocessor = new TFPreprocessor();
// IPreprocessable preprocessor = new HistogramPreprocessor();
// preprocessor.ProcessFolders(Directory.GetDirectories("assets"));
var single = preprocessor.PreprocessSingle("assets/007.bat/007_0001.jpg");
preprocessor.TotalList.Add(single);
preprocessor.AfterAdd();
var dbOperator = new DBOperator(VectorType.TF);
if (await dbOperator.CheckExists())
{
await dbOperator.CreateCollection();
}
// await dbOperator.InsertVectors(preprocessor.TotalList);
var res = await dbOperator.Search(preprocessor.TotalList[0], 10);
Console.WriteLine($"Test Image: {single.Name}\n\nAnswer:");
foreach (var item in res)
{
Console.WriteLine($"{item.path}\t{item.distance}");
}
Console.Write("Time used: ");
Console.WriteLine(Timer.Stop());
}
private void prepareDataSource(string[] sources, Env env)
{
if ((sources != null) && (sources.Length > 0))
{
string[] strArray = sources;
ConnectionConfig config = null;
for (int i = 0; i < strArray.Length; i++)
{
string dsName = strArray[i];
if ((dsName != null) && (dsName.Trim().Length != 0))
{
config = new ConnectionConfig(dsName);
DBOperator @operator = config.getDBOperator();
@operator.Open();
env.setConnection(dsName, @operator.Connection, config.getDbCharset(), config.getDbType(), config.getSqlEncoding(), config.getEncoding());
}
else
{
config = new ConnectionConfig();
DBOperator operator2 = config.getDBOperator();
operator2.Open();
env.setConnection(operator2.Connection);
env.setDBCharset(config.getDbCharset());
env.setDBType(config.getDbType());
env.setNeedTransSQLcode(config.getSqlEncoding());
env.setIsEncoding(config.getEncoding());
}
}
}
}
public void GetClientsByManager_Valide()
{
DBOperator.ConnectionString = ConnectionString;
DBOperator.DirectQuery("insert into MANAGERS values('Something', 'test_test')", false);
int manager_ID = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('ManagerS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery("insert into CLIENTS values('Someone',0,'test_test')", false);
int client_ID1 = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('CLIENTS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery("insert into CLIENTS values('Someone',0,'test_test')", false);
int client_ID2 = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('CLIENTS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery($"insert into CLIENTS_MANAGERS_LINK values ({manager_ID},{client_ID1}), ({manager_ID},{client_ID2})", false);
List <Client> checkListManagers = DBOperator.GetClientsByManager(manager_ID);
DBOperator.DirectQuery($"delete from CLIENTS_MANAGERS_LINK where MANAGER_ID = {manager_ID} and CLIENT_ID in ({client_ID1}, {client_ID2}); " +
$"delete from MANAGERS where ID = {manager_ID}; " +
$"delete from CLIENTS where ID in ({client_ID1}, {client_ID2}); ",
false);
Assert.AreEqual(2, checkListManagers.Count);
}
public Hashtable sqlToHashtable(string strsql)
{
Hashtable hashtable = new Hashtable();
try
{
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
Logger.debug("数据集中读出时转换SQL语句:" + strsql);
IDataReader rs = this.runProc(this.dboperator_0, strsql);
while (rs.Read())
{
hashtable.Add(SQLTool.getStr(rs, 0, this.string_0).Trim(), SQLTool.getStr(rs, 1, this.string_0));
}
rs.Close();
}
catch (Exception exception)
{
throw new SqlRunException(strsql, exception.Message);
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
return(hashtable);
}
public void GetClientsByProduct_Valide()
{
DBOperator.ConnectionString = ConnectionString;
DBOperator.DirectQuery("insert into PRODUCTS values('Something_test', 1, 0, NULL)", false);
int Product_ID = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('PRODUCTS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery("insert into CLIENTS values('Someone',0,'test_test')", false);
int client_ID1 = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('CLIENTS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery("insert into CLIENTS values('Someone',0,'test_test')", false);
int client_ID2 = Convert.ToInt32(DBOperator.DirectQueryR("SELECT IDENT_CURRENT('CLIENTS');", false)[0].Split("||".ToCharArray())[2]);
DBOperator.DirectQuery($"insert into CLIENTS_PRODUCTS_LINK values ({client_ID1},{Product_ID}), ({client_ID2},{Product_ID})", false);
List <Client> checkListProducts = DBOperator.GetClientsByProduct(Product_ID);
DBOperator.DirectQuery($"delete from CLIENTS_PRODUCTS_LINK where PRODUCT_ID = {Product_ID} and CLIENT_ID in ({client_ID1}, {client_ID2}); " +
$"delete from PRODUCTS where ID = {Product_ID}; " +
$"delete from CLIENTS where ID in ({client_ID1}, {client_ID2}); ",
false);
Assert.AreEqual(2, checkListProducts.Count);
}
public bool FileUpload(Classes classes)
{
string sql = string.Format("insert into [Classes] (Cname,Cpath) values ('{0}','{1}')", classes.Cname, classes.Cpath);
DBOperator dbo = new DBOperator();
return(dbo.ExecuteInsertOrUpdateSql(sql));
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string rep = comboBox1.SelectedValue.ToString();
string condition = "";
if (rep != "All")
{
condition = " Rep = '" + rep + "' and ";
}
string month = DateTime.Now.AddMonths(-1).ToString("MMMMM, yyyy");
string year = (DateTime.Now.Year - 1).ToString();
string sql = @"select AccountNo as 'ID', Company, Contact, Phone, AltPhone
from ClientDetail
where " + condition + @" (JobStatus in ('Current', 'Yearly','Pending')
or ((SalesTax in ('Closed(1Q/" + year + ")','Closed(2Q/" + year + ")','Closed(3Q/" + year + ")','Closed(4Q/" + year + @")')
or Payroll in ('Closed(1Q/" + year + ")','Closed(2Q/" + year + ")','Closed(3Q/" + year + ")','Closed(4Q/" + year + @")'))
and JobStatus = 'Closed' and EndDate between '1/1/" + year + "' and '12/31/" + year + @"'))
order by JobStatus, Accountno";
DataTable dt = DBOperator.QuerySql(sql);
List <QuarterlyProfitLoss> items = DBOperator.getListFromTable <QuarterlyProfitLoss>(dt);
reportViewer1.LocalReport.DataSources.Clear();
ReportParameter repTitle = new ReportParameter("repTitle", "Profit and Loss - " + rep);
ReportParameter repMonth = new ReportParameter("repMonth", "Month: " + month);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { repTitle, repMonth });
ReportDataSource rds = new ReportDataSource("QuarterlyProfitLoss", items);
reportViewer1.LocalReport.DataSources.Add(rds);
reportViewer1.RefreshReport();
}
/// <summary>
/// 初始化数据库信息
/// </summary>
/// <returns>结果</returns>
public Result InitDatabaseInfo()
{
Result result = new Result();
try
{
var conInfo = new BConString().GetConString(this.TaskInfo.BusinessKeyID);
if (string.IsNullOrWhiteSpace(conInfo?.KeyID))
{
result.Msg = "获取当前任务信息失败";
return(result);
}
IDBOperator op = new DBOperator();
////获取数据库连接
SqlSugarClient client = null;
///根据链接获取此链接下所有数据库
var dataBases = op.GetAllDataBase(conInfo.ConnectionString, ref client);
///根据数据库获取所有表
if (dataBases == null || dataBases.Count == 0)
{
result.Msg = "当前链接没有数据库";
result.Success = true;
return(result);
}
Dictionary <string, List <Table> > dBAndTables = new Dictionary <string, List <Table> >();
////这里表多了会不会超时，待处理
foreach (var item in dataBases)
{
Thread.Sleep(100);
dBAndTables.Add(item, op.GetAllTables(item, client));
}
///根据规则判断表的生成规则，并生成tables的表信息
var tables = this.BuildTableModel(dBAndTables, conInfo);
var res = new BTable().AddTableBatch(tables);
////筛选需要定期建表的
var cycleTables = tables.FindAll(p => p.SplitType != SplitType.None && p.SplitType != SplitType.HASH);
List <DBTask> tasks = new List <DBTask>();
cycleTables.ForEach(p => tasks.Add(new DBTask()
{
BusinessKeyID = p.TabelKeyID, BusinessType = BusinessType.表建表
}));
var insertRes = new BTask().AddTasks(tasks);
if (insertRes.Success)
{
this.TaskInfo.NextExecuteTime = DateTime.Now.AddDays(1);
}
return(insertRes);
}
catch (Exception e)
{
NLog.LogManager.GetCurrentClassLogger().Error($"{e}");
result.Msg = e.Message;
}
return(result);
}
public bool deletecour(string str)
{
string sql = string.Format("delete from [Classes] where Cpath=\'" + str + "\'");
DBOperator dbo = new DBOperator();
return(dbo.ExecuteInsertOrUpdateSql(sql));
}
public string loadClob()
{
this.dboperator_0 = this.connectionConfig_0.getDBOperator();
this.dboperator_0.Open();
string str = this.xmlDocument_0.DocumentElement.ChildNodes.Item(0).InnerText;
string str2 = this.xmlDocument_0.DocumentElement.ChildNodes.Item(1).InnerText;
string str3 = "";
try
{
IDbCommand command = this.dboperator_0.Connection.CreateCommand();
command.Connection = (this.dboperator_0.Connection);
command.CommandText = ("select " + str + " from FC_BILLZL where djid=" + str2);
str3 = command.ExecuteScalar().ToString();
command.Dispose();
this.dboperator_0.Close();
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
this.dboperator_0.Close();
}
catch (Exception)
{
}
}
return(str3);
}
/// <summary>
/// 功能： 返回字段最大值加1
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
public static int GetMaxID(string FieldName, string TableName)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = GetSingle(strsql);
if (obj == null)
{
return(1);
}
else
{
return(int.Parse(obj.ToString()));
}
#endregion
}
else
{
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
int exec = Convert.ToInt32(db.getTableId(TableName, FieldName)) + 1;
db.Close();
return(exec);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
}
//public bool registerSys(string uname, string upass, string urole, string uphone, string uemail, string udepartment)
//{
// //读取插入数据后的表格，所有变量首字母小写
// //string sql = string.Format("insert into [User] (Uname, Upassword, Urole, Uphone, Uemail, Udept) values ('{0}','{1}', {2}, '{3}', '{4}', '{5}')", uname, upass, urole, uphone, uemail, udepartment);
// //DBOperator dbo = new DBOperator();
// //return dbo.ExecuteInsertOrUpdateSql(sql);
//}
public bool register(User user)
{
string sql = string.Format("insert into [User] (Uname, Upassword, Urole, Uphone, Uemail, Udept) values ('{0}','{1}', {2}, '{3}', '{4}', '{5}')", user.Uname, user.Upassword, user.Urole, user.Uphone, user.Uemail, user.Udept);
DBOperator dbo = new DBOperator();
return(dbo.ExecuteInsertOrUpdateSql(sql));
}
public static string Load(HttpRequest Request, string sConn, string sFileName)
{
DBOperator oDb = null;
oDb = DBOperatorFactory.GetDBOperator(sConn);
return(Load(Request, oDb, sFileName));
}
private void ClientDetail_Load(object sender, EventArgs e)
{
string sql;
if (Main.cUser.UserLevel >= 10)
{
sql = "select * from ClientDetail";
}
else
{
sql = "select * from ClientDetail where Rep='" + Main.cUser.Rep + "' or PaycheckRep='" + Main.cUser.Rep + "' or PayrollRep='" + Main.cUser.Rep + "'";
}
DataTable dt = DBOperator.QuerySql(sql);
details = DBOperator.getListFromTable <KYLDB.Model.ClientDetail>(dt);
var accNum = from acc in details
select acc.AccountNo;
AccNumList.DataSource = accNum.ToList();
var company = from acc in details
select acc.Customer;
comboBox2.DataSource = company.ToList();
AccNumList.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
AccNumList.SelectedIndexChanged += AccNumList_SelectedIndexChanged;
comboBox2.SelectedIndexChanged += ComboBox2_SelectedIndexChanged;
enableTxt(true);
}
private string DealUploadedZTBFile(string shortFileName, string fullFileName, Dictionary <string, string> customParams)
{
string masterID = customParams["MasterID"];
string fileName = shortFileName;
string fileType = Path.GetExtension(shortFileName);
byte[] fileContent = null;
using (FileStream fs = File.Open(fullFileName, FileMode.Open))
{
using (BinaryReader reader = new BinaryReader(fs))
{
fs.Seek(0L, SeekOrigin.Begin);
fileContent = reader.ReadBytes((int)fs.Length);
}
}
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_SZZJFileManagerConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
SqlParameterCollection spc = db.CreateSqlParameterCollection();
spc.Add("@masterID", masterID);
string bh = db.ExeSqlForString("select b.bh from gc_wd a inner join gc_jbqk b on a.工程注册号=b.工程注册号 where a.bh=@masterID", spc);
string sql = "insert into Dwgcfjb(bh,附件名称,附件流,可选择) values(@bh, @fileName, @fileContent,'{建设负责人}')";
spc.Add("@bh", bh);
spc.Add("@fileName", fileName);
spc.Add("@fileContent", fileContent);
db.ExecuteNonQuerySql(sql, spc);
sql = " select max(ID) from Dwgcfjb ";
return(db.ExeSqlForObject(sql, null).ToString());
}
/// 上移
/// </summary>
/// <param name="id"></param>
/// <param name="ln">LINENO</param>
/// <param name="id1">类型/param>
public static void sortUp(string id)
{
int id2 = 0;
int ln2 = 0;
string sql = " SELECT TOP 1 menu_id,Menu_Order FROM system_menu WHERE Menu_Order<" + int.Parse(id.Split(',')[1]) + " AND Menu_Location='top' ORDER BY Menu_Order";
SqlDataReader dr = null;
try
{
dr = DBOperator.GetInstance().ReturnReader(sql) as SqlDataReader;
while (dr.Read())
{
id2 = Convert.ToInt32(dr["menu_id"]);
ln2 = Convert.ToInt32(dr["Menu_Order"]);
}
if (!id2.Equals(0) || !ln2.Equals(0))
{
string sql1 = "UPDATE system_menu SET [Menu_Order]=" + ln2 + " WHERE menu_id=" + int.Parse(id.Split(',')[0]);
string sql2 = "UPDATE system_menu SET [Menu_Order]=" + int.Parse(id.Split(',')[1]) + " WHERE menu_id=" + id2;
DBOperator.GetInstance().ExeCmd(sql1); DBOperator.GetInstance().ExeCmd(sql2);
}
}
catch (System.Exception ex)
{
throw ex;
}finally{
dr.Close();
}
}
public MaxNo(ConnectionConfig connConfig, XmlDocument xdoc)
{
this.connectionConfig_0 = null;
this.dboperator_0 = null;
this.connectionConfig_0 = connConfig;
this.xmlDocument_0 = xdoc;
}
/// <summary>
/// 带事务执行的构造函数
/// </summary>
/// <param name="dbconn">The dbconn.</param>
public EmployeeRepository(DBOperator dbConn)
{
this.IsAddIntoCache = false;
this.TableName = "Employee";
this.OrderbyFields = "KID DESC";
this.KeyField = "KID";
base.DbConn = dbConn;
}
