/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_Client model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_Client SET "); strSql.Append("sClientName=@in_sClientName,"); strSql.Append("sAddress=@in_sAddress,"); strSql.Append("sMobiPhone=@in_sMobiPhone,"); strSql.Append("sTelPhone=@in_sTelPhone,"); strSql.Append("CreateUserID=@in_CreateUserID,"); strSql.Append("IsEnable=@in_IsEnable,"); strSql.Append("LastUpdate=@in_LastUpdate,"); strSql.Append("Memo=@in_Memo"); strSql.Append(" WHERE KeyID=@in_KeyID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sClientName", DbType.String, model.sClientName), dbHelper.CreateInDbParameter("@in_sAddress", DbType.String, model.sAddress), dbHelper.CreateInDbParameter("@in_sMobiPhone", DbType.String, model.sMobiPhone), dbHelper.CreateInDbParameter("@in_sTelPhone", DbType.String, model.sTelPhone), dbHelper.CreateInDbParameter("@in_CreateUserID", DbType.String, model.CreateUserID), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo), dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.String, model.LastUpdate)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_IVRControl model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_IVRControl SET "); strSql.Append("sFileName=@in_sFileName,"); strSql.Append("iKeyNum=@in_iKeyNum,"); strSql.Append("SubID=@in_SubID,"); strSql.Append("sIVRName=@in_sIVRName,"); strSql.Append("IsEnable=@in_IsEnable,"); strSql.Append("BeginDate=@in_BeginDate,"); strSql.Append("EndDate=@in_EndDate,"); strSql.Append("LastUpdate=@in_LastUpdate"); strSql.Append(" WHERE KeyID=@in_KeyID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sFileName", DbType.String, model.sFileName), dbHelper.CreateInDbParameter("@in_iKeyNum", DbType.Int32, model.iKeyNum), dbHelper.CreateInDbParameter("@in_SubID", DbType.String, model.SubID), dbHelper.CreateInDbParameter("@in_sIVRName", DbType.String, model.sIVRName), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_BeginDate", DbType.DateTime, model.BeginDate), dbHelper.CreateInDbParameter("@in_EndDate", DbType.DateTime, model.EndDate), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate), dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID)}; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZSystem.Model.t_ChannelStateStatic model) { StringBuilder strSql; DbParameter[] cmdParms; PrepareAddCommand(model, out strSql, out cmdParms); return dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(ZSystem.Model.t_Log model) { StringBuilder sbSql4t_Log; DbParameter[] parms4t_Log; PrepareUpdateCommand(model, out sbSql4t_Log, out parms4t_Log); return dbHelper.ExecuteNonQuery(CommandType.Text, sbSql4t_Log.ToString(), parms4t_Log); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(ZSystem.Model.t_Operation model) { StringBuilder strSql; DbParameter[] cmdParms; PrepareUpdateCommand(model, out strSql, out cmdParms); return dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZSystem.Model.t_SysUserState model) { StringBuilder sbSql4t_SysUserState; DbParameter[] parms4t_SysUserState; PrepareAddCommand(model, out sbSql4t_SysUserState, out parms4t_SysUserState); return dbHelper.ExecuteNonQuery(CommandType.Text, sbSql4t_SysUserState.ToString(), parms4t_SysUserState); }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_Product model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_Product SET "); strSql.Append("sProductName=@in_sProductName,"); strSql.Append("iPrice=@in_iPrice,"); strSql.Append("Memo=@in_Memo,"); strSql.Append("iDiscount=@in_iDiscount,"); strSql.Append("IsEnable=@in_IsEnable,"); strSql.Append("Begindate=@in_Begindate,"); strSql.Append("Enddate=@in_Enddate,"); strSql.Append("LastUpdate=@in_LastUpdate"); strSql.Append(" WHERE KeyID=@in_KeyID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sProductName", DbType.String, model.sProductName), dbHelper.CreateInDbParameter("@in_iPrice", DbType.Double, model.iPrice), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo), dbHelper.CreateInDbParameter("@in_iDiscount", DbType.Int32, model.iDiscount), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_Begindate", DbType.DateTime, model.Begindate), dbHelper.CreateInDbParameter("@in_Enddate", DbType.DateTime, model.Enddate), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate), dbHelper.CreateInDbParameter("@in_KeyID", DbType.Guid, model.KeyID)}; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ZSystem.Model.t_SystemUser model) { int count = dal.Update(model); if (EnableCache && count > 0) { RemoveModelCache(model.KeyID); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ZSystem.Model.t_ChannelState model) { int count = dal.Update(model); if (EnableCache && count > 0) { RemoveModelCache(model.iChID); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ZSystem.Model.t_r_OperationProduct model) { int count = dal.Update(model); if (EnableCache && count > 0) { RemoveModelCache(model.KeyID); } }
protected void OnEnable() { zSystem = GetComponent <ZSystem>(); ViewDirection = 6; setState(0); AnimSpeed = 1; isDead = false; StartCoroutine(FSMmain()); }
public static bool Zcheck(ZSystem one, ZSystem two) { if (one != null && two != null) { if (one.Z == two.Z) { return(true); } } return(false); }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Authorization model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_Authorization("); strSql.Append("UserID, iUserLevel)"); strSql.Append(" VALUES ("); strSql.Append("@in_UserID, @in_iUserLevel)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_UserID", DbType.String, model.UserID), dbHelper.CreateInDbParameter("@in_iUserLevel", DbType.Int32, model.iUserLevel)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_OperationState model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_OperationState("); strSql.Append("KeyID, sStatusName, iIndex)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sStatusName, @in_iIndex)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.Int32, model.KeyID), dbHelper.CreateInDbParameter("@in_sStatusName", DbType.String, model.sStatusName), dbHelper.CreateInDbParameter("@in_iIndex", DbType.Int32, model.iIndex)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_ChannelStateStatic model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_ChannelStateStatic SET "); strSql.Append("iChtype=@in_iChtype,"); strSql.Append("iChNum=@in_iChNum"); strSql.Append(" WHERE iChID=@in_iChID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_iChtype", DbType.Int32, model.iChtype), dbHelper.CreateInDbParameter("@in_iChNum", DbType.Int32, model.iChNum), dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_OperationState model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_OperationState SET "); strSql.Append("sStatusName=@in_sStatusName,"); strSql.Append("iIndex=@in_iIndex"); strSql.Append(" WHERE KeyID=@in_KeyID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sStatusName", DbType.String, model.sStatusName), dbHelper.CreateInDbParameter("@in_iIndex", DbType.Int32, model.iIndex), dbHelper.CreateInDbParameter("@in_KeyID", DbType.Int32, model.KeyID)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_GlobalPara model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_GlobalPara SET "); strSql.Append("sValue=@in_sValue,"); strSql.Append("Memo=@in_Memo"); strSql.Append(" WHERE KeyID=@in_KeyID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sValue", DbType.String, model.sValue), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo), dbHelper.CreateInDbParameter("@in_KeyID", DbType.Int32, model.KeyID)}; }
public void SetGlobalPara(ZSystem.Model.t_GlobalPara mGlobal,string UserID) { if (mGlobal==null||string.IsNullOrEmpty(UserID) ) { throw new ArgumentException("参数无效!"); } if (!Func.tGlobalPara.IsValidUser(UserID)) throw new UnauthorizedAccessException("用户权限不足"); Func.tGlobalPara.Update(mGlobal); }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_ChannelStateStatic model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_ChannelStateStatic("); strSql.Append("iChID, iChtype, iChNum)"); strSql.Append(" VALUES ("); strSql.Append("@in_iChID, @in_iChtype, @in_iChNum)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID), dbHelper.CreateInDbParameter("@in_iChtype", DbType.Int32, model.iChtype), dbHelper.CreateInDbParameter("@in_iChNum", DbType.Int32, model.iChNum)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_GlobalPara model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_GlobalPara("); strSql.Append("KeyID, sValue, Memo)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sValue, @in_Memo)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.Int32, model.KeyID), dbHelper.CreateInDbParameter("@in_sValue", DbType.String, model.sValue), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_SysUserState model, out StringBuilder sbSql4t_SysUserState, out DbParameter[] parms4t_SysUserState) { sbSql4t_SysUserState = new StringBuilder(); sbSql4t_SysUserState.Append("INSERT INTO t_SysUserState("); sbSql4t_SysUserState.Append("KeyID, UserID, iState, LastDate)"); sbSql4t_SysUserState.Append(" VALUES ("); sbSql4t_SysUserState.Append("@in_KeyID, @in_UserID, @in_iState, @in_LastDate)"); parms4t_SysUserState = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_UserID", DbType.String, model.UserID), dbHelper.CreateInDbParameter("@in_iState", DbType.Int32, model.iState), dbHelper.CreateInDbParameter("@in_LastDate", DbType.DateTime, model.LastDate)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Log model, out StringBuilder sbSql4t_Log, out DbParameter[] parms4t_Log) { sbSql4t_Log = new StringBuilder(); sbSql4t_Log.Append("INSERT INTO t_Log("); sbSql4t_Log.Append("ID, sContent, sType, LogTime)"); sbSql4t_Log.Append(" VALUES ("); sbSql4t_Log.Append("@in_ID, @in_sContent, @in_sType, @in_LogTime)"); parms4t_Log = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_ID", DbType.String, model.ID), dbHelper.CreateInDbParameter("@in_sContent", DbType.String, model.sContent), dbHelper.CreateInDbParameter("@in_sType", DbType.String, model.sType), dbHelper.CreateInDbParameter("@in_LogTime", DbType.DateTime, model.LogTime)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_Log model, out StringBuilder sbSql4t_Log, out DbParameter[] parms4t_Log) { sbSql4t_Log = new StringBuilder(); sbSql4t_Log.Append("UPDATE t_Log SET "); sbSql4t_Log.Append("sContent=@in_sContent,"); sbSql4t_Log.Append("sType=@in_sType,"); sbSql4t_Log.Append("LogTime=@in_LogTime"); sbSql4t_Log.Append(" WHERE ID=@in_ID"); parms4t_Log = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sContent", DbType.String, model.sContent), dbHelper.CreateInDbParameter("@in_sType", DbType.String, model.sType), dbHelper.CreateInDbParameter("@in_LogTime", DbType.DateTime, model.LogTime), dbHelper.CreateInDbParameter("@in_ID", DbType.String, model.ID)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_SysUserState model, out StringBuilder sbSql4t_SysUserState, out DbParameter[] parms4t_SysUserState) { sbSql4t_SysUserState = new StringBuilder(); sbSql4t_SysUserState.Append("UPDATE t_SysUserState SET "); sbSql4t_SysUserState.Append("UserID=@in_UserID,"); sbSql4t_SysUserState.Append("iState=@in_iState,"); sbSql4t_SysUserState.Append("LastDate=@in_LastDate"); sbSql4t_SysUserState.Append(" WHERE KeyID=@in_KeyID"); parms4t_SysUserState = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_UserID", DbType.String, model.UserID), dbHelper.CreateInDbParameter("@in_iState", DbType.Int32, model.iState), dbHelper.CreateInDbParameter("@in_LastDate", DbType.DateTime, model.LastDate), dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_r_OperationProduct model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_r_OperationProduct("); strSql.Append("KeyID, OperationID, ProductID, iPrice, iDiscount, iCurrentPrice)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_OperationID, @in_ProductID, @in_iPrice, @in_iDiscount, @in_iCurrentPrice)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_OperationID", DbType.String, model.OperationID), dbHelper.CreateInDbParameter("@in_ProductID", DbType.String, model.ProductID), dbHelper.CreateInDbParameter("@in_iPrice", DbType.Double, model.iPrice), dbHelper.CreateInDbParameter("@in_iDiscount", DbType.Int32, model.iDiscount), dbHelper.CreateInDbParameter("@in_iCurrentPrice", DbType.Double, model.iCurrentPrice)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_SystemUser model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_SystemUser("); strSql.Append("KeyID, sUserName, sLoginName, sPassword, LastUpdate,IsEnable)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sUserName, @in_sLoginName, @in_sPassword, @in_LastUpdate,@in_IsEnable)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_sUserName", DbType.String, model.sUserName), dbHelper.CreateInDbParameter("@in_sLoginName", DbType.String, model.sLoginName), dbHelper.CreateInDbParameter("@in_sPassword", DbType.String, model.sPassword), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_ChannelState model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_ChannelState("); strSql.Append("iChID, sChState, iChType, sCaller, sDTMF, iTimeElapse)"); strSql.Append(" VALUES ("); strSql.Append("@in_iChID, @in_sChState, @in_iChType, @in_sCaller, @in_sDTMF, @in_iTimeElapse)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID), dbHelper.CreateInDbParameter("@in_sChState", DbType.String, model.sChState), dbHelper.CreateInDbParameter("@in_iChType", DbType.Int32, model.iChType), dbHelper.CreateInDbParameter("@in_sCaller", DbType.String, model.sCaller), dbHelper.CreateInDbParameter("@in_sDTMF", DbType.String, model.sDTMF), dbHelper.CreateInDbParameter("@in_iTimeElapse", DbType.Int32, model.iTimeElapse)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_ReceiveList model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_ReceiveList("); strSql.Append("KeyID, sCallerID, ClientID, SysUserID, iTimeElapse, ReceiveDate, Memo)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sCallerID, @in_ClientID, @in_SysUserID, @in_iTimeElapse, @in_ReceiveDate, @in_Memo)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_sCallerID", DbType.String, model.sCallerID), dbHelper.CreateInDbParameter("@in_ClientID", DbType.String, model.ClientID), dbHelper.CreateInDbParameter("@in_SysUserID", DbType.String, model.SysUserID), dbHelper.CreateInDbParameter("@in_iTimeElapse", DbType.Int32, model.iTimeElapse), dbHelper.CreateInDbParameter("@in_ReceiveDate", DbType.DateTime, model.ReceiveDate), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Operation model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_Operation("); strSql.Append("KeyID, ClientID, iStatus, iTotalPrice, CreateUser, Memo,IsEnable,LastUpdate)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_ClientID, @in_iStatus, @in_iTotalPrice, @in_CreateUser, @in_Memo,@in_IsEnable,@in_LastUpdate)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_ClientID", DbType.String, model.ClientID), dbHelper.CreateInDbParameter("@in_iStatus", DbType.Int32, model.iStatus), dbHelper.CreateInDbParameter("@in_iTotalPrice", DbType.Double, model.iTotalPrice), dbHelper.CreateInDbParameter("@in_CreateUser", DbType.String, model.CreateUser), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.String, model.LastUpdate)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_IVRControl model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_IVRControl("); strSql.Append("KeyID, sFileName, iKeyNum, SubID, sIVRName, IsEnable, BeginDate, EndDate, LastUpdate)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sFileName, @in_iKeyNum, @in_SubID, @in_sIVRName, @in_IsEnable, @in_BeginDate, @in_EndDate, @in_LastUpdate)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_sFileName", DbType.String, model.sFileName), dbHelper.CreateInDbParameter("@in_iKeyNum", DbType.Int32, model.iKeyNum), dbHelper.CreateInDbParameter("@in_SubID", DbType.String, model.SubID), dbHelper.CreateInDbParameter("@in_sIVRName", DbType.String, model.sIVRName), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_BeginDate", DbType.DateTime, model.BeginDate), dbHelper.CreateInDbParameter("@in_EndDate", DbType.DateTime, model.EndDate), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.DateTime, model.LastUpdate)}; }
/// <summary> /// 为新增一条数据准备参数 /// </summary> internal static void PrepareAddCommand(ZSystem.Model.t_Client model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("INSERT INTO t_Client("); strSql.Append("KeyID, sClientName, sAddress, sMobiPhone, sTelPhone, CreateUserID, Memo,IsEnable,LastUpdate)"); strSql.Append(" VALUES ("); strSql.Append("@in_KeyID, @in_sClientName, @in_sAddress, @in_sMobiPhone, @in_sTelPhone, @in_CreateUserID, @in_Memo,@in_IsEnable,@In_LastUpdate)"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_KeyID", DbType.String, model.KeyID), dbHelper.CreateInDbParameter("@in_sClientName", DbType.String, model.sClientName), dbHelper.CreateInDbParameter("@in_sAddress", DbType.String, model.sAddress), dbHelper.CreateInDbParameter("@in_sMobiPhone", DbType.String, model.sMobiPhone), dbHelper.CreateInDbParameter("@in_sTelPhone", DbType.String, model.sTelPhone), dbHelper.CreateInDbParameter("@in_CreateUserID", DbType.String, model.CreateUserID), dbHelper.CreateInDbParameter("@in_Memo", DbType.String, model.Memo), dbHelper.CreateInDbParameter("@in_IsEnable", DbType.Boolean, model.IsEnable), dbHelper.CreateInDbParameter("@in_LastUpdate", DbType.String, model.LastUpdate)}; }
/// <summary> /// 为更新一条数据准备参数 /// </summary> internal static void PrepareUpdateCommand(ZSystem.Model.t_ChannelState model, out StringBuilder strSql, out DbParameter[] cmdParms) { strSql = new StringBuilder(); strSql.Append("UPDATE t_ChannelState SET "); strSql.Append("sChState=@in_sChState,"); strSql.Append("iChType=@in_iChType,"); strSql.Append("sCaller=@in_sCaller,"); strSql.Append("sDTMF=@in_sDTMF,"); strSql.Append("iTimeElapse=@in_iTimeElapse"); strSql.Append(" WHERE iChID=@in_iChID"); cmdParms = new DbParameter[]{ dbHelper.CreateInDbParameter("@in_sChState", DbType.String, model.sChState), dbHelper.CreateInDbParameter("@in_iChType", DbType.Int32, model.iChType), dbHelper.CreateInDbParameter("@in_sCaller", DbType.String, model.sCaller), dbHelper.CreateInDbParameter("@in_sDTMF", DbType.String, model.sDTMF), dbHelper.CreateInDbParameter("@in_iTimeElapse", DbType.Int32, model.iTimeElapse), dbHelper.CreateInDbParameter("@in_iChID", DbType.Int32, model.iChID)}; }
private new void Awake() { myrigid = GetComponent <Rigidbody2D>(); zSystem = GetComponent <ZSystem>(); }