/// <summary>
/// 新增一筆資料
/// </summary>
/// <param name="CCC">傳入存放更新資料的SIS.Configuration.ClsCompanyConfig</param>
/// <returns></returns>
public bool InsertData(SIS.Configuration.ClsCompanyConfig CCC)
{
InitDB();
string insertCmd;
insertCmd = "Insert Into " + TableName + " (CompanyID,CNAME,ENAME,UnifiedBusinessNo,CompanyType,Owner,Contact,Phone,MobilePhone,Fax,Address,WebSite,Notes";
insertCmd = insertCmd + ") Values(";
insertCmd = insertCmd + "'" + CCC.CompanyID + "',";
insertCmd = insertCmd + "'" + CCC.CNAME + "',";
insertCmd = insertCmd + "'" + CCC.ENAME + "',";
insertCmd = insertCmd + "'" + CCC.UnifiedBusinessNo + "',";
insertCmd = insertCmd + "'" + CCC.CompanyType + "',";
insertCmd = insertCmd + "'" + CCC.Owner + "',";
insertCmd = insertCmd + "'" + CCC.Contact + "',";
insertCmd = insertCmd + "'" + CCC.Phone + "',";
insertCmd = insertCmd + "'" + CCC.MobilePhone + "',";
insertCmd = insertCmd + "'" + CCC.Fax + "',";
insertCmd = insertCmd + "'" + CCC.Address + "',";
insertCmd = insertCmd + "'" + CCC.WebSite + "',";
insertCmd = insertCmd + "'" + CCC.Notes + "'";
insertCmd = insertCmd + ")";
try
{
cmd = new SqlCommand(insertCmd, conn);
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
conn.Close();
return(false);
}
}
/// <summary>
/// 更新一筆資料
/// </summary>
/// <param name="CCC">傳入存放更新資料的SIS.Configuration.ClsCompanyConfig</param>
/// <returns></returns>
public bool Update(SIS.Configuration.ClsCompanyConfig CCC)
{
InitDB();
string updateCmd;
updateCmd = "UPDATE " + TableName + " SET ";
updateCmd = updateCmd + " CompanyID='" + CCC.CompanyID + "',";
updateCmd = updateCmd + " CNAME='" + CCC.CNAME + "',";
updateCmd = updateCmd + " ENAME='" + CCC.ENAME + "',";
updateCmd = updateCmd + " UnifiedBusinessNo='" + CCC.UnifiedBusinessNo + "',";
updateCmd = updateCmd + " CompanyType='" + CCC.CompanyType + "',";
updateCmd = updateCmd + " Owner='" + CCC.Owner + "',";
updateCmd = updateCmd + " Contact='" + CCC.Contact + "',";
updateCmd = updateCmd + " Phone='" + CCC.Phone + "',";
updateCmd = updateCmd + " MobilePhone='" + CCC.MobilePhone + "',";
updateCmd = updateCmd + " Fax='" + CCC.Fax + "',";
updateCmd = updateCmd + " Address='" + CCC.Address + "',";
updateCmd = updateCmd + " WebSite='" + CCC.WebSite + "',";
updateCmd = updateCmd + " Notes='" + CCC.Notes + "'";
updateCmd = updateCmd + " WHERE CompanyID='" + CCC.CompanyID + "'";
try
{
cmd = new SqlCommand(updateCmd, conn);
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
conn.Close();
return(false);
}
}
