public static Customer CheckCustomer(string username, string passwd)
{
string sql = "select * from customer where userName=@name and pwd=@pwd ";
DBParameterCollection collection = new DBParameterCollection();
DBParameter paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = username;
paramer.Name = "@name";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = passwd;
paramer.Name = "@pwd";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
var list= responsity.QuerySql<Customer>(sql, collection).ToList();
if (list != null && list.Count > 0)
return list[0];
return null;
}
public static Customer GetCustomer(string userName)
{
string sql = "select * from customer where userName=@name ";
DBParameterCollection collection = new DBParameterCollection();
DBParameter paramer = new DBParameter();
paramer.DbType = System.Data.DbType.String;
paramer.DbValue = userName;
paramer.Name = "@name";
paramer.Size = 40;
paramer.Direction = System.Data.ParameterDirection.Input;
collection.AddDbParameter(paramer);
var rtn = responsity.QuerySql<Customer>(sql, collection);
if (rtn != null && rtn.Count() > 0)
return rtn.ToList<Customer>()[0];
return null;
}
protected override IDbDataParameter CreateParameter(DBParameter parameter, DbActionOptions options)
{
throw new NotImplementedException();
}
/// <summary>
/// 修改记录
/// </summary>
/// <param name="obj">修改的对象</param>
/// <param name="scopeList">条件列表</param>
/// <param name="setList">Set值列表</param>
/// <param name="optimisticConcurrency">是否进行并发控制</param>
/// <returns></returns>
public int Update(EntityBase obj, ScopeList scopeList, ValueSetList setList, bool optimisticConcurrency)
{
StringBuilder sql = new StringBuilder(500);
ParamList list = new ParamList();
StringBuilder where = new StringBuilder(500);
//where.Append("1=1");
Type type = EntityInfo.EntityType;
List <VersionInfo> lstVersionInfo = null;
int index = 0;
KeyWordInfomation keyinfo = BQLValueItem.GetKeyInfo().Clone() as KeyWordInfomation;
keyinfo.ParamList = list;
keyinfo.OutPutModle = false;
if (obj != null)
{
bool isProxy = true;
if (!(obj is IEntityProxy))//如果为非代理类则全实体更新
{
//throw new System.InvalidCastException("Update的实体类型必须为代理类，请用CH.Create<T>创建实体或者使用查询出来的实体来更新");
isProxy = false;
}
///读取属性别名
foreach (EntityPropertyInfo info in EntityInfo.PropertyInfo)
{
object curValue = info.GetValue(obj);
if (!info.ReadOnly)
{
if (optimisticConcurrency == true && info.IsVersion) //并发控制
{
object newValue = FillUpdateConcurrency(sql, info, list, curValue, ref index);
FillWhereConcurrency(where, info, list, curValue, ref index);
if (lstVersionInfo == null)
{
lstVersionInfo = new List <VersionInfo>();
}
lstVersionInfo.Add(new VersionInfo(info, curValue, newValue));//添加信息
}
else
{
//string paramVal = CurEntityInfo.DBInfo.CurrentDbAdapter.FormatValueName(DataAccessCommon.FormatParam(info.ParamName, index));
//string paramKey = CurEntityInfo.DBInfo.CurrentDbAdapter.FormatParamKeyName(DataAccessCommon.FormatParam(info.ParamName, index));
if (info.IsNormal)
{
//if (obj._dicUpdateProperty___ == null || obj._dicUpdateProperty___.Count == 0)
//{
// //if (DefaultType.IsDefaultValue(curValue))
// //{
// continue;
// //}
//}
if (isProxy && !obj.HasPropertyChange(info.PropertyName))
{
continue;
}
if (setList != null)//如果强制赋值集合已经有，则不使用实体值更新
{
BQLValueItem bvalue = null;
if (setList.TryGetValue(info.PropertyName, out bvalue))
{
continue;
}
}
sql.Append(",");
sql.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
sql.Append("=");
if (curValue != null)
{
DBParameter dbPrm = list.NewParameter(info.SqlType, curValue, EntityInfo.DBInfo);
sql.Append(dbPrm.ValueName);
}
else
{
sql.Append("null");
}
}
}
}
if (info.IsPrimaryKey && scopeList == null)//当不强制指定条件时候，用主键做更新条件
{
//if (DefaultType.IsDefaultValue(curValue))
//{
// continue;
//}
//if (obj._dicUpdateProperty___ != null)
//{
// if (!obj._dicUpdateProperty___.ContainsKey(info.PropertyName))
// {
// continue;
// }
//}
DBParameter dbPrm = list.NewParameter(info.SqlType, curValue, EntityInfo.DBInfo);
where.Append(" and ");
where.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
where.Append("=");
where.Append(dbPrm.ValueName);
//primaryKeyValue=curValue;
}
index++;
}
}
if (setList != null)
{
foreach (KeyValuePair <string, BQLValueItem> kvp in setList)
{
EntityPropertyInfo epinfo = EntityInfo.PropertyInfo[kvp.Key];
if (epinfo == null)
{
throw new Exception("实体:" + EntityInfo.EntityType.FullName + " 找不到属性:" + kvp.Key);
}
sql.Append(",");
sql.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(epinfo.ParamName));
sql.Append("=");
sql.Append(kvp.Value.DisplayValue(keyinfo));
}
}
where.Append(DataAccessCommon.FillCondition(EntityInfo, list, scopeList));
if (sql.Length <= 0)
{
return(0);
}
else
{
sql.Remove(0, 1);
}
UpdateCondition con = new UpdateCondition(EntityInfo.DBInfo);
con.Tables.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatTableName(EntityInfo.TableName));
con.UpdateSetValue.Append(sql);
con.Condition.Append("1=1");
con.Condition.Append(where);
int ret = -1;
Dictionary <string, bool> cacheTables = null;
cacheTables = _oper.DBInfo.QueryCache.CreateMap(EntityInfo.TableName);
ret = ExecuteCommand(con.GetSql(true), list, CommandType.Text, cacheTables);
if (obj != null && obj._dicUpdateProperty___ != null)
{
obj._dicUpdateProperty___.Clear();
}
if (lstVersionInfo != null && lstVersionInfo.Count > 0)
{
foreach (VersionInfo info in lstVersionInfo)
{
info.Info.SetValue(obj, info.NewValue);
}
}
return(ret);
}
/// <summary>
/// 插入数据到，架位信息存储历史表
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ReturnResult Insert_SXJ_R_KITT_PN_LOG_T(SXJ_R_KITT_PN_LOG_TEntity entity)
{
ReturnResult result = new ReturnResult();
string strInsert = string.Format(@"INSERT INTO SFISM4.R_KITT_PN_LOG_T
(MOGP,
MATERIAL,
VENDORCODE,
QTY,
ONRACKQTY,
RACKNO,
CREATE_TIME,
LINE_NAME,
CREATE_NAME,
DESC1,
DESC2,
DESC3,
CLOSE_TIME,
STATUS,
STATUS_INFO)
VALUES
(:MOGP,
:MATERIAL,
:VENDORCODE,
:QTY,
:ONRACKQTY,
:RACKNO,
SYSDATE,
:LINE_NAME,
:CREATE_NAME,
:DESC1,
:DESC2,
:DESC3,
SYSDATE,
:STATUS,
:STATUS_INFO)");
DBParameter dbParameter = new DBParameter();
dbParameter.Clear();
dbParameter.Add(":MOGP", OracleDbType.Varchar2, entity.MOGP);
dbParameter.Add(":MATERIAL", OracleDbType.Varchar2, entity.MATERIAL);
dbParameter.Add(":VENDORCODE", OracleDbType.Varchar2, entity.VENDORCODE);
dbParameter.Add(":QTY", OracleDbType.Int32, entity.QTY);
dbParameter.Add(":ONRACKQTY", OracleDbType.Int32, entity.ONRACKQTY);
dbParameter.Add(":RACKNO", OracleDbType.Varchar2, entity.RACKNO);
//dbParameter.Add(":CREATE_TIME", OracleType.DateTime, entity.CREATE_TIME);
dbParameter.Add(":LINE_NAME", OracleDbType.Varchar2, entity.LINE_NAME);
dbParameter.Add(":CREATE_NAME", OracleDbType.Varchar2, entity.CREATE_NAME);
dbParameter.Add(":DESC1", OracleDbType.Varchar2, entity.DESC1);
dbParameter.Add(":DESC2", OracleDbType.Varchar2, entity.DESC2);
dbParameter.Add(":DESC3", OracleDbType.Varchar2, entity.DESC3);
dbParameter.Add(":STATUS", OracleDbType.Int32, entity.STATUS);
dbParameter.Add(":STATUS_INFO", OracleDbType.Varchar2, entity.STATUS_INFO);
try
{
result = dbHander.ExecuteNonQuery(strInsert, dbParameter.GetParameters());
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
this.logHandler.Error(MethodBase.GetCurrentMethod().Name, "Call Insert_SXJ_R_KITT_PN_LOG Fail: " + ex.Message);
}
return result;
}
/// <summary>
/// 批量插入和更新
/// </summary>
/// <param name="lotEntityList"></param>
/// <param name="insertlotEntityList"></param>
/// <returns></returns>
public ReturnResult UpdateLogAndInsertTracking(List<LotMoEntity> lotEntityList, List<LotMoEntity> insertlotEntityList)
{
ReturnResult result = new ReturnResult();// { Status=false};
result = DeleteTracking(lotEntityList);
if (result.Status)
{
List<KeyValuePair<string, List<OracleParameter>>> strSqlList = new List<KeyValuePair<string, List<OracleParameter>>>();
string strUpdate = string.Format(@"UPDATE SFISM4.R_WIP_LOT_MO_LOG_T SET LOT_NUMBER=:LOT_NO,JOB_STATUS='2' WHERE MO=:MO_ORDER");
foreach (var entity in lotEntityList)
{
DBParameter dbParameter = new DBParameter();
dbParameter.Clear();
dbParameter.Add(":LOT_NO", OracleDbType.Varchar2, entity.LOT_NO);
dbParameter.Add(":MO_ORDER", OracleDbType.Varchar2, entity.MO_ORDER);
strSqlList.Add(new KeyValuePair<string, List<OracleParameter>>(strUpdate, dbParameter.GetParameters()));
}
string strInsert = string.Format(@"INSERT INTO SFISM4.R_WIP_LOT_TRACKING_T
(LOT_NUMBER,
LINE_NAME,
STATION_NAME,
IN_STATION_TIME ,
MATERIAL_STATION_NAME,
MATERIAL_IN_STATION_TIME ,
LOT_SEQ,
CREATE_TIME,
SHIFT)
VALUES
(:LOT_NUMBER,
:LINE_NAME,
:STATION_NAME,
SYSDATE,
:MATERIAL_STATION_NAME,
SYSDATE ,
:LOT_SEQ,
TO_DATE(:CREATE_TIME,'YYYY/MM/DD'),
:SHIFT)");
foreach (var insertEntity in insertlotEntityList)
{
DBParameter udbParameter = new DBParameter();
udbParameter.Clear();
udbParameter.Add(":LOT_NUMBER", OracleDbType.Varchar2, insertEntity.LOT_NO);
udbParameter.Add(":LINE_NAME", OracleDbType.Varchar2, insertEntity.LINE_NAME);
udbParameter.Add(":STATION_NAME", OracleDbType.Varchar2, "0");
udbParameter.Add(":MATERIAL_STATION_NAME", OracleDbType.Varchar2, "0");
udbParameter.Add(":LOT_SEQ", OracleDbType.Varchar2, insertEntity.LOT_SEQ);
udbParameter.Add(":CREATE_TIME", OracleDbType.Varchar2, insertEntity.CREATE_TIME);
udbParameter.Add(":SHIFT", OracleDbType.Varchar2, insertEntity.SHIFT);
strSqlList.Add(new KeyValuePair<string, List<OracleParameter>>(strInsert, udbParameter.GetParameters()));
}
try
{
result = dbHander.ExecuteNonQueryBatchSql(strSqlList);
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
this.logHandler.Error(MethodBase.GetCurrentMethod().Name, "Call UpdateLogAndInsertTracking Fail: " + ex.Message);
}
}
return result;
}
public DALDOSSIER(DBParameter dbParam) : base(dbParam) { }
protected void AddParameter(DBParameter parameter)
{
Parameters.Add(parameter);
}
public bool Contains(DBParameter item)
{
return _innerList.Contains(item);
}
public int Add(string parametername, object value, ParameterDirection parameterdirection, SqlDbType datatype)
{
DBParameter item = new DBParameter(parametername, value, parameterdirection, datatype);
return _innerList.Add(item);
}
public void Add(DBParameter item)
{
_innerList.Add(item);
}
public List <ClsUserDetails> SignIn(ClsUserSignIn ObjUser)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@UserCode", ObjUser.User_Code, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@password", ObjUser.Password, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@IsSocialLogin", ObjUser.IsSocialLogin, DbType.Boolean);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
DataSet ds = objDbHelper.ExecuteDataSet(Constant.SignIn, ObJParameterCOl, CommandType.StoredProcedure);
List <ClsUserDetails> objUserDetails = new List <ClsUserDetails>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
objUserDetails = ds.Tables[0].AsEnumerable().Select(Row =>
new ClsUserDetails
{
Ref_User_ID = Row.Field <Int64>("Ref_User_ID"),
UserCode = Row.Field <string>("UserCode"),
FullName = Row.Field <string>("FullName"),
EmailID = Row.Field <string>("EmailID"),
MobileNumber = Row.Field <string>("MobileNumber"),
Bio = Row.Field <string>("Bio"),
Gender = Row.Field <string>("Gender"),
StudioGears = Row.Field <string>("StudioGears"),
PayPalEmailID = Row.Field <string>("PayPalEmailID"),
SocialProfileUrl = Row.Field <string>("SocialProfileUrl"),
Response = Row.Field <string>("Response"),
FileManager = ds.Tables[1].AsEnumerable().Select(Row2 =>
new ClsFileManager
{
FileManagerID = Row2.Field <Int64>("Ref_FileManager_ID"),
FileIdentifier = Row2.Field <string>("FileIdentifier"),
FileName = Row2.Field <string>("FileName"),
FilePath = Row2.Field <string>("FilePath"),
FileExtension = Row2.Field <string>("FileExtension"),
FileSize = Row2.Field <Int64>("FileSize"),
FileType = Row2.Field <string>("FileType"),
Sequence = Row2.Field <int>("Sequence"),
}).ToList(),
UserMaster = ds.Tables[2].AsEnumerable().Select(Row2 =>
new ClsUserMasterMapping
{
MasterName = Row2.Field <string>("MasterName"),
MasterDataName = Row2.Field <string>("MasterDataName"),
}).ToList(),
}).ToList();
}
}
return(objUserDetails);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddModifyUserTicket(ClsTicketDetails ObjTicket)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_User_ID", ObjTicket.Ref_User_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Ref_Ticket_ID", ObjTicket.Ref_Ticket_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Ref_TicketType_ID", ObjTicket.Ref_TicketType_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Subject", ObjTicket.Subject, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Description", ObjTicket.Description, DbType.String);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
Int64 Ref_Ticket_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyUserTicket, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_Ticket_ID > 0)
{
ObjTicket.FileManager.ForEach(File =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleID", Ref_Ticket_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure).ToString();
});
}
if (Ref_Ticket_ID > 0 && ObjTicket.Ref_Ticket_ID == 0)
{
return("USERTICKETSUCCESS");
}
else if (Ref_Ticket_ID > 0 && ObjTicket.Ref_Ticket_ID > 0)
{
return("USERTICKETUPDATED");
}
else
{
return("TICKETALREADYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
public string SignUp(ClsUserDetails ObjUser)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_User_ID", ObjUser.Ref_User_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@UserCode", ObjUser.UserCode, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@FullName", ObjUser.FullName, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@EmailID", ObjUser.EmailID, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Password", ObjUser.Password, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@MobileNumber", ObjUser.MobileNumber, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Bio", ObjUser.Bio, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Gender", ObjUser.Gender, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@StudioGears", ObjUser.StudioGears, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@SocialProfileUrl", ObjUser.SocialProfileUrl, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@PayPalEmailID", ObjUser.PayPalEmailID, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityIDs", ObjUser.AuthorityIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@UserMasterDataIDs", ObjUser.UserMasterDataIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CreatedBy", ObjUser.CreatedBy, DbType.String);
ObJParameterCOl.Add(objDBParameter);
DBHelper objDbHelper = new DBHelper();
Int64 Ref_User_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.SignUp, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_User_ID > 0)
{
ObjUser.FileManager.ForEach(File =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleID", Ref_User_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure).ToString();
});
}
if (Ref_User_ID > 0 && ObjUser.Ref_User_ID == 0)
{
return("USERADDEDSUCCESS");
}
else if (Ref_User_ID > 0 && ObjUser.Ref_User_ID > 0)
{
return("USERUPDATEDSUCCESS");
}
else
{
return("USERALREADYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
static int Main(string[] args)
{
string exchangeRate = string.Empty;
string dateUpdated = string.Empty;
//Prepare parameters
try
{
foreach (string arg in args)
{
int commandIndex = arg.IndexOf(":");
string command = arg.Substring(0, commandIndex).ToUpper();
switch (command)
{
case "EXCHANGERATE":
exchangeRate = arg.Substring(commandIndex + 1, arg.Length - commandIndex - 1);
break;
case "DATEUPDATED":
dateUpdated = arg.Substring(commandIndex + 1, arg.Length - commandIndex - 1);
break;
default:
// do other stuff...
break;
}
}
}
catch (Exception ex)
{
_logger.Debug(ex);
_logger.ErrorException("[" + DateTime.Now.ToString() + "]", ex);
}
//Start Updating
try
{
_logger.Info("Exchange Rate Started");
var connectionManagerDataSection = ConfigurationManager.GetSection(ConnectionManagerDataSection.SectionName) as ConnectionManagerDataSection;
if (connectionManagerDataSection != null)
{
foreach (ConnectionManagerEndpointElement endpointElement in connectionManagerDataSection.ConnectionManagerEndpoints)
{
if (endpointElement.ExecuteQuery)
{
DBHelper _dbHelper = new DBHelper(endpointElement.Name);
DateTime oDate = Convert.ToDateTime(dateUpdated);
DBParameter param1 = new DBParameter(endpointElement.RateParam, exchangeRate);
DBParameter param2 = new DBParameter(endpointElement.DateParam, oDate.ToString(endpointElement.DateFormat));
DBParameterCollection paramCollection = new DBParameterCollection();
IDbTransaction transaction = _dbHelper.BeginTransaction();
paramCollection.Add(param1);
paramCollection.Add(param2);
string message = "";
string updateCommand = endpointElement.Query;
try
{
message = _dbHelper.ExecuteNonQuery(updateCommand, paramCollection, transaction) > 0 ? "Exchange Rate updated successfully." : "Error in updating record.";
_dbHelper.CommitTransaction(transaction);
_logger.Info(endpointElement.Name + "Database Updated Successfully.");
}
catch (Exception err)
{
_dbHelper.RollbackTransaction(transaction);
}
}
}
}
_logger.Info("Exchange Rate Ended");
return(1);
}
catch (Exception ex)
{
_logger.Info("Exchange Rate Stoped");
_logger.ErrorException("Exception: ", ex);
return(0);
}
}
public DataSet GetSentResultForOutPut(ArrayList lstUnit, ArrayList lstItems, out Hashtable hsTbIdx, string username)
{
DataSet set4;
DBParameter dbParameter = DBUtil.GetDbParameter(false);
try
{
DEBusinessItem current;
dbParameter.Open();
DaArchivManager manager = new DaArchivManager(dbParameter);
DataSet set = new DataSet();
hsTbIdx = new Hashtable();
Hashtable hashtable = new Hashtable();
Hashtable hashtable2 = new Hashtable();
ArrayList lstTH = new ArrayList();
DataTable newTable = null;
DataTable table2 = null;
IEnumerator enumerator = lstItems.GetEnumerator();
{
while (enumerator.MoveNext())
{
current = (DEBusinessItem)enumerator.Current;
DataSet sentResultForOutPut = manager.GetSentResultForOutPut(current.IterOid);
if (newTable == null)
{
newTable = this.GetNewTable("FF", sentResultForOutPut);
}
if (table2 == null)
{
table2 = this.GetNewTable("HS", sentResultForOutPut);
}
string tH = this.GetTH(current);
hashtable[tH] = current;
hashtable2[tH] = sentResultForOutPut;
lstTH.Add(tH);
}
}
lstTH.Sort();
int num = 0;
Hashtable MapUnitLstTH = new Hashtable();
Hashtable hashtable4 = new Hashtable();
foreach (string unit in lstUnit)
{
DataSet datasetList;
ArrayList lstUsedTH2;
DataTable table4;
num++;
hsTbIdx[unit] = num;
foreach (string tuhao in lstTH)
{
datasetList = hashtable2[tuhao] as DataSet;
/*
* if (datasetList.Tables.Contains("FF") && this.IsAllDocContainsUnit(datasetList.Tables["FF"], unit))
* {
* ArrayList lstUsedTH;
* if (MapUnitLstTH.Contains(unit))
* {
* lstUsedTH = MapUnitLstTH[unit] as ArrayList;
* }
* else
* {
* lstUsedTH = new ArrayList();
* }
* lstUsedTH.Add(tuhao);
* MapUnitLstTH[unit] = lstUsedTH;
* }
* if (datasetList.Tables.Contains("HS") && this.IsAllDocContainsUnit(datasetList.Tables["HS"], unit))
* {
* ArrayList list3;
* if (hashtable4.Contains(unit))
* {
* list3 = hashtable4[unit] as ArrayList;
* }
* else
* {
* list3 = new ArrayList();
* }
* list3.Add(tuhao);
* hashtable4[unit] = list3;
* }
* */
}
ArrayList lstTH2 = new ArrayList(lstTH);
if (newTable != null)
{
DataTable tbObj = newTable.Clone();
tbObj.TableName = "FF" + num.ToString();
if (MapUnitLstTH.Contains(unit))
{
lstUsedTH2 = MapUnitLstTH[unit] as ArrayList;
foreach (string usedTH in lstUsedTH2)
{
lstTH2.Remove(usedTH);
datasetList = hashtable2[usedTH] as DataSet;
table4 = datasetList.Tables["FF"];
current = hashtable[usedTH] as DEBusinessItem;
this.GetNewRowByUnit(current, table4, true, tbObj, unit, username);
}
}
foreach (string str3 in lstTH2)
{
datasetList = hashtable2[str3] as DataSet;
table4 = datasetList.Tables["FF"];
current = hashtable[str3] as DEBusinessItem;
this.GetNewRowByUnit(current, table4, false, tbObj, unit, username);
}
if (tbObj.Rows.Count > 0)
{
DataView dv = tbObj.DefaultView;
dv.Sort = "图号";
DataTable sortedtbObj = dv.ToTable();
set.Tables.Add(sortedtbObj);
}
}
if (table2 != null)
{
DataTable table5 = table2.Clone();
table5.TableName = "HS" + num.ToString();
lstTH2 = new ArrayList(lstTH);
if (hashtable4.Contains(unit))
{
lstUsedTH2 = hashtable4[unit] as ArrayList;
foreach (string str3 in lstUsedTH2)
{
lstTH2.Remove(str3);
datasetList = hashtable2[str3] as DataSet;
table4 = datasetList.Tables["HS"];
current = hashtable[str3] as DEBusinessItem;
this.GetNewRowByUnit(current, table4, true, table5, unit, username);
}
}
foreach (string str3 in lstTH2)
{
datasetList = hashtable2[str3] as DataSet;
table4 = datasetList.Tables["HS"];
current = hashtable[str3] as DEBusinessItem;
this.GetNewRowByUnit(current, table4, false, table5, unit, username);
}
if (table5.Rows.Count > 0)
{
DataView dv = table5.DefaultView;
dv.Sort = "图号";
DataTable sortedtbObj = dv.ToTable();
set.Tables.Add(sortedtbObj);
}
}
}
set.AcceptChanges();
set4 = set;
}
catch (Exception exception)
{
throw new PLMException("获取用于收发登记的收发帐明细失败", exception);
}
finally
{
dbParameter.Close();
}
return(set4);
}
public void copyTo(DBParameter[] array, int index)
{
_innerList.CopyTo(array, index);
}
public string AddModifyAuthority(ClsAuthority ObjAuthority)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_Authority_ID", ObjAuthority.Ref_Authority_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityName", ObjAuthority.AuthorityName, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AuthorityType", ObjAuthority.AuthorityType, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Description", ObjAuthority.Description, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@MasterDataIDs", ObjAuthority.MasterDataIDs, DbType.String);
ObJParameterCOl.Add(objDBParameter);
Int64 Ref_Authority_ID = 0;
DBHelper objDbHelper = new DBHelper();
Ref_Authority_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyAuthority, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_Authority_ID > 0)
{
ObjAuthority.ModuleAccess.ForEach(Module =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@Ref_Authority_ID", Ref_Authority_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Ref_Module_ID", Module.Ref_Module_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@View", Module.View, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Edit", Module.Edit, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Delete", Module.Delete, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Approval", Module.Approval, DbType.Boolean);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@CreatedBy", ObjAuthority.CreatedBy, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar(Constant.AddModifyAuthorityModuleAccess, ObJParameterCOl1, CommandType.StoredProcedure);
});
}
if (Ref_Authority_ID > 0 && ObjAuthority.Ref_Authority_ID == 0)
{
return("AUTHORITYADDED");
}
else if (Ref_Authority_ID > 0 && ObjAuthority.Ref_Authority_ID == 0)
{
return("AUTHORITYUPDATED");
}
else
{
return("AUTHORITYEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
public int IndexOf(DBParameter item)
{
return _innerList.IndexOf(item);
}
public bool Remove(DBParameter item)
{
bool result = false;
DBParameter obj;
for (int i = 0; i < _innerList.Count; i++)
{
obj = new DBParameter();
obj = (DBParameter)_innerList[i];
if (obj.ParameterName == item.ParameterName && obj.DataType == item.DataType)
{
_innerList.RemoveAt(i);
result = true;
break;
}
obj = null;
}
return result;
}
private void AddDBParam(SqlCommand cmd, DBParameter dbParam)
{
if (dbParam.ParamValue == null)
{
AddDBParamNoValue(cmd, dbParam);
return;
}
try
{
DBParameterType paramType = dbParam.ParamType;
switch (paramType)
{
case DBParameterType.BoolParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (bool)dbParam.ParamValue); break;
case DBParameterType.DateTimeParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (DateTime)dbParam.ParamValue); break;
case DBParameterType.DoubleParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (double)dbParam.ParamValue); break;
case DBParameterType.IntParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (int)dbParam.ParamValue); break;
case DBParameterType.NullableIntParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (int?)dbParam.ParamValue); break;
case DBParameterType.StringParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue); break;
case DBParameterType.TextParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, true); break;
case DBParameterType.XmlParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (string)dbParam.ParamValue, false, true); break;
case DBParameterType.BytesParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (byte[])dbParam.ParamValue); break;
case DBParameterType.NcharParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, dbParam.ParamValue == null ? new char[0] : ((string)dbParam.ParamValue).ToCharArray()); break;
case DBParameterType.IntParamOutput:
SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType);
ParameterNames.Add(dbParam.ParamName);
break;
case DBParameterType.StringParamOutput:
SqlUtil.AddOutputParam(cmd, dbParam.ParamName, paramType);
ParameterNames.Add(dbParam.ParamName);
break;
case DBParameterType.ByteParam:
SqlUtil.AddParam(cmd, dbParam.ParamName, (byte)dbParam.ParamValue); break;
}
}
#pragma warning disable 168
catch (System.InvalidCastException whoops)
{
// bad data, treat as null...
AddDBParamNoValue(cmd, dbParam);
}
#pragma warning restore 168
}
public DARouteProcess(DBParameter dbParam)
: base(dbParam)
{
}
/// <summary>
/// 进行插入操作
/// </summary>
/// <param name="obj">要插入的对象</param>
/// <param name="fillIdentity">是否要填充刚插入的实体的ID</param>
/// <returns></returns>
protected internal int DoInsert(EntityBase obj, ValueSetList setList, bool fillIdentity)
{
StringBuilder sqlParams = new StringBuilder(1000);
StringBuilder sqlValues = new StringBuilder(1000);
ParamList list = new ParamList();
string param = null;
string svalue = null;
List <EntityPropertyInfo> identityInfo = new List <EntityPropertyInfo>();
KeyWordInfomation keyinfo = BQLValueItem.GetKeyInfo().Clone() as KeyWordInfomation;
keyinfo.ParamList = list;
foreach (EntityPropertyInfo info in EntityInfo.PropertyInfo)
{
//EntityPropertyInfo info = enums.Current.Value;
object curValue = info.GetValue(obj);
if (info.Identity)
{
if (info.SqlType == DbType.Guid && info.FieldType == DefaultType.GUIDType)
{
curValue = Guid.NewGuid();
info.SetValue(obj, curValue);
DBParameter prm = list.NewParameter(info.SqlType, curValue, EntityInfo.DBInfo);
sqlParams.Append(",");
sqlParams.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
sqlValues.Append(",");
sqlValues.Append(prm.ValueName);
continue;
}
else
{
if (fillIdentity)
{
identityInfo.Add(info);
}
param = EntityInfo.DBInfo.CurrentDbAdapter.GetIdentityParamName(info);
if (!string.IsNullOrEmpty(param))
{
sqlParams.Append(",");
sqlParams.Append(param);
}
svalue = EntityInfo.DBInfo.CurrentDbAdapter.GetIdentityParamValue(EntityInfo, info);
if (!string.IsNullOrEmpty(svalue))
{
sqlValues.Append(",");
sqlValues.Append(svalue);
}
continue;
}
}
else if (info.IsVersion) //版本初始值
{
object conValue = curValue;
if (conValue == null)
{
conValue = GetDefaultConcurrency(info);
}
if (conValue != null)
{
DBParameter prm = list.NewParameter(info.SqlType, conValue, EntityInfo.DBInfo);
sqlParams.Append(",");
sqlParams.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
sqlValues.Append(",");
sqlValues.Append(prm.ValueName);
continue;
}
}
else
{
BQLValueItem bvalue = null;
if (setList != null && setList.TryGetValue(info.PropertyName, out bvalue))
{
sqlParams.Append(",");
sqlParams.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
sqlValues.Append(",");
sqlValues.Append(bvalue.DisplayValue(keyinfo));
continue;
}
else if (curValue == null)
{
continue;
}
else
{
DBParameter prmValue = list.NewParameter(info.SqlType, curValue, EntityInfo.DBInfo);
sqlParams.Append(",");
sqlParams.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatParam(info.ParamName));
sqlValues.Append(",");
sqlValues.Append(prmValue.ValueName);
}
}
}
if (sqlParams.Length > 0)
{
sqlParams.Remove(0, 1);
}
else
{
return(0);
}
if (sqlValues.Length > 0)
{
sqlValues.Remove(0, 1);
}
else
{
return(0);
}
InsertCondition con = new InsertCondition(EntityInfo.DBInfo);
con.Tables.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatTableName(EntityInfo.TableName));
con.SqlParams.Append(sqlParams.ToString());
con.SqlValues.Append(sqlValues.ToString());
int ret = -1;
con.DbParamList = list;
using (BatchAction ba = _oper.StarBatchAction())
{
string sql = con.GetSql(true);
Dictionary <string, bool> cacheTables = null;
cacheTables = _oper.DBInfo.QueryCache.CreateMap(EntityInfo.TableName);
ret = ExecuteCommand(sql, list, CommandType.Text, cacheTables);
if (identityInfo.Count > 0 && fillIdentity)
{
foreach (EntityPropertyInfo pkInfo in identityInfo)
{
sql = EntityInfo.DBInfo.CurrentDbAdapter.GetIdentitySQL(pkInfo);
using (IDataReader reader = _oper.Query(sql, new ParamList(), null))
{
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
EntityInfo.DBInfo.CurrentDbAdapter.SetObjectValueFromReader(reader, 0, obj, pkInfo, !pkInfo.TypeEqual(reader, 0));
//obj.PrimaryKeyChange();
ret = 1;
}
}
}
}
}
}
return(ret);
}
public Program(DBParameter dparam):base(dparam)
{
// TODO: Complete member initialization
}
public DaArchivManager(DBParameter dbparam)
{
this.dbparam = dbparam;
}
public DALXJHGLS(DBParameter dbParam) : base(dbParam) { }
public WGT2DOSSIOR(Guid user, DBParameter dbParam, bool Elec = false)
{
if (Elec) ElecVersion = "-电子版";
userOid = user;
var userss = new BRUser(userOid).GetUserByOid(userOid);
usernmame = userss.Name;
DWGMaster = new DALDOSSIER(dbParam);
ReadUser();
}
