主题:[讨论]继承有错误
public class alarmSetData :BaseClass
{
//定义变量省略
public static SqlParameter[] CreateParms( )
{
SqlParameter[] sqlParms = new SqlParameter[]
{
new SqlParameter(PARM_CODE,SqlDbType.VarChar,30),
new SqlParameter(PARM_NAME,SqlDbType.VarChar,30),
new SqlParameter(PARM_ALARM_LEVEL,SqlDbType.VarChar,30),
new SqlParameter(PARM_SWITCH_ID,SqlDbType.VarChar,30),
new SqlParameter(PARM_SPEC,SqlDbType.VarChar,30),
new SqlParameter(PARM_ALARM_RESOLV,SqlDbType.VarChar,30)
};
return sqlParms;
}
public bool Create( BaseStruct bs):base(bs)//这个地方提示有错误
//:和)有误,怎么回事呢?
{
}
}
////////////////////////////
public class BaseClass//
{
public bool create(BaseStruct bs)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=GAOXIAO;user id = sa;pwd=mazha;database=weartest1";
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = bs.Sql;
for (int i = 0; i < bs.sqlParms.Length; i++)
{
bs.sqlParms[i].Value = bs.parmsValue[i];
command.Parameters.Add(bs.sqlParms[i]);//添加参数
}
//try to execute sql
try
{
conn.Open();
command.ExecuteNonQuery();
return true;
} //end try to execute sql
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
conn.Close();
} //end finally
}
}
{
//定义变量省略
public static SqlParameter[] CreateParms( )
{
SqlParameter[] sqlParms = new SqlParameter[]
{
new SqlParameter(PARM_CODE,SqlDbType.VarChar,30),
new SqlParameter(PARM_NAME,SqlDbType.VarChar,30),
new SqlParameter(PARM_ALARM_LEVEL,SqlDbType.VarChar,30),
new SqlParameter(PARM_SWITCH_ID,SqlDbType.VarChar,30),
new SqlParameter(PARM_SPEC,SqlDbType.VarChar,30),
new SqlParameter(PARM_ALARM_RESOLV,SqlDbType.VarChar,30)
};
return sqlParms;
}
public bool Create( BaseStruct bs):base(bs)//这个地方提示有错误
//:和)有误,怎么回事呢?
{
}
}
////////////////////////////
public class BaseClass//
{
public bool create(BaseStruct bs)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=GAOXIAO;user id = sa;pwd=mazha;database=weartest1";
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = bs.Sql;
for (int i = 0; i < bs.sqlParms.Length; i++)
{
bs.sqlParms[i].Value = bs.parmsValue[i];
command.Parameters.Add(bs.sqlParms[i]);//添加参数
}
//try to execute sql
try
{
conn.Open();
command.ExecuteNonQuery();
return true;
} //end try to execute sql
finally
{
if (conn != null && conn.State != ConnectionState.Closed)
conn.Close();
} //end finally
}
}