/// <summary>
/// 将机型保存到数据库
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public static bool Save(ModeZheWangSet mode, All.Class.DataReadAndWrite Conn)
{
Delete(mode.ID, Conn);
//字符串
string sql = "insert into SetZheWang ({0}) values ({1})";
string title = "ModeId,Mode,ModeInfo {0}{1}{2}";
string value = "'{0}','{1}','{2}'{3}{4}{5}";
//标题
string playFile = ",PlayFile1";
string start = ",Start1";
string end = ",End1";
title = string.Format(title, playFile, start, end);
//值
playFile = string.Format(",'{0}'", mode.PlayFile);
start = string.Format(",{0}", mode.Start);
end = string.Format(",{0}", mode.End);
value = string.Format(value, mode.ID, mode.Mode, mode.Info, playFile, start, end);
//组合后写入数据库
sql = string.Format(sql, title, value);
return(Conn.Write(sql) == 1);
}
///// <summary>
///// 机型转化为可传递的字符串
///// </summary>
///// <returns></returns>
//public string ClassToStr()
//{
// Dictionary<string, string> buff = new Dictionary<string, string>();
// buff.Add("ID", this.ID);
// buff.Add("Mode", this.Mode);
// buff.Add("Info", this.Info);
// buff.Add("PlayFile1", PlayFile);
// buff.Add("Star1", Start.ToString());
// buff.Add("End1", End.ToString());
// return All.Class.SSFile.Dictionary2Text(buff);
//}
///// <summary>
///// 字符串还原为机型
///// </summary>
///// <param name="str"></param>
///// <returns></returns>
//public static ModeZheWangSet StrToClass(string str)
//{
// ModeZheWangSet result = new ModeZheWangSet();
// Dictionary<string, string> buff = All.Class.SSFile.Text2Dictionary(str);
// result.ID = buff["ID"];
// result.Mode = buff["Mode"];
// result.Info = buff["Info"];
// result.PlayFile = buff["PlayFile1"];
// result.Start = All.Class.Num.ToInt(buff["Start1"]);
// result.End = All.Class.Num.ToInt(buff["End1"]);
// return result;
//}
#endregion
/// <summary>
/// 根据机型ID得到机型
/// </summary>
/// <param name="modeID"></param>
/// <returns></returns>
public static ModeZheWangSet GetMode(string modeID, All.Class.DataReadAndWrite Conn)
{
ModeZheWangSet result = new ModeZheWangSet();
using (DataTable dt = Conn.Read(string.Format("select * from SetZheWang where ModeID='{0}'", modeID)))
{
if (dt != null && dt.Rows.Count >= 1)
{
result.ID = All.Class.Num.ToString(dt.Rows[0]["ModeID"]);
result.Mode = All.Class.Num.ToString(dt.Rows[0]["Mode"]);
result.Info = All.Class.Num.ToString(dt.Rows[0]["ModeInfo"]);
result.PlayFile = All.Class.Num.ToString(dt.Rows[0]["PlayFile1"]);
result.Start = All.Class.Num.ToInt(dt.Rows[0]["Start1"]);
result.End = All.Class.Num.ToInt(dt.Rows[0]["End1"]);
}
}
return(result);
}
/// <summary>
/// 获取所有机型
/// </summary>
/// <returns></returns>
public static List <ModeZheWangSet> GetModeList(All.Class.DataReadAndWrite Conn)
{
List <ModeZheWangSet> result = new List <ModeZheWangSet>();
using (DataTable dt = Conn.Read("select ModeId,Mode,ModeInfo from SetZheWang order by ID desc"))
{
if (dt != null && dt.Rows.Count > 0)
{
ModeZheWangSet tmpModeZheWangSet;
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpModeZheWangSet = new ModeZheWangSet();
tmpModeZheWangSet.ID = All.Class.Num.ToString(dt.Rows[i]["ModeID"]);
tmpModeZheWangSet.Mode = All.Class.Num.ToString(dt.Rows[i]["Mode"]);
tmpModeZheWangSet.Info = All.Class.Num.ToString(dt.Rows[i]["ModeInfo"]);
result.Add(tmpModeZheWangSet);
}
}
}
return(result);
}
