/// <summary> /// /// </summary> /// <returns>int</returns> public static int usp_Service_Init(DI.usp_Service_InitParameters p) { SqlCommand cmd = DC.NewCmd_usp_Service_Init(p); 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; } }
/// <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; } }
/// <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; } }