public void UpdateLuckyMemberInfo(InstallmentInfo installmentInfo, string COLPhone, string CSEngineNo)
{
SQLConn sQLConn = new SQLConn();
string query = @"Update installmentinfo set
OLPhone = @OLPhone , SEngineNo = @SEngineNo , IAmount = @IAmount
, DDate = @DDate , IDate = @IDate
where OLPhone = @COLPhone and SEngineNo = @CSEngine";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "OLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = installmentInfo.OLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "SEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = installmentInfo.SEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "IAmount",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = installmentInfo.IAmount
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "DDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = installmentInfo.DDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "IDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = installmentInfo.IDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "COLPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = COLPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CSEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CSEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}