/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TCode_SecurityConfig model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TCode_SecurityConfig(");
strSql.Append("s_PwdComplexity,n_PwdMinLength,s_PwdRegular,s_PwdCycle,n_PwdYear,n_PwdMonth,n_PwdDay,s_Idle,n_TimeoutDay,n_TimeoutHour,n_TimeoutMinute,s_FailureTry,n_LockHour,n_LockMinute,n_Retry,s_AccessControl,s_IP)");
strSql.Append(" values (");
strSql.Append("@s_PwdComplexity,@n_PwdMinLength,@s_PwdRegular,@s_PwdCycle,@n_PwdYear,@n_PwdMonth,@n_PwdDay,@s_Idle,@n_TimeoutDay,@n_TimeoutHour,@n_TimeoutMinute,@s_FailureTry,@n_LockHour,@n_LockMinute,@n_Retry,@s_AccessControl,@s_IP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@s_PwdComplexity", SqlDbType.NVarChar, 1),
new SqlParameter("@n_PwdMinLength", SqlDbType.Int, 4),
new SqlParameter("@s_PwdRegular", SqlDbType.NVarChar, 20),
new SqlParameter("@s_PwdCycle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_PwdYear", SqlDbType.Int, 4),
new SqlParameter("@n_PwdMonth", SqlDbType.Int, 4),
new SqlParameter("@n_PwdDay", SqlDbType.Int, 4),
new SqlParameter("@s_Idle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_TimeoutDay", SqlDbType.Int, 4),
new SqlParameter("@n_TimeoutHour", SqlDbType.Int, 4),
new SqlParameter("@n_TimeoutMinute", SqlDbType.Int, 4),
new SqlParameter("@s_FailureTry", SqlDbType.NVarChar, 1),
new SqlParameter("@n_LockHour", SqlDbType.Int, 4),
new SqlParameter("@n_LockMinute", SqlDbType.Int, 4),
new SqlParameter("@n_Retry", SqlDbType.Int, 4),
new SqlParameter("@s_AccessControl", SqlDbType.NVarChar, 1),
new SqlParameter("@s_IP", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.s_PwdComplexity;
parameters[1].Value = model.n_PwdMinLength;
parameters[2].Value = model.s_PwdRegular;
parameters[3].Value = model.s_PwdCycle;
parameters[4].Value = model.n_PwdYear;
parameters[5].Value = model.n_PwdMonth;
parameters[6].Value = model.n_PwdDay;
parameters[7].Value = model.s_Idle;
parameters[8].Value = model.n_TimeoutDay;
parameters[9].Value = model.n_TimeoutHour;
parameters[10].Value = model.n_TimeoutMinute;
parameters[11].Value = model.s_FailureTry;
parameters[12].Value = model.n_LockHour;
parameters[13].Value = model.n_LockMinute;
parameters[14].Value = model.n_Retry;
parameters[15].Value = model.s_AccessControl;
parameters[16].Value = model.s_IP;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCode_SecurityConfig GetModel(int n_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_ID,s_PwdComplexity,n_PwdMinLength,s_PwdRegular,s_PwdCycle,n_PwdYear,n_PwdMonth,n_PwdDay,s_Idle,n_TimeoutDay,n_TimeoutHour,n_TimeoutMinute,s_FailureTry,n_LockHour,n_LockMinute,n_Retry,s_AccessControl,s_IP from TCode_SecurityConfig ");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = n_ID;
IPSP.Model.TCode_SecurityConfig model = new IPSP.Model.TCode_SecurityConfig();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TCode_SecurityConfig model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TCode_SecurityConfig model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCode_SecurityConfig DataRowToModel(DataRow row)
{
IPSP.Model.TCode_SecurityConfig model = new IPSP.Model.TCode_SecurityConfig();
if (row != null)
{
if (row["n_ID"] != null && row["n_ID"].ToString() != "")
{
model.n_ID = int.Parse(row["n_ID"].ToString());
}
if (row["s_PwdComplexity"] != null)
{
model.s_PwdComplexity = row["s_PwdComplexity"].ToString();
}
if (row["n_PwdMinLength"] != null && row["n_PwdMinLength"].ToString() != "")
{
model.n_PwdMinLength = int.Parse(row["n_PwdMinLength"].ToString());
}
if (row["s_PwdRegular"] != null)
{
model.s_PwdRegular = row["s_PwdRegular"].ToString();
}
if (row["s_PwdCycle"] != null)
{
model.s_PwdCycle = row["s_PwdCycle"].ToString();
}
if (row["n_PwdYear"] != null && row["n_PwdYear"].ToString() != "")
{
model.n_PwdYear = int.Parse(row["n_PwdYear"].ToString());
}
if (row["n_PwdMonth"] != null && row["n_PwdMonth"].ToString() != "")
{
model.n_PwdMonth = int.Parse(row["n_PwdMonth"].ToString());
}
if (row["n_PwdDay"] != null && row["n_PwdDay"].ToString() != "")
{
model.n_PwdDay = int.Parse(row["n_PwdDay"].ToString());
}
if (row["s_Idle"] != null)
{
model.s_Idle = row["s_Idle"].ToString();
}
if (row["n_TimeoutDay"] != null && row["n_TimeoutDay"].ToString() != "")
{
model.n_TimeoutDay = int.Parse(row["n_TimeoutDay"].ToString());
}
if (row["n_TimeoutHour"] != null && row["n_TimeoutHour"].ToString() != "")
{
model.n_TimeoutHour = int.Parse(row["n_TimeoutHour"].ToString());
}
if (row["n_TimeoutMinute"] != null && row["n_TimeoutMinute"].ToString() != "")
{
model.n_TimeoutMinute = int.Parse(row["n_TimeoutMinute"].ToString());
}
if (row["s_FailureTry"] != null)
{
model.s_FailureTry = row["s_FailureTry"].ToString();
}
if (row["n_LockHour"] != null && row["n_LockHour"].ToString() != "")
{
model.n_LockHour = int.Parse(row["n_LockHour"].ToString());
}
if (row["n_LockMinute"] != null && row["n_LockMinute"].ToString() != "")
{
model.n_LockMinute = int.Parse(row["n_LockMinute"].ToString());
}
if (row["n_Retry"] != null && row["n_Retry"].ToString() != "")
{
model.n_Retry = int.Parse(row["n_Retry"].ToString());
}
if (row["s_AccessControl"] != null)
{
model.s_AccessControl = row["s_AccessControl"].ToString();
}
if (row["s_IP"] != null)
{
model.s_IP = row["s_IP"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TCode_SecurityConfig model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TCode_SecurityConfig set ");
strSql.Append("s_PwdComplexity=@s_PwdComplexity,");
strSql.Append("n_PwdMinLength=@n_PwdMinLength,");
strSql.Append("s_PwdRegular=@s_PwdRegular,");
strSql.Append("s_PwdCycle=@s_PwdCycle,");
strSql.Append("n_PwdYear=@n_PwdYear,");
strSql.Append("n_PwdMonth=@n_PwdMonth,");
strSql.Append("n_PwdDay=@n_PwdDay,");
strSql.Append("s_Idle=@s_Idle,");
strSql.Append("n_TimeoutDay=@n_TimeoutDay,");
strSql.Append("n_TimeoutHour=@n_TimeoutHour,");
strSql.Append("n_TimeoutMinute=@n_TimeoutMinute,");
strSql.Append("s_FailureTry=@s_FailureTry,");
strSql.Append("n_LockHour=@n_LockHour,");
strSql.Append("n_LockMinute=@n_LockMinute,");
strSql.Append("n_Retry=@n_Retry,");
strSql.Append("s_AccessControl=@s_AccessControl,");
strSql.Append("s_IP=@s_IP");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@s_PwdComplexity", SqlDbType.NVarChar, 1),
new SqlParameter("@n_PwdMinLength", SqlDbType.Int, 4),
new SqlParameter("@s_PwdRegular", SqlDbType.NVarChar, 20),
new SqlParameter("@s_PwdCycle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_PwdYear", SqlDbType.Int, 4),
new SqlParameter("@n_PwdMonth", SqlDbType.Int, 4),
new SqlParameter("@n_PwdDay", SqlDbType.Int, 4),
new SqlParameter("@s_Idle", SqlDbType.NVarChar, 1),
new SqlParameter("@n_TimeoutDay", SqlDbType.Int, 4),
new SqlParameter("@n_TimeoutHour", SqlDbType.Int, 4),
new SqlParameter("@n_TimeoutMinute", SqlDbType.Int, 4),
new SqlParameter("@s_FailureTry", SqlDbType.NVarChar, 1),
new SqlParameter("@n_LockHour", SqlDbType.Int, 4),
new SqlParameter("@n_LockMinute", SqlDbType.Int, 4),
new SqlParameter("@n_Retry", SqlDbType.Int, 4),
new SqlParameter("@s_AccessControl", SqlDbType.NVarChar, 1),
new SqlParameter("@s_IP", SqlDbType.NVarChar, -1),
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.s_PwdComplexity;
parameters[1].Value = model.n_PwdMinLength;
parameters[2].Value = model.s_PwdRegular;
parameters[3].Value = model.s_PwdCycle;
parameters[4].Value = model.n_PwdYear;
parameters[5].Value = model.n_PwdMonth;
parameters[6].Value = model.n_PwdDay;
parameters[7].Value = model.s_Idle;
parameters[8].Value = model.n_TimeoutDay;
parameters[9].Value = model.n_TimeoutHour;
parameters[10].Value = model.n_TimeoutMinute;
parameters[11].Value = model.s_FailureTry;
parameters[12].Value = model.n_LockHour;
parameters[13].Value = model.n_LockMinute;
parameters[14].Value = model.n_Retry;
parameters[15].Value = model.s_AccessControl;
parameters[16].Value = model.s_IP;
parameters[17].Value = model.n_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
