public static void Update(WebPage cus)
{
string sql = @"UPDATE [QLCV_WebPage]
SET [Page] = '" + cus.Page + @"'
,[Active] = " + cus.Active + @"
,[Type] = '" + cus.Type + @"'
WHERE ID=" + cus.ID;
ServerProvider.ExecuteNonQuery(sql);
}
public static bool Delete(int ID)
{
try
{
string sql = "delete from QLCV_FieldSetting where ID=" + ID + "";
ServerProvider.ExecuteNonQuery(sql);
return(true);
}
catch { return(false); }
}
public static bool Delete(long ID)
{
try
{
string sql = "delete from QLCV_WebPage where ID=" + ID + "";
ServerProvider.ExecuteNonQuery(sql);
return(true);
}
catch { return(false); }
}
public static void Update(WebStep cus)
{
string sql = @"UPDATE [QLCV_WebStep]
SET [IDWeb] = " + cus.IDWeb + @"
,[Step] = " + cus.Step + @"
,[Action] = N'" + cus.Action + @"'
,[Message] = N'" + cus.Message + @"'
WHERE IDWeb=" + cus.IDWeb + " and Step=" + cus.Step;
ServerProvider.ExecuteNonQuery(sql);
}
public static void Update(FieldSetting cus)
{
string sql = @"UPDATE [QLCV_FieldSetting]
SET [Control] = N'" + cus.Control + @"'
,[Attribute] = N'" + cus.Attribute + @"'
,[Value] = N'" + cus.Value + @"'
,[Field] = N'" + cus.Field + @"'
,[Type] = '" + cus.Type + @"'
WHERE ID=" + cus.ID;
ServerProvider.ExecuteNonQuery(sql);
}
public static long Insert(WebPage cus)
{
string sql = @"INSERT INTO QLCV_WebPage
([Page]
,[Active]
,[Type])
VALUES
(" + cus.Page + @"
," + cus.Active + @"
,'" + cus.Type + @"')";
ServerProvider.ExecuteNonQuery(sql);
return(long.Parse(ServerProvider.ExecuteScalar("Select @@IDENTITY").ToString()));
}
public static int Insert(FieldSetting cus)
{
string sql = @"INSERT INTO QLCV_FieldSetting
([Control]
,[Attribute]
,[Value]
,[Field],[Type])
VALUES
(N'" + cus.Control + @"'
,N'" + cus.Attribute + @"'
,N'" + cus.Value + @"'
,N'" + cus.Field + @"'
,N'" + cus.Type + @"')";
ServerProvider.ExecuteNonQuery(sql);
return(int.Parse(ServerProvider.ExecuteScalar("Select @@IDENTITY").ToString()));
}
public static long Insert(WebStep cus)
{
string sql = @"INSERT INTO QLCV_WebStep
([IDWeb]
,[Step]
,[Action]
,[Message])
VALUES
(" + cus.IDWeb + @"
," + cus.Step + @"
,N'" + cus.Action + @"'
,N'" + cus.Message + @"')";
ServerProvider.ExecuteNonQuery(sql);
return(1);
//return long.Parse(ServerProvider.ExecuteScalar("Select @@IDENTITY").ToString());
}
//public static DataTable GetAll()
//{
// string sql = "select * from WebStep ";
// return Provider.ExecuteToDataTable(sql);
//}
public static void DeleteByID(long ID)
{
string sql = "delete from QLCV_WebStep where IDWeb=" + ID + "";
ServerProvider.ExecuteNonQuery(sql);
}