• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# SYSModel.UserIDOP类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中SYSModel.UserIDOP的典型用法代码示例。如果您正苦于以下问题:C# UserIDOP类的具体用法?C# UserIDOP怎么用?C# UserIDOP使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



UserIDOP类属于SYSModel命名空间,在下文中一共展示了UserIDOP类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: TryCallWCFFunc

       public static bool TryCallWCFFunc(string OPNameStr, ReqeFunStruct requestObj, out RespFunStruct responseObj)
       {
           UserIDOP userOP = new UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = OPNameStr };
           requestObj.userIDOP = userOP;
           requestObj.PCClientCookieStr = GlobalStaticObj.CookieStr;
           RespFunStruct returnObj = new RespFunStruct();
           string requestStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(requestObj));
           if (!WCFClientProxy.TestPCClientProxy())
           {
               returnObj.IsSuccess = "0";
               returnObj.ReturnObject = "未能建立同服务器连接";
               responseObj = returnObj;
               MessageBox.Show("未能建立同服务器连接!");
               return false;
           }
           try
           {
               string ResultStr = GlobalStaticObj.proxy.JsonOperate(requestStr);
               string Str = HXCCommon.DotNetEncrypt.DESEncrypt.Decrypt(ResultStr);
               responseObj = JsonConvert.DeserializeObject<RespFunStruct>(Str);
               return true;
           }
           catch (Exception ex)
           {
               returnObj.IsSuccess = "0";
               returnObj.ReturnObject = "发生错误";
               returnObj.Msg = ex.Message;
               responseObj = returnObj;
               MessageBox.Show("发生错误!");
               return false;
           }

       }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:33,代码来源:CommonFuncCall.cs


示例2: GetListPages

        /// <summary>
        /// 调用分页存储过程返回得到的数据集
        /// </summary>
        /// <param name="page"></param>
        /// <param name="pageSize"></param>
        /// <param name="tableSource"></param>
        /// <param name="whereValue"></param>
        /// <param name="OrderExpression"></param>
        /// <param name="Fields"></param>
        /// <returns></returns>
        public static DataSet GetListPages(string connString, int page, int pageSize, string tableSource, string whereValue, string OrderExpression, string Fields, UserIDOP userID, ref int Counts)
        {
            SqlParameter[] parm = new SqlParameter[]
		    {
			    new SqlParameter("@TableSource", SqlDbType.VarChar, 1000),
			    new SqlParameter("@SelectList", SqlDbType.VarChar, 2000),
			    new SqlParameter("@SearchCondition", SqlDbType.VarChar, 4000),
			    new SqlParameter("@OrderExpression", SqlDbType.VarChar, 100),
			    new SqlParameter("@PageIndex", SqlDbType.Int, 4),
			    new SqlParameter("@PageSize", SqlDbType.Int, 4),
                new SqlParameter("@Counts", SqlDbType.Int, 4)
		    };

            parm[0].Value = tableSource;
            parm[1].Value = Fields;
            parm[2].Value = whereValue;
            parm[3].Value = OrderExpression;
            parm[4].Value = page;
            parm[5].Value = pageSize;

            parm[parm.Length - 1].Direction = ParameterDirection.Output;
            DataSet ds = new DataSet();
            ds = DBUtility.SqlHelper.ExecuteDataSet(connString, CommandType.StoredProcedure, "[dbo].[list_page_tables]", userID, parm);
            Counts = Convert.ToInt32(parm[parm.Length - 1].Value);

            return ds;
        }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:37,代码来源:ListPage.cs


