/// <summary>
///
/// </summary>
/// <returns>int</returns>
public static int usp_ServiceInstance_Insert_TCPIP(DI.usp_ServiceInstance_Insert_TCPIPParameters p)
{
SqlCommand cmd = DC.NewCmd_usp_ServiceInstance_Insert_TCPIP(p);
if (p.CheckIsServiceIDChanged())
{
object o = p.ServiceID;
if (o == null) cmd.Parameters["ServiceID"].Value = DBNull.Value;
else cmd.Parameters["ServiceID"].Value = o;
}
if (p.CheckIsCreateTimeChanged())
{
object o = p.CreateTime;
if (o == null) cmd.Parameters["CreateTime"].Value = DBNull.Value;
else cmd.Parameters["CreateTime"].Value = o;
}
if (p.CheckIsDescriptionChanged())
{
object o = p.Description;
if (o == null) cmd.Parameters["Description"].Value = DBNull.Value;
else cmd.Parameters["Description"].Value = o;
}
SQLHelper.ExecuteNonQuery(cmd);
string s = cmd.Parameters["RETURN_VALUE"].Value.ToString();
if (string.IsNullOrEmpty(s))
{
p.SetReturnValue(0);
return 0;
}
else
{
p.SetReturnValue(int.Parse(s));
return p._ReturnValue;
}
}
public static SqlCommand NewCmd_usp_Service_Insert(DI.usp_Service_InsertParameters p)
{
SqlCommand cmd = new SqlCommand("[usp].[Service_Insert]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("RETURN_VALUE", System.Data.SqlDbType.Int, 0, ParameterDirection.ReturnValue, false, 0, 0, null, DataRowVersion.Current, null));
if (p.CheckIsServiceTypeIDChanged())
{
cmd.Parameters.Add(new SqlParameter("ServiceTypeID", System.Data.SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "ServiceTypeID", DataRowVersion.Current, null));
}
if (p.CheckIsCreateTimeChanged())
{
cmd.Parameters.Add(new SqlParameter("CreateTime", System.Data.SqlDbType.DateTime2, 8, ParameterDirection.Input, false, 27, 7, "CreateTime", DataRowVersion.Current, null));
}
if (p.CheckIsNameChanged())
{
cmd.Parameters.Add(new SqlParameter("Name", System.Data.SqlDbType.NVarChar, 50, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Current, null));
}
if (p.CheckIsVersionChanged())
{
cmd.Parameters.Add(new SqlParameter("Version", System.Data.SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "Version", DataRowVersion.Current, null));
}
if (p.CheckIsFilePathChanged())
{
cmd.Parameters.Add(new SqlParameter("FilePath", System.Data.SqlDbType.NVarChar, 250, ParameterDirection.Input, false, 0, 0, "FilePath", DataRowVersion.Current, null));
}
if (p.CheckIsDescriptionChanged())
{
cmd.Parameters.Add(new SqlParameter("Description", System.Data.SqlDbType.NVarChar, -1, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Current, null));
}
return cmd;
}
/// <summary>
///
/// </summary>
/// <returns>int</returns>
public static int usp_Service_Update(DI.usp_Service_UpdateParameters p)
{
SqlCommand cmd = DC.NewCmd_usp_Service_Update(p);
if (p.CheckIsOriginal_ServiceIDChanged())
{
object o = p.Original_ServiceID;
if (o == null) cmd.Parameters["Original_ServiceID"].Value = DBNull.Value;
else cmd.Parameters["Original_ServiceID"].Value = o;
}
if (p.CheckIsServiceTypeIDChanged())
{
object o = p.ServiceTypeID;
if (o == null) cmd.Parameters["ServiceTypeID"].Value = DBNull.Value;
else cmd.Parameters["ServiceTypeID"].Value = o;
}
if (p.CheckIsNameChanged())
{
object o = p.Name;
if (o == null) cmd.Parameters["Name"].Value = DBNull.Value;
else cmd.Parameters["Name"].Value = o;
}
if (p.CheckIsVersionChanged())
{
object o = p.Version;
if (o == null) cmd.Parameters["Version"].Value = DBNull.Value;
else cmd.Parameters["Version"].Value = o;
}
if (p.CheckIsFilePathChanged())
{
object o = p.FilePath;
if (o == null) cmd.Parameters["FilePath"].Value = DBNull.Value;
else cmd.Parameters["FilePath"].Value = o;
}
if (p.CheckIsDescriptionChanged())
{
object o = p.Description;
if (o == null) cmd.Parameters["Description"].Value = DBNull.Value;
else cmd.Parameters["Description"].Value = o;
}
SQLHelper.ExecuteNonQuery(cmd);
string s = cmd.Parameters["RETURN_VALUE"].Value.ToString();
if (string.IsNullOrEmpty(s))
{
p.SetReturnValue(0);
return 0;
}
else
{
p.SetReturnValue(int.Parse(s));
return p._ReturnValue;
}
}