public PrintCountMDL GetDataByKeyName(string keyName)
{
string format = string.Empty;
PrintCountMDL tmdl = null;
DataSet set = null;
try
{
format = "select tid, keyname, keycount, updatetime, remark from print_count where keyname='{0}'";
format = string.Format(format, keyName);
set = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, format, null);
if (set.Tables[0].Rows.Count > 0)
{
tmdl = new PrintCountMDL();
tmdl.TID = Convert.ToInt32(set.Tables[0].Rows[0]["tid"]);
tmdl.KeyName = keyName;
tmdl.KeyCount = Convert.ToInt32(set.Tables[0].Rows[0]["keycount"]);
tmdl.UpdapteTime = Convert.ToDateTime(set.Tables[0].Rows[0]["updatetime"]);
tmdl.Remark = set.Tables[0].Rows[0]["remark"].ToString();
}
}
catch (Exception exception)
{
tmdl = null;
CLog.WriteErrLogInTrace(exception.Message);
}
finally
{
if (set != null)
{
set.Dispose();
}
}
return(tmdl);
}
public int UpdateByKeyName(PrintCountMDL mdl)
{
int num = 0;
string format = string.Empty;
try
{
format = "update print_count set keycount={0},updatetime=now() where keyname='{1}'";
format = string.Format(format, mdl.KeyCount, mdl.KeyName);
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, format, null);
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
}
return(num);
}
public int InsertData(PrintCountMDL mdl)
{
int num = 0;
string cmdText = string.Empty;
try
{
cmdText = "insert into print_count (";
cmdText = string.Format(cmdText + "keyname, keycount, updatetime, remark) values (" + "'{0}', 1, now(), '')", mdl.KeyName);
num = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, cmdText, null);
}
catch (Exception exception)
{
CLog.WriteErrLogInTrace(exception.Message);
}
return(num);
}
