///<summary></summary>
public static void Update(RefAttach attach){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),attach);
return;
}
Crud.RefAttachCrud.Update(attach);
}
///<summary></summary>
public static long Insert(RefAttach attach) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
attach.RefAttachNum=Meth.GetLong(MethodBase.GetCurrentMethod(),attach);
return attach.RefAttachNum;
}
return Crud.RefAttachCrud.Insert(attach);
}
///<summary></summary>
public static void Delete(RefAttach attach){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),attach);
return;
}
string command= "DELETE FROM refattach "
+"WHERE refattachnum = '"+attach.RefAttachNum+"'";
Db.NonQ(command);
}
///<summary></summary>
public static void Delete(RefAttach attach)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), attach);
return;
}
string command = "UPDATE refattach SET ItemOrder=ItemOrder-1 WHERE PatNum=" + POut.Long(attach.PatNum)
+ " AND ItemOrder > " + POut.Int(attach.ItemOrder);
Db.NonQ(command);
command = "DELETE FROM refattach "
+ "WHERE refattachnum = " + POut.Long(attach.RefAttachNum);
Db.NonQ(command);
}