/// <summary>
/// 新增一筆資料-新增圖片用
/// </summary>
/// <param name="ClsCustomerConfig"></param>
/// <returns></returns>
public bool ParameterInsertData(SIS.Configuration.ClsCustomerConfig CCC)
{
InitDB();
string insertCmd = null;
insertCmd = "INSERT INTO " + TableName + " (CustomerID,CNAME,ENAME,Photos,Birthday,CustomerType,Phone,MobilePhone,Fax,Address,Notes) VALUES (@CustomerID,@CNAME,@ENAME,@Photos,@Birthday,@CustomerType,@Phone,@MobilePhone,@Fax,@Address,@Notes)";
try
{
cmd = new SqlCommand(insertCmd, conn);
cmd.Parameters.Add(new SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 20));
cmd.Parameters.Add(new SqlParameter("@CNAME", System.Data.SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@ENAME", System.Data.SqlDbType.NVarChar, 30));
cmd.Parameters.Add(new SqlParameter("@Photos", System.Data.SqlDbType.Image));
cmd.Parameters.Add(new SqlParameter("@Birthday", System.Data.SqlDbType.NVarChar, 12));
cmd.Parameters.Add(new SqlParameter("@CustomerType", System.Data.SqlDbType.NVarChar, 5));
cmd.Parameters.Add(new SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@MobilePhone", System.Data.SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Fax", System.Data.SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Address", System.Data.SqlDbType.NVarChar, 100));
cmd.Parameters.Add(new SqlParameter("@Notes", System.Data.SqlDbType.NVarChar, -1)); //Size set -1 eqal Max
cmd.Parameters["@CustomerID"].Value = CCC.CustomerID;
cmd.Parameters["@CNAME"].Value = CCC.CNAME;
cmd.Parameters["@ENAME"].Value = CCC.ENAME;
cmd.Parameters["@Photos"].Value = CCC.Photos;
cmd.Parameters["@Birthday"].Value = CCC.Birthday;
cmd.Parameters["@CustomerType"].Value = CCC.CustomerType;
cmd.Parameters["@Phone"].Value = CCC.Phone;
cmd.Parameters["@MobilePhone"].Value = CCC.MobilePhone;
cmd.Parameters["@Fax"].Value = CCC.Fax;
cmd.Parameters["@Address"].Value = CCC.Address;
cmd.Parameters["@Notes"].Value = CCC.Notes;
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
conn.Close();
return(false);
}
}
/// <summary>
/// 更新資料
/// </summary>
/// <param name="CCC">傳入SIS.Configuration.ClsCustomerConfig</param>
/// <returns></returns>
/// <remarks></remarks>
public bool ParameterUpdateData(SIS.Configuration.ClsCustomerConfig CCC)
{
InitDB();
string updateCmd = null;
int i = 0;
updateCmd = "UPDATE " + TableName + " SET CustomerID=@CustomerID ," +
"CNAME=@CNAME , " +
"ENAME = @ENAME , " +
"Photos = @Photos , " +
"Birthday = @Birthday ," +
"CustomerType = @CustomerType ," +
"Phone=@Phone , " +
"MobilePhone = @MobilePhone ," +
"Fax = @Fax ," +
"Address=@Address , " +
"Notes = @Notes " +
" WHERE (CustomerID =" + " @Original_CustomerID)";
try
{
cmd = new SqlCommand(updateCmd, conn);
cmd.Parameters.Add(new SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 0, "CustomerID"));
cmd.Parameters.Add(new SqlParameter("@CNAME", System.Data.SqlDbType.NVarChar, 0, "CNAME"));
cmd.Parameters.Add(new SqlParameter("@ENAME", System.Data.SqlDbType.NVarChar, 0, "ENAME"));
cmd.Parameters.Add(new SqlParameter("@Photos", System.Data.SqlDbType.Image, 0, "Photos"));
cmd.Parameters.Add(new SqlParameter("@Birthday", System.Data.SqlDbType.NVarChar, 0, "Birthday"));
cmd.Parameters.Add(new SqlParameter("@CustomerType", System.Data.SqlDbType.NVarChar, 0, "CustomerType"));
cmd.Parameters.Add(new SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 0, "Phone"));
cmd.Parameters.Add(new SqlParameter("@MobilePhone", System.Data.SqlDbType.NVarChar, 0, "MobilePhone"));
cmd.Parameters.Add(new SqlParameter("@Fax", System.Data.SqlDbType.NVarChar, 0, "Fax"));
cmd.Parameters.Add(new SqlParameter("@Address", System.Data.SqlDbType.NVarChar, 0, "Address"));
cmd.Parameters.Add(new SqlParameter("@Notes", System.Data.SqlDbType.NVarChar, 0, "Notes"));
cmd.Parameters.Add(new SqlParameter("@Original_CustomerID", System.Data.SqlDbType.NVarChar, 0, "CustomerID"));
cmd.Parameters["@Original_CustomerID"].SourceVersion = DataRowVersion.Original;
cmd.Parameters["@CustomerID"].Value = CCC.CustomerID;
cmd.Parameters["@CNAME"].Value = CCC.CNAME;
cmd.Parameters["@ENAME"].Value = CCC.ENAME;
cmd.Parameters["@Photos"].Value = CCC.Photos;
cmd.Parameters["@Birthday"].Value = CCC.Birthday;
cmd.Parameters["@CustomerType"].Value = CCC.CustomerType;
cmd.Parameters["@Phone"].Value = CCC.Phone;
cmd.Parameters["@MobilePhone"].Value = CCC.MobilePhone;
cmd.Parameters["@Fax"].Value = CCC.Fax;
cmd.Parameters["@Address"].Value = CCC.Address;
cmd.Parameters["@Notes"].Value = CCC.Notes;
cmd.Parameters["@Original_CustomerID"].Value = CCC.CustomerID;
i = cmd.ExecuteNonQuery();
conn.Close();
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
conn.Close();
errorMsg = ex.Message;
return(false);
}
}
