本文整理汇总了C#中Erc.Apple.Data.StoredProcedure.ExecuteNonQuery方法的典型用法代码示例。如果您正苦于以下问题：C# StoredProcedure.ExecuteNonQuery方法的具体用法？C# StoredProcedure.ExecuteNonQuery怎么用？C# StoredProcedure.ExecuteNonQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Erc.Apple.Data.StoredProcedure的用法示例。
在下文中一共展示了StoredProcedure.ExecuteNonQuery方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Clear
public static bool Clear()
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("Log_Clear"))
{
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例2: DeleteImageByGroupID
public bool DeleteImageByGroupID(int groupID)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("Products_DeleteImage"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例3: Delete
public bool Delete(Service item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("ServiceSpecialization_DeleteByService"))
{
sp.Params.Add("@ServiceID", System.Data.SqlDbType.Int).Value = item.GroupID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例4: Delete
public virtual bool Delete(ContactForm item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("ContactForms_DeleteItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例5: DeleteGroup
public bool DeleteGroup(City item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("Cities_DeleteGroup"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例6: Delete
public bool Delete(PageHtml item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("PagesHtml_DeleteItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 100).Value = item.Name;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例7: Delete
public bool Delete(NewsSubscriber item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("NewsSubscribers_DeleteItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例8: Delete
public static bool Delete(DbConfigItem item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("DbConfig_DeleteItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例9: Delete
public bool Delete(int partnerID)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("PartnerSpecialization_DeleteByPartner"))
{
sp.Params.Add("@PartnerID", System.Data.SqlDbType.Int).Value = partnerID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例10: Update
public bool Update(ContentPage item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("ContentPages_UpdateItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = item.Name;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例11: DeleteById
public void DeleteById(SeminarRegistration s)
{
if (s != null)
{
using (
StoredProcedure sp =
new StoredProcedure("DELETE FROM SeminarsRegistration WHERE ID=" + s.ID.ToString()))
{
sp.command.CommandType = CommandType.Text;
sp.ExecuteNonQuery();
}
}
}示例12: Delete
public virtual void Delete(iPadActionSerial item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("iPadActionSerial_DeleteItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
try
{
sp.ExecuteNonQuery();
}
catch (Exception ex)
{
Debug.WriteLine("iPadActionSerial_DeleteItem:" + ex.ToString());
}
}
}示例13: Update
public virtual bool Update(ContactForm item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("ContactForms_UpdateItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
sp.Params.Add("@Subject", System.Data.SqlDbType.NVarChar, 255).Value = item.Subject;
sp.Params.Add("@To", System.Data.SqlDbType.NVarChar).Value = item.To;
sp.Params.Add("@CC", System.Data.SqlDbType.NVarChar).Value = item.CC;
sp.Params.Add("@SetForAll", System.Data.SqlDbType.Bit).Value = item.SetForAllForms;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例14: Save
public static bool Save(string name,string value)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("DbConfig_AddUpdateItem"))
{
sp.Params.Add("@Name", System.Data.SqlDbType.NVarChar, 255).Value = name;
sp.Params.Add("@Value", System.Data.SqlDbType.NVarChar).Value = value;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}示例15: Update
public bool Update(SerialNumber item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("SerialNumbers_UpdateItem"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = item.ID;
sp.Params.Add("@SerialNumber", System.Data.SqlDbType.NVarChar, 20).Value = item.Number;
sp.Params.Add("@ServiceID", System.Data.SqlDbType.Int).Value = item.ServiceID;
sp.Params.Add("@AdminID", System.Data.SqlDbType.Int).Value = item.AdminID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}