示例3: UpdateByHashtableLog

 /// <summary> 日志的更新操作,千万不要再次进行写日志操作
 /// </summary>
 public static int UpdateByHashtableLog(UserIDOP userID, string connString, string tableName, string pkName, string pkVal, Dictionary<string, string> ht)
 {
     StringBuilder sb = new StringBuilder();
     sb.Append(" Update ");
     sb.Append(tableName);
     sb.Append(" Set ");
     bool isFirstValue = true;
     foreach (string key in ht.Keys)
     {
         if (isFirstValue)
         {
             isFirstValue = false;
             sb.Append(key);
             sb.Append("=");
             sb.Append("@" + key);
         }
         else
         {
             sb.Append("," + key);
             sb.Append("=");
             sb.Append("@" + key);
         }
     }
     sb.Append(" Where ").Append(pkName).Append("=").Append("@" + pkName).Append(";"); ;
     ht[pkName] = pkVal;
     SqlParameter[] _params = SqlHelper.GetParameter(ht);
     object _object = SqlHelper.ExecuteNonQueryNoBak(connString, CommandType.Text, sb.ToString(), userID, _params);
     return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:31,代码来源:SqlHelper.cs


示例4: GetSingleValue

 /// <summary> 查询单个字段的值(一般求最大,最小值)
 /// <param name="opName">操作名</param>
 /// <param name="tableName">表名</param>
 /// <param name="field">单个查询字段</param>
 /// <param name="orderBy">排序字段,多个以“,”分割</param>
 /// </summary>
 /// <returns>返回Value</returns>
 public static string GetSingleValue(string opName, string currAccDbName, string tableName, string field, string where, string orderBy)
 {
     StringBuilder strBuilder = new StringBuilder();
     strBuilder.Append("select " + field);
     if (!string.IsNullOrEmpty(tableName))
     {
         strBuilder.Append(" from  " + tableName);
         if (!string.IsNullOrEmpty(where))
         {
             strBuilder.Append(" where  " + where);
         }
         if (!string.IsNullOrEmpty(orderBy))
         {
             strBuilder.Append(" order by  " + orderBy);
         }
     }
     Dictionary<string, ParamObj> dic = new Dictionary<string, ParamObj>();
     UserIDOP userOp = new UserIDOP() { UserID = GlobalStaticObj_Server.Instance.UserID, OPName = opName };
     string connString = LocalVariable.GetConnString(currAccDbName, ConfigConst.ConnectionStringReadonly);
     object obj = DbCommon.Instance.ExecuteNonQueryReturnObjectNoTrans(connString, CommandType.Text, strBuilder.ToString(), dic, userOp);
     if (obj == null)
     {
         return "";
     }
     return obj.ToString();
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:33,代码来源:DBHelper.cs


示例5: Submit_AddOrEditLog

 /// <summary> 日志的更新操作,千万不要再次进行写日志操作
 /// </summary>
 public static bool Submit_AddOrEditLog(UserIDOP userID, string connString, string tableName, string pkName, string pkVal, Dictionary<string, string> ht)
 {
     if (string.IsNullOrEmpty(pkVal))
     {
         if (SqlHelper.InsertByHashtableLog(userID, connString, tableName, ht) > 0)
             return true;
         else
             return false;
     }
     else
     {
         if (SqlHelper.UpdateByHashtableLog(userID, connString, tableName, pkName, pkVal, ht) > 0)
             return true;
         else
             return false;
     }
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:19,代码来源:SqlHelper.cs


示例6: InsertByHashtableLog

 /// <summary> 日志的更新操作,千万不要再次进行写日志操作
 /// </summary>
 public static int InsertByHashtableLog(UserIDOP userID, string connString, string tableName, Dictionary<string, string> ht)
 {
     StringBuilder sb = new StringBuilder();
     sb.Append(" Insert Into ");
     sb.Append(tableName);
     sb.Append("(");
     StringBuilder sp = new StringBuilder();
     StringBuilder sb_prame = new StringBuilder();
     foreach (string key in ht.Keys)
     {
         sb_prame.Append("," + key);
         sp.Append(",@" + key);
     }
     sb.Append(sb_prame.ToString().Substring(1, sb_prame.ToString().Length - 1) + ") Values (");
     sb.Append(sp.ToString().Substring(1, sp.ToString().Length - 1) + ")").Append(";");
     int _object = SqlHelper.ExecuteNonQueryNoBak(connString, CommandType.Text, sb.ToString(), userID, SqlHelper.GetParameter(ht));
     return _object;
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:20,代码来源:SqlHelper.cs


示例7: Submit_AddOrEdit

 /// <summary> 新增或更新
 /// </summary>
 /// <param name="opName">操作名</param>
 /// <param name="accCode">帐套代码</param>
 /// <param name="tableName">表名</param>
 /// <param name="keyName">主键名称</param>
 /// <param name="keyValue">主键值,如果有值,表示更新记录</param>
 /// <param name="dicFileds">字段集合</param>
 /// <returns>返回执行是否成功</returns>
 public static bool Submit_AddOrEdit(string opName, string accCode, string tableName, string keyName, string keyValue, Dictionary<string, string> dicFileds)
 {
     ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
     reqeFunStruct.SubSysName = SubSysName.CommonBaseFuncCall;
     reqeFunStruct.FunName = ComFunCallEnum.Submit_AddOrEdit;
     reqeFunStruct.AccCode = accCode;
     Submit_AddOrEdit submit_AddOrEdit = new Submit_AddOrEdit();
     submit_AddOrEdit.TableName = string.Format("{0}", tableName);
     submit_AddOrEdit.DicParam = dicFileds;
     submit_AddOrEdit.pkName = keyName;//默认第一个
     submit_AddOrEdit.pkVal = keyValue;
     reqeFunStruct.FunObject = submit_AddOrEdit;
     UserIDOP userOp = new UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = opName };
     reqeFunStruct.userIDOP = userOp;
     reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
     var addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
     var respO = JsonOperate(addStr);
     if (respO.IsSuccess == "0")
     {
         return false;
     }
     return bool.Parse(respO.ReturnObject);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:32,代码来源:DBHelper.cs


示例8: DeleteDataByID

 /// <summary> 删除 BYID
 /// </summary>
 /// <param name="opName">操作名</param>
 /// <param name="accCode">帐套代码</param>
 /// <param name="tableName">表名</param>
 /// <param name="keyName">键名称</param>
 /// <param name="keyValue">键值</param>
 /// <returns></returns>
 public static bool DeleteDataByID(string opName, string accCode, string tableName, string keyName, string keyValue)
 {
     ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
     reqeFunStruct.SubSysName = SubSysName.CommonBaseFuncCall;
     reqeFunStruct.FunName = ComFunCallEnum.DeleteDataByID;
     reqeFunStruct.AccCode = accCode;
     DeleteDataByID DeleteDataByID = new DeleteDataByID();
     DeleteDataByID.TableName = string.Format("{0}", tableName);
     DeleteDataByID.pkName = keyName;//默认第一个
     DeleteDataByID.pkVal = keyValue;
     reqeFunStruct.FunObject = DeleteDataByID;
     UserIDOP userOp = new UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = opName };
     reqeFunStruct.userIDOP = userOp;
     reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
     var addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
     var respO = JsonOperate(addStr);
     if (respO.IsSuccess == "0")
     {
         return false;
     }
     return bool.Parse(respO.ReturnObject);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:30,代码来源:DBHelper.cs


示例9: LogFunctionCall

 public static void LogFunctionCall(string fun_id, string setbook_id)
 {
     ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
     reqeFunStruct.SubSysName = SubSysName.ExtendBaseFuncCall;
     reqeFunStruct.FunName = ComFunCallEnum.LogFunctionCall;
     reqeFunStruct.AccCode = GlobalStaticObj.CurrAccCode;
     UserFunctionOPLog FunctionOP_Add = new UserFunctionOPLog();
     FunctionOP_Add.com_id = GlobalStaticObj.CurrUserCom_Id;
     FunctionOP_Add.fun_id = fun_id;           
     FunctionOP_Add.access_time = Common.LocalDateTimeToUtcLong(GlobalStaticObj.CurrentDateTime);
     FunctionOP_Add.userOP = new SYSModel.UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = "菜单功能操作日志" };
     reqeFunStruct.FunObject = FunctionOP_Add;
     UserIDOP userOp = new SYSModel.UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = "菜单功能操作日志" };
     reqeFunStruct.userIDOP = userOp;
     reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
     string addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
     if (!WCFClientProxy.TestDataProxy())
     {
         throw new Exception("未能建立同服务器连接!");
     }
     GlobalStaticObj.proxy.JsonOperate(addStr);           
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:22,代码来源:DBHelper.cs


示例10: GetSingleValue

 /// <summary> 查询单个字段的值(一般求最大,最小值)
 /// <param name="opName">操作名</param>
 /// <param name="accCode">帐套代码</param>
 /// <param name="tableName">表名</param>
 /// <param name="field">单个查询字段</param>
 /// <param name="orderBy">排序字段,多个以“,”分割</param>
 /// </summary>
 /// <returns>返回Value</returns>
 public static string GetSingleValue(string opName, string accCode, string tableName, string field, string where, string orderBy)
 {
     ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
     reqeFunStruct.SubSysName = SubSysName.CommonBaseFuncCall;
     reqeFunStruct.FunName = ComFunCallEnum.ExecuteNonQueryReturnObjectNoTrans;
     reqeFunStruct.AccCode = accCode;
     SQLObj sqlObj = new SQLObj();
     sqlObj.cmdType = CommandType.Text;
     StringBuilder strBuilder = new StringBuilder();
     strBuilder.Append("select " + field);
     if (!string.IsNullOrEmpty(tableName))
     {
         strBuilder.Append(" from  " + tableName);
         if (!string.IsNullOrEmpty(where))
         {
             strBuilder.Append(" where  " + where);
         }
         if (!string.IsNullOrEmpty(orderBy))
         {
             strBuilder.Append(" order by  " + orderBy);
         }
     }
     sqlObj.sqlString = strBuilder.ToString();
     sqlObj.Param = new Dictionary<string, ParamObj>();
     ExecuteNonQueryReturnDataSetNoTrans executeNonQueryReturnDataSetNoTrans = new ExecuteNonQueryReturnDataSetNoTrans();
     executeNonQueryReturnDataSetNoTrans.ReadOnlyFlag = true;
     executeNonQueryReturnDataSetNoTrans.sqlObj = sqlObj;
     reqeFunStruct.FunObject = executeNonQueryReturnDataSetNoTrans;
     UserIDOP userOp = new UserIDOP() { UserID = GlobalStaticObj.UserID, OPName = opName };
     reqeFunStruct.userIDOP = userOp;
     reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
     var addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
     var respO = JsonOperate(addStr);
     if (respO.IsSuccess == "0")
     {
         return "";
     }
     return respO.ReturnObject;
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:47,代码来源:DBHelper.cs


示例11: IsExist

 public int IsExist(string connStr, string tableName, string pkName, string pkVal, UserIDOP userID)
 {
     return  DBUtility.SqlHelper.IsExist(connStr, tableName, pkName, pkVal, userID);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:4,代码来源:ManageSql.cs


示例12: BatchDeleteDataByWhere

 /// <summary> 批量删除 - where
 /// </summary>
 public static int BatchDeleteDataByWhere(string connStr, string tableName, string whereString, UserIDOP userID)
 {
     StringBuilder sb = new StringBuilder("Delete From " + tableName + " Where " + whereString).Append(";");
     return SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sb.ToString(), userID, null);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:7,代码来源:SqlHelper.cs


示例13: BatchUpdateDataMultiByTrans

 /// <summary> 批量更新- 多条语句-事务
 /// </summary
 public static int BatchUpdateDataMultiByTrans(string connStr, IList<UpdateSQLObj> batUpdateList, UserIDOP userID)
 {
     StringBuilder sb = new StringBuilder();
     List<SqlParameter> paramList = new List<SqlParameter>();
     string str = string.Empty;
     int index = 0;
     foreach (UpdateSQLObj sqlObj in batUpdateList)
     {
         sb.Append(" Update ");
         sb.Append(sqlObj.TableName);
         sb.Append(" Set ");
         bool isFirstValue = true;
         foreach (string key in sqlObj.DicParam.Keys)
         {
             if (isFirstValue)
             {
                 isFirstValue = false;
                 sb.Append(key);
                 sb.Append("=");
                 sb.Append("@Param" + index.ToString());
             }
             else
             {
                 sb.Append("," + key);
                 sb.Append("=");
                 sb.Append("@Param" + index.ToString());
             }
             paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.DicParam[key]));
             index++;
         }
         if (sqlObj.pkName != null)
         {
             sb.Append(" Where ").Append(sqlObj.pkName).Append("=").Append("@Param" + index.ToString()).Append(";");
             paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.pkVal));
             index++;
         }
         else if (!string.IsNullOrEmpty(sqlObj.whereString))
         {
             sb.Append(" Where ").Append(sqlObj.whereString).Append(";");
         }
     }
     object _object = SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sb.ToString(), userID, paramList.ToArray());
     return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:46,代码来源:SqlHelper.cs


示例14: GetDataTable

 public DataTable GetDataTable(string connStr,string tableName, UserIDOP userID)
 {
     return DBUtility.SqlHelper.GetDataTable(connStr, tableName, userID);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:4,代码来源:ManageSql.cs


示例15: BatchUpdateDataByWhere

 /// <summary> 批量更新- where
 /// </summary>
 public static int BatchUpdateDataByWhere(string connStr, string tableName, Dictionary<string, string> ht, string whereString, UserIDOP userID)
 {
     StringBuilder sb = new StringBuilder();
     sb.Append(" Update ");
     sb.Append(tableName);
     sb.Append(" Set ");
     bool isFirstValue = true;
     foreach (string key in ht.Keys)
     {
         if (isFirstValue)
         {
             isFirstValue = false;
             sb.Append(key);
             sb.Append("=");
             sb.Append("@" + key);
         }
         else
         {
             sb.Append("," + key);
             sb.Append("=");
             sb.Append("@" + key);
         }
     }
     sb.Append(" Where ").Append(whereString).Append(";"); ;
     SqlParameter[] _params = SqlHelper.GetParameter(ht);
     object _object = SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sb.ToString(), userID, _params);
     return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:30,代码来源:SqlHelper.cs


示例16: BatchUpdateDataByIn

 /// <summary> 批量更新- in
 /// </summary>
 public static int BatchUpdateDataByIn(string connStr, string tableName, Dictionary<string, string> ht, string pkName, object[] pkValues, UserIDOP userID)
 {
     StringBuilder sb = new StringBuilder();
     SqlParameter[] param = new SqlParameter[ht.Count + pkValues.Length];
     int index = 0;
     string str = string.Empty;
     sb.Append(" Update ");
     sb.Append(tableName);
     sb.Append(" Set ");
     bool isFirstValue = true;
     foreach (string key in ht.Keys)
     {
         if (isFirstValue)
         {
             isFirstValue = false;
             sb.Append(key);
             sb.Append("=");
             sb.Append("@" + key);
         }
         else
         {
             sb.Append("," + key);
             sb.Append("=");
             sb.Append("@" + key);
         }
         param[index] = new SqlParameter("@" + key, ht[key]);
         index++;
     }
     sb.Append(" Where ").Append(pkName).Append(" IN (");
     for (int i = 0; i < (pkValues.Length); i++)
     {
         object obj2 = pkValues[i];
         str = "@" + pkName + index;
         sb.Append(str).Append(",");
         param[index] = new SqlParameter(str, obj2);
         index++;
     }
     string sqlStr = sb.ToString().TrimEnd(',');
     sqlStr += " ); ";
     object _object = SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sqlStr, userID, param);
     return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:44,代码来源:SqlHelper.cs


示例17: UpdateByHashtable

 /// <summary> 通过Hashtable修改数据
 /// </summary>
 /// <param name="tableName">表名</param>
 /// <param name="pkName">字段主键</param>
 /// <param name="pkValue"></param>
 /// <param name="ht">Hashtable</param>
 /// <returns>int</returns>
 public static bool UpdateByHashtable(string connString, string tableName, string pkName, string pkVal, Dictionary<string, string> ht, UserIDOP userID)
 {
     StringBuilder sb = new StringBuilder();
     sb.Append(" Update ");
     sb.Append(tableName);
     sb.Append(" Set ");
     bool isFirstValue = true;
     foreach (string key in ht.Keys)
     {
         if (isFirstValue)
         {
             isFirstValue = false;
             sb.Append(key);
             sb.Append("=");
             sb.Append("@" + key);
         }
         else
         {
             sb.Append("," + key);
             sb.Append("=");
             sb.Append("@" + key);
         }
     }
     sb.Append(" Where ").Append(pkName).Append("=").Append("@" + pkName).Append(";");
     ht[pkName] = pkVal;
     SqlParameter[] myParamArray = GetParameter(ht);
     return SqlHelper.ExecuteNonQueryReturnBool(connString, CommandType.Text, sb.ToString(), userID, myParamArray);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:35,代码来源:SqlHelper.cs


示例18: Submit_AddOrEdit

 /// <summary> 表单提交:新增,修改
 ///     参数:
 ///     tableName:表名
 ///     pkName:字段主键
 ///     pkVal:字段值
 ///     ht:参数
 /// </summary>
 /// <returns></returns>
 public static bool Submit_AddOrEdit(string connString, string tableName, string pkName, string pkVal, Dictionary<string, string> ht, UserIDOP userID)
 {
     if (string.IsNullOrEmpty(pkVal))
     {
         return SqlHelper.InsertByHashtable(connString, tableName, ht, userID);
     }
     else
     {
         return SqlHelper.UpdateByHashtable(connString, tableName, pkName, pkVal, ht, userID);
     }
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:19,代码来源:SqlHelper.cs


示例19: BatchDeleteData

 /// <summary> 批量删除 - object[]
 /// </summary>
 /// <param name="tableName">表名</param>
 /// <param name="pkName">字段主键</param>
 /// <param name="pkVal">字段值</param>
 /// <returns></returns>
 public static int BatchDeleteData(string connString, string tableName, string pkName, object[] pkValues, UserIDOP userID)
 {
     SqlParameter[] param = new SqlParameter[pkValues.Length];
     int index = 0;
     string str = "@ID" + index;
     StringBuilder sql = new StringBuilder("DELETE FROM " + tableName + " WHERE " + pkName + " IN (");
     for (int i = 0; i < (param.Length - 1); i++)
     {
         object obj2 = pkValues[i];
         str = "@ID" + index;
         sql.Append(str).Append(",");
         param[index] = new SqlParameter(str, obj2);
         index++;
     }
     str = "@ID" + index;
     sql.Append(str);
     param[index] = new SqlParameter(str, pkValues[index]);
     sql.Append(" );");
     return SqlHelper.ExecuteNonQueryTran(connString, CommandType.Text, sql.ToString(), userID, param);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:26,代码来源:SqlHelper.cs


示例20: Submit_AddOrEdit

 public bool Submit_AddOrEdit(string connStr, string tableName, string pkName, string pkVal, Dictionary<string, string> ht,UserIDOP userID)
 {
     return DBUtility.SqlHelper.Submit_AddOrEdit(connStr, tableName, pkName, pkVal, ht, userID);
 }
开发者ID:caocf,项目名称:workspace-kepler,代码行数:4,代码来源:ManageSql.cs



注:本文中的SYSModel.UserIDOP类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# PrimaryTypes.Character类代码示例发布时间:2022-05-26
下一篇:
C# SYSModel.SysSQLString类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap