/// <summary>
/// 将数据对象转换成整形
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int ObjectToInt32(object obj)
{
return(DataConvert.CLng(obj));
}
/// <summary>
/// 查询记录是否存在
/// </summary>
/// <param name="strCommand">查询命令</param>
/// <param name="cmdParams">查询参数</param>
/// <returns>存在返回true 否则false</returns>
public static bool Exists(CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
return(DataConvert.CLng(ExecuteScalar(cmdType, cmdText, commandParameters)) > 0);
}
/// <summary>
/// 获取表里某字段的最大值
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="fieldName">字段名</param>
/// <returns>该字段在表里的最大值</returns>
public static int GetMaxId(string tableName, string fieldName)
{
string query = "select max(" + fieldName + ") from " + tableName;
return(DataConvert.CLng(ExecuteScalar(CommandType.Text, query, null)));
}
private static SqlParameter GetPara(DataRow dr)
{
string FieldType = dr["FieldType"].ToString();
SqlParameter result = new SqlParameter();
switch (FieldType)
{
case "TextType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "OptionType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "GradeOptionType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "ListBoxType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NText);
result.Value = dr["FieldValue"].ToString();
break;
case "DateType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.DateTime);
result.Value = DataConvert.CDate(dr["FieldValue"].ToString());
break;
case "MultipleHtmlType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NText);
result.Value = dr["FieldValue"].ToString();
break;
case "MultipleTextType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NText);
result.Value = dr["FieldValue"].ToString();
break;
case "FileType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NText);
result.Value = dr["FieldValue"].ToString();
break;
case "PicType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "FileSize":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "ThumbField":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "MultiPicType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NText);
result.Value = dr["FieldValue"].ToString();
break;
case "OperatingType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "SuperLinkType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
case "BoolType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.Bit, 1);
result.Value = dr["FieldValue"].ToString();
break;
case "int":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.Int);
result.Value = DataConvert.CLng(dr["FieldValue"].ToString());
break;
case "NumType":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.Float);
result.Value = DataConvert.CFloat(dr["FieldValue"].ToString());
break;
case "float":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.Float);
result.Value = DataConvert.CFloat(dr["FieldValue"].ToString());
break;
case "money":
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.Money);
result.Value = DataConvert.CFloat(dr["FieldValue"].ToString());
break;
default:
result = new SqlParameter(dr["FieldName"].ToString(), SqlDbType.NVarChar, 255);
result.Value = dr["FieldValue"].ToString();
break;
}
return(result);
}