/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MExpressItemConfig model)
{
#region SQL语句
const string sql = @"
INSERT INTO [T_PrintItem] (
[ItemID]
,[Font]
,[FontSize]
,[SeqNo]
,[Visable]
,[UUID]
,[TemplateName]
,[ItemlName]
,[ItemlCode]
,[Wight]
,[Helght]
,[LeftAway]
,[TopAway]
,[PrintColor]
)
VALUES (
@ItemID
,@Font
,@FontSize
,@SeqNo
,@Visable
,@UUID
,@TemplateName
,@ItemlName
,@ItemlCode
,@Wight
,@Helght
,@LeftAway
,@TopAway
,@PrintColor
);";
#endregion
var res = SqlHelper.ExecuteScalar(CommandType.Text, sql,
new SQLiteParameter("@ItemID", SqlHelper.ToNullDBValue(model.ItemID)),
new SQLiteParameter("@Font", SqlHelper.ToNullDBValue(model.Font)),
new SQLiteParameter("@FontSize", SqlHelper.ToNullDBValue(model.FontSize)),
new SQLiteParameter("@SeqNo", SqlHelper.ToNullDBValue(model.SeqNo)),
new SQLiteParameter("@Visable", SqlHelper.ToNullDBValue(model.Visable)),
new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)),
new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)),
new SQLiteParameter("@ItemlName", SqlHelper.ToNullDBValue(model.ItemlName)),
new SQLiteParameter("@ItemlCode", SqlHelper.ToNullDBValue(model.ItemlCode)),
new SQLiteParameter("@Wight", SqlHelper.ToNullDBValue(model.Wight)),
new SQLiteParameter("@Helght", SqlHelper.ToNullDBValue(model.Helght)),
new SQLiteParameter("@LeftAway", SqlHelper.ToNullDBValue(model.LeftAway)),
new SQLiteParameter("@TopAway", SqlHelper.ToNullDBValue(model.TopAway)),
new SQLiteParameter("@PrintColor", SqlHelper.ToNullDBValue(model.PrintColor))
);
return(res == null ? 0 : Convert.ToInt32(res));
}
/// <summary>
/// 选好遍历界面控件
/// </summary>
/// <param name="objControlCollection"></param>
public void InitialControl(Control.ControlCollection controlCollection)
{
foreach (Control objControl in controlCollection)
{
TXTextBox myTextBox = objControl as TXTextBox;
if (myTextBox == null)
{
continue;
}
MExpressItemConfig myItemConfig = myTextBox.Tag as MExpressItemConfig;
if (myItemConfig == null)
{
continue;
}
myItemConfig.LeftAway = myTextBox.Location.X;
myItemConfig.TopAway = myTextBox.Location.Y;
m_ItemConfigBll.Update(myItemConfig);
}
}
/// <summary>
/// 创建配置项
/// </summary>
/// <returns></returns>
private TXTextBox CreateTextBox(MExpressItemConfig ItemConfig)
{
try
{
TXTextBox myTextBox = new TXTextBox();
myTextBox.Name = ItemConfig.ItemlCode;
myTextBox.Text = ItemConfig.ItemlName;
myTextBox.IsCanDrag = true;
myTextBox.Multiline = true;
myTextBox.Size = new Size(ItemConfig.Wight, ItemConfig.Helght);
myTextBox.Location = new Point(ItemConfig.LeftAway, ItemConfig.TopAway);
myTextBox.Font = new Font(new FontFamily(ItemConfig.Font), Convert.ToInt32(ItemConfig.FontSize));
myTextBox.Tag = ItemConfig;
return(myTextBox);
}
catch (Exception)
{
return(new TXTextBox());
}
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MExpressItemConfig model)
{
#region SQL语句
const string sql = @"
UPDATE [T_PrintItem]
SET
[ItemID] = @ItemID
,[Font] = @Font
,[FontSize] = @FontSize
,[SeqNo] = @SeqNo
,[Visable] = @Visable
,[UUID] = @UUID
,[TemplateName] = @TemplateName
,[ItemlName] = @ItemlName
,[ItemlCode] = @ItemlCode
,[Wight] = @Wight
,[Helght] = @Helght
,[LeftAway] = @LeftAway
,[TopAway] = @TopAway
,[PrintColor] = @PrintColor
WHERE [ItemID] = @ItemID";
#endregion
return(SqlHelper.ExecuteNonQuery(CommandType.Text, sql,
new SQLiteParameter("@ItemID", SqlHelper.ToNullDBValue(model.ItemID)),
new SQLiteParameter("@Font", SqlHelper.ToNullDBValue(model.Font)),
new SQLiteParameter("@FontSize", SqlHelper.ToNullDBValue(model.FontSize)),
new SQLiteParameter("@SeqNo", SqlHelper.ToNullDBValue(model.SeqNo)),
new SQLiteParameter("@Visable", SqlHelper.ToNullDBValue(model.Visable)),
new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)),
new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)),
new SQLiteParameter("@ItemlName", SqlHelper.ToNullDBValue(model.ItemlName)),
new SQLiteParameter("@ItemlCode", SqlHelper.ToNullDBValue(model.ItemlCode)),
new SQLiteParameter("@Wight", SqlHelper.ToNullDBValue(model.Wight)),
new SQLiteParameter("@Helght", SqlHelper.ToNullDBValue(model.Helght)),
new SQLiteParameter("@LeftAway", SqlHelper.ToNullDBValue(model.LeftAway)),
new SQLiteParameter("@TopAway", SqlHelper.ToNullDBValue(model.TopAway)),
new SQLiteParameter("@PrintColor", SqlHelper.ToNullDBValue(model.PrintColor))
));
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MExpressItemConfig model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MExpressItemConfig model)
{
return(_dao.Insert(model));
}
