/// <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>();
}
