固定合同管理API - 新增、查询、删除

/// <summary>
/// 固定合同管理API
/// </summary>
public class HTCManager
{
    /// <summary>
    /// 更新固定合同内容
    /// </summary>
    /// <param name="htc"></param>
    /// <returns></returns>
    public bool UpdateHTC(HTC htc)
    {
        string sql = "UPDATE HTC SET HTCName='" + htc.HTCName + "', HTCStartDate='" + htc.HTCStartDate + "', HTCEndDate='" + htc.HTCEndDate + "',
            HTCCompany='" + htc.HTCCompany + "', HTCMoney=" + htc.HTCMoney + " WHERE HTCID=" + htc.HTCID;
        int m = sqlHelper.ExecuteNonQuery(sql);
        return m > 0;
    }

    /// <summary>
    /// 根据ID查询固定合同
    /// </summary>
    /// <param name="htcID"></param>
    /// <returns></returns>
    public HTC SelectHTCByID(int htcID)
    {
        string sql = "SELECT * FROM HTC WHERE HTCID=" + htcID;
        HTC htc = new HTC();
        DataTable dataTable = sqlHelper.GetDataTable(sql);
        if (dataTable != null && dataTable.Rows.Count > 0)
        {
            htc.HTCID = (int)dataTable.Rows[0]["HTCID"];
            htc.HTCName = dataTable.Rows[0]["HTCName"].ToString();
            htc.HTCStartDate = DateTime.Parse(dataTable.Rows[0]["HTCStartDate"].ToString());
            htc.HTCEndDate = DateTime.Parse(dataTable.Rows[0]["HTCEndDate"].ToString());
            htc.HTCCompany = dataTable.Rows[0]["HTCCompany"].ToString();
            htc.HTCMoney = (decimal)dataTable.Rows[0]["HTCMoney"];
        }
        return htc;
    }

    /// <summary>
    /// 根据ID删除固定合同
    /// </summary>
    /// <param name="htcID"></param>
    /// <returns></returns>
    public bool DeleteHTCByID(int htcID)
    {
        string sql = "DELETE FROM HTC WHERE HTCID=" + htcID;
        int m = sqlHelper.ExecuteNonQuery(sql);
        return m > 0;
    }
}